Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getfldstate
Message
From
31/08/2000 16:57:18
 
 
To
31/08/2000 16:51:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00411511
Message ID:
00411514
Views:
9
>Hi all.
>
>I'm changing multiple rows in a buffered(5) table.
>
>My code is:
>
>SELECT myAlias
>DO WHILE myfield = lcVariable and !eof()
> replace myfield2 with myVariable
> skip
>ENDDO
>
>now, after it exits the DO WHILE loop, the record pointer is pointing to a record that has not been changed, so GETFLDSTATE(-1) returns "11111111...".
>
>Must I move the pointer back one (SKIP-1) record after going through the loop. This doesn't seem right.
>
>Any thoughts? thanks

Use GETNEXTMODIFIED() instead of GETFLDSTATE() when using table buffering to determine if any records have changed.
Once your on the change record, you can use GETFLDSTATE() to check specifics.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform