General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Record Number/ SEEK() / Edit Mode
How may I return the record number after a SEEK(), INDEXSEEK() or the alikes, withour moving to that record?
For example:
I wish to allow the "ccode" to be changed in a file in "edit" mode.
I would like to search for the new "ccode" entered against the file and if found, would like to compare record number of the found record against the curenct record number being edited. If they are the same I wish to allow the edit, but if they are different I will not allow the "ccode" entered since it was previously created.
Please note, I do not wish to move to the record once it is found since it triggers thing I wish not to be triggered!
In "add" mode it is much simpler, I do not have to compare record numbers. If it is found when I perfrom the search, the new "ccode" being added will not be accepted!
If there is a better method in acheiving this? I would appreciate other suggestions?
Thanks in advace,
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only