Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching table without changing recno?
Message
From
15/03/1998 03:01:22
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
13/03/1998 16:00:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00084382
Message ID:
00084708
Views:
31
>>Can anyone tell me how to search table without moving a record pointer?
>>I have table in record buffering mode. I'm adding a new record and I want check some field contents before 'tableupdate'-ing.
>>I used KEYMATCH function but when I called it, validation rules for the record activated. It seems to me that KEYMATCH is changing a recno of the searched table.
>Use again and sql are good for not moving the pointer but what if you want to check a buffered record too (BTW keymatch is worst for me)?
>You should use the buffered table - go check and return. Problem is firing valid events. For that I first check the current record, save contents to an object var, fill with values that are valid (and dummy placeholders), do my check, return to the record and restore contents from saved obj var.
>Cetin

Now this is not clear to me - I've had just the oposite trouble:
- enter a value into a field (bound control)
- its valid method wants to know if this key exists, so it selects another alias of the table
- it finds the buffered record there.
Buffering, I'm not sure (for both aliases), should be 3 or 5.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform