🚀 go-pugleaf

Hi Stephen,
I'm sorry, I didn't try it. Now I remember...some time ago "Parameter 
'MyField' not found" exception has been the reason why I use 
StringReplace function :-) instead of parameters.
I recommended quotes because I thought the SQL commmand would be wrong 
when you used NULL values ...INSERT INTO myTable (MyField, field2) 
VALUES (, )
I hope someone will give us better answer too.

Sincerely
Ondrej Gratz


Stephen Craig wrote:
> Hi Ondrej,
> Thanks for the reply
> 
> If I use quotes as you described (either single or double (\")) as follows
>     INSERT INTO myTable (MyField, field2) VALUES (':MyField', ':field2')
> and I attempt to set parameters using
>     qry->Parameters->ParamByName("MyField")->Value = "";
> Then I get the error
>     Parameter 'MyField' not found
> 
> Interestingly, if I revert back to
> 
>     INSERT INTO myTable (MyField, field2) VALUES (:MyField, :field2)
> and set the parameter to some string and then set it to a NULL then it all
> is ok.  ie...
>     qry->Parameters->ParamByName("MyField")->Value = "dummy";
>     qry->Parameters->ParamByName("MyField")->Value = "";
> This works perfectly
> 
> I can only imagine that the first assignment is setting some parameter
> property.  Initially I thought that this would be the DataType property.
> But setting this to ftString prior to the NULL assignment ie...
>       qry->Parameters->ParamByName("MyField")->DataType = ftString;
> 
>       qry->Parameters->ParamByName("MyField")->Value = "";
> makes no difference. I get the same old exception ...
>      [Microsoft][ODBC Microsoft Access Driver]Invalid precision value.
> 
> I also tried setting the parameter Attributes to paNullable
>       qry->Parameters->ParamByName("MyField")->Attributes << paNullable;
> Still get exception
> 
> I think I'll just have to use the dummy assignment, unless anyone can come
> up with a better answer
> 
> Steve
> 
> "Ondrej Gratz" <gratzo@atlas.cz> wrote in message
> news:4294958b@newsgroups.borland.com...
> 
>>Enclose string parameters in quotation marks...
>>
>>INSERT INTO myTable (MyField, field2) VALUES (":MyField", ":field2")
>>
>>Sincerely
>>Ondrej Gratz
>>
> 
> 
>