General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Remote Table Access
In my app I type in a drawing number. Then code takes this number a attempts to find a matching drawing number in a table on a remote system. If match is made the record is displayed in the app for view/update. Normally the drawing number is six digits example(852604). This is easy enough to match and a navigation button can scroll through sequiential drawing numbers by adding 1 to the current drawing number and finding that match. The trouble I am running into is now some of the drawings are taking on dash numbers example(852604-401, 852604-403 etc.) This can happen anywhere in the numbering system. How can I make code be flexible enough to find a draiwng number that is next in sequince that has an appended dash number and know when the next number is only 6 digits? Thanks
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