Hi,
I found a great way to have an Oracle trigger populating a tables primary id, and get the id back to my vb code for child tables & display (see OBTAIN NEW ORACLE SEQUENCE NUMBER UPON INSERT - ASP.NET Forums).
> sql = String.Format("Insert Into TABLE(columns) VALUES ('{0}')returning id into :newid", value_variable)
which works fine where I create an sql command an execute as a non-query.
However, I'd like to add the 'return id into' statement into the INSERT command of a datasource datatable that I'm binding my edit controls to. I've tried adding the additional sql into the query and adding a parameter, however it never seems to get populated.
Does anyone have any suggestions?
Thanks in advance
I found a great way to have an Oracle trigger populating a tables primary id, and get the id back to my vb code for child tables & display (see OBTAIN NEW ORACLE SEQUENCE NUMBER UPON INSERT - ASP.NET Forums).
> sql = String.Format("Insert Into TABLE(columns) VALUES ('{0}')returning id into :newid", value_variable)
which works fine where I create an sql command an execute as a non-query.
However, I'd like to add the 'return id into' statement into the INSERT command of a datasource datatable that I'm binding my edit controls to. I've tried adding the additional sql into the query and adding a parameter, however it never seems to get populated.
Does anyone have any suggestions?
Thanks in advance