Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using an sql statement as a condition in another action
Message
From
31/03/2000 15:01:12
Peter Malone
Kingborough College,Cuny
New York City, New York, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using an sql statement as a condition in another action
Miscellaneous
Thread ID:
00353571
Message ID:
00353571
Views:
57
I have a table with three fields, including one logical. I want to change the logical to .T. for every record that contains a unique entry. I've tried REPLACE MyTABLE.FIELD3 WITH .T. FOR (SELECT DISTINCT FIELD2 FROM MyTABLE) but I get a "Function name is missing )." What am I doing wrong?
Next
Reply
Map
View

Click here to load this message in the networking platform