[Gambas-user] MySQL data access

[Keith Clark]

I am having some trouble understanding MySQL access.  I am new to Gambas
so you may have to take it easy on me!

Ok, I followed the instructions as per:

http://gambasdoc.org/help/howto/database

And I'm now trying to insert my first record into a populated database.
Here is my code to do so:

PUBLIC SUB ISBN_Enter()

  DIM $Result AS Result
  
  ' DatabaseConnection.Connect()
  
  DatabaseConnection.$Con.Begin
    $Result = DatabaseConnection.$Con.Create("tblStoreSales")
    ' $Result!salesID = "NULL"
    ' $Result!Date = Now
    $Result!ISBN = ISBN.Text
    $Result!Quantity = 1
    $Result!customerID = 0
    $Result!merged = 0
    $Result!salespersonID = 0
  DatabaseConnection.$Con.Commit()
  
  ISBN.text = ""

END

No, when the form opens I call the Connect() instead of every time the
text box has changed.

Now, when I enter a value into the text box nothing seems to happen for
a few moments, then it clears as it is supposed to, but no data is in
the table in the database.

I'm pretty sure it is connected, as if I put a sting in for a number, it
gives me an error.

Not sure how to troubleshoot this or even where good documentation is
for this type of operation other that what I have shown above.

Keith