Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursoradaptor against SQL delete
Message
From
24/10/2004 12:27:59
 
 
To
23/10/2004 19:58:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00954041
Message ID:
00954085
Views:
16
Hi Bonnie,

Yes, you need to execute a TableUpdate(.T.) function call. Try doing it from the command window, if it returns a .F. then do something like:
=AERROR(laErr)
?laErr[1,1] && Error number
?laErr[1,2] && Error message
It should at least give you a hint as to why the deletes are not being performed. Also check your DeleteCmd property.

Aloha,

James
>I'm working with cursoradaptors against a SQL db. All of my insert and updates seem to be working fine, but DELETE is not deleting the record. I am using automatic insert/update/delete. I've never had to use =TABLEUPDATE with VFP tables when doing a delete, but seems like I will have to with CA/SQL. Even this does not make the delete work. Am I missing something?
>
>thanks
>
>bonnie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform