Home -> Usenet -> comp.databases.oracle -> Oracle SQL help.

Oracle SQL help.

From: Josh <netfall_at_yahoo.com>
Date: 24 May 2001 04:37:35 -0700
Message-ID: <9092672b.0105240337.11142b92_at_posting.google.com> 






I'm trying to create a website using Oracle to place retail orders.
When I choose a customer to create an order for, I want to create a
blank order and then return the number for that order (which is
automatically created) back in a recordset, so that I can go to a
subsequent page and add items to that order (items are in a separate
table and have a foreign_key to the orders table).
I can automatically create the key for the orders table (which will
serve as order number, created using a stored function and a
keys_table), but I can't figure out how to return that Key number in a
recordset.  I know I could just select the last key from the
keys_table, but if there are multiple users and netlag at all, that's
going to throw things off.



Any suggestions?  I'm even open to a completely new way of processing
this!



Thanks for any help!



Josh
Received on Thu May 24 2001 - 13:37:35 CEST












Original text of this message