On Thu, 2010-02-25 at 20:10 -0500, Keith Clark wrote: > 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 > >
Ok, I see what I did wrong! I forgot the Update. Sorry about that, I'm still learning. Keith ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user