Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax error
Message
 
 
To
15/08/2007 09:05:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01247986
Message ID:
01248230
Views:
28
Change
USE (ma) alias WorkTable

to

USE (ma) alias WorkTable exclusive

I could not figure out what's wrong with the syntax in this line
delete from WorkTable inner join RecToDelete on WorkTable.telNo = RecToDelete.TelNo
I have VFP8, and INNER JOIN is not listed in DELETE-SQL command in Help.

Anyway,
delete from WorkTable where exists (select * from RecToDelete)
should work in VFP8 as well as in VFP9.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform