Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
MySQL + VB
Name: Biz Date: September 9, 2003 at 03:22:24 Pacific OS: W2k CPU/Ram: AMD 1700/256
Comment:
Up until recently I was using VB to as a front end to an Access database. I have since migrated the database to MySQL and thought all was fine. I can view the data and edit existing data no probs. My problem is that when I add to a recordset I get an error stating "Multiple steps generated errors. Check each status value" when I try to update the recordset. I have checked the field properties and all seems fine.
Name: Chi Happens Date: September 9, 2003 at 16:29:00 Pacific
Reply:
i've found that recordset updating is plagued with troubles, i use the execute method of the connection object instead.
For example: SQL = "UPDATE ThisTable SET Field1='Data', Field2=15 WHERE RecordID=" & RecordID If Not CN.Execute(SQL) Then MsgBox Err.Description, vbOkOnly, "Error Updateing Database" End If
Chi Happens
0
Response Number 2
Name: Biz Date: September 10, 2003 at 08:23:53 Pacific
Reply:
Thanks for the response Chi I will give this a bash.
Summary: ok here is my dillemma I run vb 6 I want to have a server software and client software I want the client to be able to connect many times to the server(DONE through winsock) I also want the user to be...
Summary: Hello all, Can an app written with VB6, access an online database (MySQL) AND do a select on it and return the results IN the VB app? Thanks in advance! gary ...
Summary: I havent used Access2k but I know I had a problem connecting to a mySql & Oracle in VB with just passing the value (this,mypassword,that) and not (x=this,password=mypassword,y=that) yet the first argu...
0 
Style Sheet Question
