Re: [Firebird-net-provider] Using FbConnection for multiple FbCommands

2006-04-12 Thread Jiri Cincura
On 12.4.2006 14:15 Carlos Guzmán Álvarez wrote: Yes it should be possible, if not it's a bug ;) Yesterday it was not working for me. :( Today it's working! :) Maybe some woodoo. ;) -- Jiri Cincura http://www.cincura.net/ --- This SF.Net em

Re: [Firebird-net-provider] Using FbConnection for multiple FbCommands

2006-04-12 Thread Carlos Guzmán Álvarez
Hello: open conn. select data while read read one row use some columns from select and insert new to another table (insert is using the same conn) commit; conn. close Yes it should be possible, if not it's a bug ;) -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.blogspot.com/ "Wh

Re: [Firebird-net-provider] Using FbConnection for multiple FbCommands

2006-04-12 Thread Jiri Cincura
Something like this: open conn. select data while read read one row use some columns from select and insert new to another table (insert is using the same conn) commit; conn. close -- Jiri Cincura http://www.cincura.net/ --- This SF.Ne

[Firebird-net-provider] Using FbConnection for multiple FbCommands

2006-04-12 Thread Jiri Cincura
Hi, can I use one FbConnection for multiple FbCommands. I'm using one command for selecting data from table and while reading it, I'm inserting this and new data into another table. Can I do this? Or need I 2 conections (one for reading data during inserting (the second conn.))? -- Jiri Ci