on 12/20/99 4:29 AM, Dennis Thrysoe - GeoGrafik A/S at dt@stripped
wrote:
> Hi,
>
> I thought that I should ask all you experienced people, if you would happen
> to have any good ideas on this one:
>
> I need to create new unique IDs on the fly, but auto_increment won't cut it
> as I also need to know what the chosen id is. I need to know the new id
> before I insert the row, as the id is needed as part of the next many row
> and so forth.
>
> We are working on a general solution so that a system that is now based on
> Oracle can also be used with mySQL (or other rdbms).
>
> Any thoughts appreciated.
>
> -dennis
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread1099@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
>
>
Go to my web site, http://www.pbc.ottawa.on.ca, and log in as guest. Select
any wizzard (dbwiz or scriptwiz), and go to the bottom of the page and
select view in browser.
Look on the restultant page for a routine called 'adnew'. There is the code
that you will need.
