Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to VFP-DOA delete records from MDB fich ?
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00958441
Message ID:
00958474
Views:
18
This message has been marked as a message which has helped to the initial question of the thread.
Bernhart,

I'm not sure what you mean by DOA.

Have you tried to run a SQL delete command?
? SQLExec( lnAccess, "delete from TheTable where ThePK = 123" )
>
>*--> build connection string
>lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +;
>                  "Dbq=" + B +;
>                  "Uid=username;" +;
>                  "Pwd=password;"
>
>
>*--> connect to Access database
>lnAccess = SQLSTRINGCONNECT(lcConnectionStr)
>
>
>
>How to VFP-DOA delete records from MDB fich ?
>
>Thank in advance
>
>bernhart
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform