On 28.3.2006 16:50 [EMAIL PROTECTED] wrote:
1) I'm using Beta 4 version of Net Provider. Now, i'd like to
install RC version. What should I do ? Do i have to uninstall
previous version of NetPrivider? And is it necessery to change
anything in windows registry?
If you install was properly done, you can just install new version.
2) I'm using Embeded version of Firebird + NetProvider. How can I
connect to my database via Crystal Reports? I've been trying to do
so, but i cant :( In Report Wizard there is an option called
"Database Files". When I click on it and then choose my database
file i've got an error : "Failed to load database information" and
then "Unknown Query Engine error"...
Are you using DDEX?
3)Please look at this code:
Public Function con_str() As String
Return
"User=SYSDBA;Password=masterkey;Database=C:\MYF.FDB;DataSource=localhost;Port=3050"
& _
";Dialect=3;Charset=NONE;Role=;Connection lifetime=0;Connection
timeout=15;Poolin" & _
"g=True;Packet Size=8192;Server Type=1"
End Function
Dim number As Integer
Dim worek_id As Integer
Dim connection As New FbConnection(con_str())
Dim query As String
Dim transaction As FbTransaction
Try
connection.Open()
transaction = connection.BeginTransaction()
query = "INSERT INTO TABLE(NR, GENDER) VALUES(" & number &
", 'M')"
Dim command_table As New FbCommand(query, connection,
transaction)
command_table.Prepare()
command_table.ExecuteNonQuery()
MessageBox.Show("Please press OK to continue")
query = "UPDATE WOREK SET ZAJETY='T' WHERE ID = " & worek_id
Dim command_worek As New FbCommand(query, connection,
transaction)
command_worek.Prepare()
command_worek.ExecuteNonQuery()
transaction.Commit()
Catch ex As Exception
MessageBox.Show("There was an error: " & ex.Message.ToString)
transaction.Rollback()
End Try
connection.Close()
The question is - what will happen if I close my program by pressing
Alt+F4 when the MessageBox will be displayed ( between "INSERT..."
and "UPDATE...") ? Will any data be added to my tables? Will
transaction.Rollback() be working?
If you will press Alt-F4 you will just close the dialog box, so the code
will flow with the next command.
--
Jiri Cincura
http://www.cincura.net/
-------------------------------------------------------
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&kid=110944&bid=241720&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
