🚀 go-pugleaf

>     [Microsoft][ODBC Microsoft Access Driver]Invalid precision value.

Switch to Jet OLEDB provider - it is native for Access and is better than 
OLEDB provider for ODBC that you use now. Connection string is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydb.mdb;

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Stephen Craig" <stevecraig@ozemail.com.au> �������/�������� � �������� 
���������: news:42966bb3$1@newsgroups.borland.com...
> 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
>>
>
>