Create a powerbuilder Connection Object

[bigpapi]

Hey Guys;

I am getting an integrity constraint error in my powerbuilder Insert Into statement.

I have two inserts and the second insert has a foreign key dependant on the first insert. It seems like my second insert can't find the associative value that it should, because it seems like it is treating it like two separate transactions as opposed to one.

I need a way to create my own connection so that i can run both inserts using my new connection.
Using SQLCA doesn't work either.

Hopefully someone can help
thanks in advance