Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple Update SQL
Message
 
 
To
07/04/2004 11:08:40
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00892931
Message ID:
00893050
Views:
26
>select code_conv
>scan
> update codes set code = code_conv.code_new ;
> where code == code_conv.code_old
>endscan

What am I doing wrong? The above went into an endless loop when the codes.dbf was ordered. Now that there is no order the UPDATE is only performed once. After the one time it is performed, the record pointer is at eof.

Brenda
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform