🚀 go-pugleaf

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
>