Hi y'all,

I have the same need that Dave outlined in his original post so
I am interested in seeing any and all approaches to this problem.

Using ManMan, we have flat files containing control number records
for documents like sales orders and work orders.  The traditional
programming approach is to...
  -lock the file with waiting
  -read the current "next number" from the file
  -increment the current "next number"
  -write the current "next number" back to the same record
  -unlock the file

So to echo Dave's fundamental question, how do you do this
using ODBC?  Any and all suggestions appreciated including
those from MiniSoft. {;-)

Enquiring minds want to know...
Chip Dorman
Greenfield Industries/KMT


Kenhp3000-L wrote:

> Hi Dave
>
> We develop client server apps. using the LINKWAY ODBC driver.
>
> This type of operation is quite common and the most efficient way is to
> create a stored procedure which does these steps ending by returning the
> next record number ( or zero or some other special value if it fails).
>
> Ken Vickers
>
> LINKWAY Development and Support