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
__________________________________
Computing Solutions Limited

Tel. +44 1905 794400
Fax. +44 1905 794464
mailto:[log in to unmask]
http://www.csllink.com
__________________________________

----- Original Message -----
From: Dave Knispel <[log in to unmask]>
To: <[log in to unmask]>
Sent: 12 April 2000 21:38
Subject: ODBC Challenges


To the HP3000-L,

Here's what I'm trying to do from a web page using Visual Basic.  I'm
currently doing this same type of process from Powerhouse in Quick screens
on my HP3000.
  a.. Lock the control record
  b.. Get the control record (from an image DB) containing the last order
number used
  c.. Add 1 to that number
  d.. Verify that it has not been used before (check three different
databases)
  e.. Update the last order number entry
  f.. Unlock the control record
I know how to do this in Image/Cobol.  Powerhouse seems to be handling this
process okay also.  The problem I'm having is with SQL or Minisoft's ODBC
drivers.  How can I do the same type of process?  Has anyone out there done
this type of function?  How do I lock around a transaction?  Is that what I
need to do?

Any help would be greatly appreciated.

David Knispel
[log in to unmask]
Phone: 513-248-5029
Fax: 513-248-2672