delete records in foxpro 
Author Message
 delete records in foxpro

i am using ADO...
connecting to a foxpro database via DSN...

i am using...rs.open "delete from abc.dbf where empcode='" & sdfkjdkf &
"'",cn,3,1

this statement is deleting the record from the foxpro table, but it is not
parmanently deleting from the table..

Dipak



Wed, 18 Aug 2004 12:46:12 GMT  
 delete records in foxpro
What provider are you using?


Quote:
> i am using ADO...
> connecting to a foxpro database via DSN...

> i am using...rs.open "delete from abc.dbf where empcode='" & sdfkjdkf &
> "'",cn,3,1

> this statement is deleting the record from the foxpro table, but it is not
> parmanently deleting from the table..

> Dipak



Wed, 18 Aug 2004 15:53:26 GMT  
 delete records in foxpro
One more question... is this a "free" table, or is it bound to a .dbc?


Quote:
> i am using ADO...
> connecting to a foxpro database via DSN...

> i am using...rs.open "delete from abc.dbf where empcode='" & sdfkjdkf &
> "'",cn,3,1

> this statement is deleting the record from the foxpro table, but it is not
> parmanently deleting from the table..

> Dipak



Wed, 18 Aug 2004 15:55:31 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Cannot delete record on FoxPro 2.5 DB

2. Deleted Records Under FoxPro 2.6

3. delete records in Foxpro

4. Delete records in foxpro

5. How Do I NOT Display deleted records using FoxPro 2.5 Database

6. Cannot add record to Visual Foxpro table after deleting all records in table

7. Foxpro database (Deleted Records)

8. Foxpro Deleted Records

9. deleting records from a Foxpro database

10. Handling A deleted Foxpro Record

11. Accessing Foxpro dbf - deleted records

12. FoxPro ODBC Driver Shows Deleted Records

 

 
Powered by phpBB® Forum Software