topic-16944

lailton.webmaster

Posts: 603

Joined: Sun May 04, 2008 08:44 PM

DBF via ADO
Posted: Tue Oct 06, 2009 06:08 AM

Is possible use DBF via ADO ? and use command SQL.

if yes, can show a sample please :?:

thanks so much.

anserkk

Posts: 1335

Joined: Fri Jun 13, 2008 11:04 AM

Re: DBF via ADO
Posted: Tue Oct 06, 2009 07:07 AM

I beleive that you can open DBF files via ADO

Assuming your DBF files exists on C:\

Code (fw): Select all Collapse

oConn:= CreateObject("ADODB.Connection")
oConn:Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended Properties=DBASE IV"

cSQL = "SELECT * FROM HPCLAIM WHERE Peril='WTR' AND Incurred >= 50000 AND Incurred <= 100000"

rsClaims = CreateObject("ADODB.Recordset")
rsClaims:CursorLocation = 3  // adUseClient
rsClaims:CursorType = 3 // adOpenStatic
rsClaims:ActiveConnection:= oConn
rsClaims:Open cSQL

You can use any ODBC statement (Create table, Insert Into, Delete, Select ...). You can address the table using several ways:

Select * from Persons
Select * from Persons.DBF
Insert Into Persons#DBF Values (...)
Delete * from [Persons.DBF] Where ...

Create Table [Any Long File Name You Want] As ...

Regards
Anser

lailton.webmaster

Posts: 603

Joined: Sun May 04, 2008 08:44 PM

Re: DBF via ADO
Posted: Tue Oct 06, 2009 03:44 PM

Perfect.

sygecom

Posts: 58