SQLPrimaryKeys + MS Access Driver
lazarus / 16-Databases

----------------------------------------------------------------------
DimProfi · 2007-11-25 02:43

QuoteThe 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?

----------------------------------------------------------------------
DimProfi · 2007-11-26 00:28

Just use Unit "odbcsql" from FPC Package.

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

It works!

----------------------------------------------------------------------
DimProfi · 2007-11-26 00:29

Thanks to mymself.

----------------------------------------------------------------------
jdazag · 2007-11-30 15:08

Hi,

Do you have any sample project?

Thanks 
jdazag

----------------------------------------------------------------------
DimProfi · 2007-12-18 00:50

Quote from: "jdazag"Hi,

Do you have any sample project?

Thanks 
jdazagSee:
lazarus\fpc\2.2.0\source\packages\base\odbc\testodbc.pp

It works!