Carlos my friend. Thank you very much for all your help. I got wanted I needed done though!!!
I was still having issues with returning the value. I had setup my stored procedure which does the insert and returns the unique id. But...I could not get things set up on the .NET side. Perhaps I was not structuring my SQL correctly or mapping my output correctly. In any case... The approach I took was the following: 1. I created a scalar query which does a select on my db generator. 2. I setup a method which calls that query and cast the output as my unique id (Int32) into a private variable. 3. Then I call a normal Insert function passing everything in. Works wonderfully. It took me forever, but hey, at least I learned a lot about Data Connections, and DataAdapters, and DataSets. Tony ---------------------------- Tony Kylitis ReactorNet Technologies P: 210-477-0200 Ext. 202 F: 210-223-2110 E: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carlos Guzmán Álvarez Sent: Wednesday, March 08, 2006 12:29 PM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Return Key (autonumber) to DataSet using Hello: > That first single quote before C: is badddd. I have not tried taking > the single quotes out of the string and just leaving the directory > name alone. I removed the quotes and made my directory a name with no > spaces. Nice. > Now I can get back to my original problem -- returning a uniqueID > value back to my business object. Using output parameters should work. -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
