Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DELETED issues
Message
From
11/04/2000 18:57:09
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
DELETED issues
Miscellaneous
Thread ID:
00358411
Message ID:
00358411
Views:
40
When i run the following I dont know why the deleted records show up in the query. Help.
    strDatabasePath$ = "C:\data"
    strDatabaseName$ = "PPUSQL.DBF"
    cConnectString = "DRIVER=Microsoft Visual FoxPro Driver;UID=;Deleted = No;Null=Yes;Collate = Machine;BackgroundFetch = Yes;Exclusive = No;SourceType = DBF;SourceDB=c:\data"
    
    Set oData = New ADODB.Recordset
    oData.Open "SELECT * FROM " + strDatabaseName, cConnectString, adOpenStatic, adLockReadOnly
~Joe Johnston USA

"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams

Reply
Map
View

Click here to load this message in the networking platform