Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using Update and a Counter
Message
 
To
20/09/2000 21:22:36
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00417759
Message ID:
00419013
Views:
31
>At first it may seem bad to have to wait until the update and read to get the id. In a accounting package I did, before clearing the screen after a commit, I would give a message back with the ID number so they could write it on the hard copy for reference. They soon get used to it and actually prefer that to burnning up numbers.
>
>hth
>Mike D

Unfortunatly we had it that way and they asked us to change it!! We questioned it but they didn't like the fact that they had an extra mouse click on msg box to display the Journal #. Go figure - big clicks get what they want. <g>

anyways were back to the drawing board...Maybe we will get Sql to do the processing and VFP to update the Journal #'s after they have been locked to this serires of entries.

Thanks again

Shawn
Shawn Dorion
Geo Sektor Dot Com
Website: http://www.geosektor.com

Web Hosting Plans
Visit : http://WebHosting.Applications4u.com/
Previous
Reply
Map
View

Click here to load this message in the networking platform