TDbf and SQL Query
lazarus / 16-Databases

----------------------------------------------------------------------
marc_dsb · 2011-02-23 22:49

Hi all
I am new to the forum and Lazaro with very little experience in
programming, my question is: whether through a TDbf is possible to
make a SQL query on a table in Visual Fox Pro
Thanks

Marcelo

----------------------------------------------------------------------
sorinr · 2011-02-24 11:25

TDbf does not work with usual SQL language. The 'SELECT * FROM
TABLENAME' is implicit.
If you need a WHERE clause you have to use the
TDbf.Filter:=YOURFIELD='YOURVALUE'
then TDbf.Filtered:=True;

----------------------------------------------------------------------
marc_dsb · 2011-02-25 00:52

thanks for the help, I want to take a program to work and do not want
to do any installation on your system, I will try to SQLite and see
what result I have, apparently do not need any installation.

----------------------------------------------------------------------
sorinr · 2011-02-25 05:18

You can also consider Firebird Embedded as an option. It will allow
you to run your program from anywhere as long as you copy the
libraries on the same media.

----------------------------------------------------------------------
marc_dsb · 2011-02-26 10:24

In the use of SQLite is very simple, only sqlite3.dll copy in system32
by default, or in the same folder as the program to use and ready, I'm
taking the first steps and it works.
In the case of Firebird which would be the library or archives to
copy?
Thanks

----------------------------------------------------------------------
jixian.yang · 2011-02-26 15:23

For the embed version, fbembed.dll, icu*.dll and vc runtime library is
required.

----------------------------------------------------------------------
marc_dsb · 2011-02-27 08:00

Ok, thanks for your contribution, I will try.