Re: newbe insert question

In article <whtCdL_00iV8440vpL@andrew.cmu.edu>, Matthew Mashyna <mm5l+@andrew.cmu.edu> writes: |> I want to insert a row in a table with a serial field. I also want to |> insert rows in other tables using that new serial number to relate them. |> How can I find out what the new number is ? |> |> |> Matt Matt, Insert your record into the table with the serial column as "0". This action will set the SQLCA record that you can check against to get the serial #. (ie. let the_new_serial_num = SQLCA.SQLERRD[2]) Hope this helps! -- Ron Rupert | I've read dozens of books about heroes rlr@alert.com/(303)488-7674 | and crooks, and I've learned much from Programmer Analyst | both of their styles. - Jimmy Buffet Alert Centre, Inc. |