Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Confused about how VFP handles tableupdates.
Message
From
13/10/2000 16:43:14
 
 
To
13/10/2000 16:21:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00429328
Message ID:
00429382
Views:
22
>Thanks Trey.
>Do you find that GETFLDSTAT(-1) does NOT knows that a record has been changed if the record pointer moves off of the modified record?

Remember, GETFLDSTATE() doesn't know about records - it only knows about fields in the current record.

GETNEXTMODIFIED() is the opposite - it only knows about records - it doesn't know about fields

>
>Finally, what does it mean when GETNEXTMODIFIED(0) returns a negative number?
>
>I know, it sound like I'm completely confused about this. That's because I am.. *G*

That's OK. It's confusing when you first get into it.
A negative number means it's a new record. The further from 0, the newer the record - just like with non-table-buffered data. i.e., -1 is the first new record, -5 is the fifth new record, etc.

>
>The answer to this seems to depend on who you ask; and for a new VFP'er like me that can get frustrating.

If you ask the folks that know (like here on the UT) then you should be getting the same answer. Who are you asking? Would you trust them with writing a program for you? <g>
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform