FiveTech Software tech support forums

Hi
I would like to use SQL with a DBF file
any help?

thank you

IF you are using ADS(Advantage Database Server) it's easy:

Code: Select all  Expand view

SELECT 0
AdsCreateSQLStatement( "tmp", 2 )
AdsPrepareSql( cYourSqlStatment )
IF AdsExecuteSql()
  ...
ENDIF
 

hi Vilian,
No, I do not use Ads, it's a simple file.dbf with file.cdx
thank you

Do you mean running SQL-commands on a DBF-database?

hi Marc,
I have my single file ORDINI.DBF with index ORDINI.CDX, I don't want to use Clipper command or function: DbUseArea, DbSetIndex, DbSkip, Dbseek...
I'd like to use for this file a simple SQL command "Select * from ORDINI.DBF WHERE..." and then to use fields.

You can use DBF with SQL statements, using ADO, but it will not allow you to use its indexes.
But you can use the function FW_DBFSQLQUERY

viewtopic.php?f=3&t=26873&p=149080&hilit=FW_DBFSQLQUERY#p149080

Hello,

you can use ADS with DBF/CDX

try to download this sample https://app.box.com/s/r0w5vgxzugucoavqjzpba9he6625gvgu

1.- for a sample define path ./
2.- conectar
3.- in Consulta SQL type select * from customer + ejecutar

regards

Marcelo

P.D.

https://app.box.com/s/t2vd0tfrov42usp1kzgucxxs642bmigx

thank you,
I solved with Navarro.