Query foxpro .dbf files using sql queries
lazarus / 16-Databases

----------------------------------------------------------------------
jdaz2000 · 2023-07-13 00:57

Does anyone have suggestions on how to use sql query statements to
access multiple foxpro .dbf files

----------------------------------------------------------------------
TRon · 2023-07-13 01:46

afaik you don't as I am not aware of the existence for any SQL support
for DBF databases. The DBF implementation uses filters.

----------------------------------------------------------------------
jdaz2000 · 2023-07-13 02:23

Thanks for your reply.  I looked at DBF but could not figure out how
to query against multiple dbf files to sync keys.

----------------------------------------------------------------------
TRon · 2023-07-13 02:42

You could perhaps opt for a master-detail relationship or otherwise
you would have to do it manually by using filters.

----------------------------------------------------------------------
vags15 · 2023-07-13 04:35

Quote from: jdaz2000 on July 13, 2023, 02:57:48 amDoes anyone have
suggestions on how to use sql query statements to access multiple
foxpro .dbf files
Hello, to use dbf tables install the following driver VFPODBC.msi.
https://github.com/FernandoMCM/odbc_driver

*Windows ODBC data source 32Bit
**DSN File(Add + "Microsoft VisualPro Driver"). Select dbf file path.

Now in lazarus use the ODBCConnection component.
When compiled it should be a 32bit executable.

----------------------------------------------------------------------
paweld · 2023-07-13 05:13

Devart has a component for retrieving data via SQL queries from
sources that are any TDataSet descendant elements. Component is paid:
https://www.devart.com/virtualdac/

----------------------------------------------------------------------
Zvoni · 2023-07-13 06:15

Or just do away with DBF
Hopefully, it gets exterminated finally

----------------------------------------------------------------------
jdaz2000 · 2023-07-13 16:40

Vags15,  I really appreciate you coding up an example.  When I open
the project file I get a Compiler Notice: 

"C:\lazarus\fpc\3.2.2\bin\x86_64\fpc.exe" does not support target
i386-win64

I've searched but can't find out how to correct this.  Any
suggestions?

----------------------------------------------------------------------
dsiders · 2023-07-13 17:53

Quote from: jdaz2000 on July 13, 2023, 06:40:38 pmVags15,  I really
appreciate you coding up an example.  When I open the project file I
get a Compiler Notice: 

"C:\lazarus\fpc\3.2.2\bin\x86_64\fpc.exe" does not support target
i386-win64

I've searched but can't find out how to correct this.  Any
suggestions?

i386 is a 32-bit architecture, so...

----------------------------------------------------------------------
Zvoni · 2023-07-14 04:43

Quote from: dsiders on July 13, 2023, 07:53:47 pmQuote from: jdaz2000
on July 13, 2023, 06:40:38 pmVags15,  I really appreciate you coding
up an example.  When I open the project file I get a Compiler Notice: 

"C:\lazarus\fpc\3.2.2\bin\x86_64\fpc.exe" does not support target
i386-win64

I've searched but can't find out how to correct this.  Any
suggestions?

i386 is a 32-bit architecture, so...
Install cross-compiler

----------------------------------------------------------------------
wp · 2023-07-14 08:04

Or install the 64-bit IDE in addition to the 32-bit IDE. Checking the
"Secondary installation" option in the installer and providing a
dedicated configuration directory are requirements to keep the two
installations separate.

----------------------------------------------------------------------
jdaz2000 · 2023-07-14 13:59

Thanks everyone for your help.  It's all working now.