Lazarus

Programming => Databases => Topic started by: DimProfi on November 25, 2007, 03:43:45 am

Title: SQLPrimaryKeys + MS Access Driver
Post by: DimProfi on November 25, 2007, 03:43:45 am
Quote
The MS Access ODBC driver seems not to support the SQLPrimaryKeys API function, hence UpdateIndexDefs will fail. Currently, you must set SQLQuery.ReadOnly:=true; to avoid an exception until code has been added that tests for the availability of the function in the driver


Source: http://wiki.lazarus.freepascal.org/ODBCConn

Is there any solution or walkaround for readwrite-acesss to MS-Access Databases with lazarus?
Title: Help your self is the best solution
Post by: DimProfi on November 26, 2007, 01:28:00 am
Just use Unit "odbcsql" from FPC Package.

See Example in
"lazarus\fpc\2.2.0\source\packages\base\odbc\testodbc.pp"

It works!
Title: RE: Help your self is the best solution
Post by: DimProfi on November 26, 2007, 01:29:35 am
Thanks to mymself.  :D
Title: Odbcsql Unit
Post by: jdazag on November 30, 2007, 04:08:45 pm
Hi,

Do you have any sample project?

Thanks  :D
jdazag
Title: RE: Odbcsql Unit
Post by: DimProfi on December 18, 2007, 01:50:48 am
Quote from: "jdazag"
Hi,

Do you have any sample project?

Thanks  :D
jdazag
See:
lazarus\fpc\2.2.0\source\packages\base\odbc\testodbc.pp

It works!
TinyPortal © 2005-2018