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