List:GUI Tools« Previous MessageNext Message »
From:Dean MacIsaac Jr. Date:March 19 2002 9:45pm
Subject:Re: mysql and VB issues
View as plain text  
oops...my fault...  I was reading the wrong list when I posted that thanks
and sorry

Dean
----- Original Message -----
From: "Adam Hooper" <adamh@stripped>
To: "'Dean MacIsaac Jr.'" <dmacisaacj@stripped>;
<mycc@stripped>
Sent: Tuesday, March 19, 2002 4:28 PM
Subject: RE: mysql and VB issues


> We use a VB app that communicates with MySQL using adodc and it works
> fine -- it has more problems with MSSQL than with MySQL.
>
> That said, this is the wrong place to ask ;). MyCC is a little app for
> MySQL, not MySQL itself. Perhaps you should send to
> mysql@stripped instead? :)
>
> Keep working on it, you can do it.
>
> ---------------
> Adam Hooper
> adamh@stripped
>
> -----Original Message-----
> From: Dean MacIsaac Jr. [mailto:dmacisaacj@stripped]
> Sent: Tuesday, March 19, 2002 3:52 PM
> To: mycc@stripped
> Subject: mysql and VB issues
>
>
> Hi everyone,
>
> Been a long time since I touched VB, and I'm still learning, so my code
> below may be scary, but I am writing what could turn into a huge project
> using VB and MYSQL DB.  I've got them talking to each other, and
> actually
> used my program to populate some test fields yesterday.  I did get an
> error
> a few times, but now I seem to get one all the time.
>
> Run-time error '-2147217887 (80040e21)':
>
> Multiple-step operation generated errors. Check each status value.
>
> I click debug, it happens on a diff. line occasionally but in each of
> the
> lines above the offending line, the recordset side and the value side
> have
> the same value.  On the offending line, the recordset side has a null
> value,
> but the variable 'fileloc' has a value of whatever was assigned to it.
>
> Private Sub cmdSavefile_Click()
>     Adodc1.Recordset.AddNew
>     Adodc1.Recordset.Fields("fname") = txtFname.Text
>     Adodc1.Recordset.Fields("lname") = txtLname.Text
>     Adodc1.Recordset.Fields("email") = txtEmailaddy.Text
>     Adodc1.Recordset.Fields("phone") = txtPhonenumber.Text
>     Adodc1.Recordset.Fields("imagelocation") = fileloc
>     Adodc1.Recordset.Fields("customerid") = txtBarcode.Text
>     Adodc1.Recordset.Update
>     txtFname.Text = ""
>     txtLname.Text = ""
>     txtEmailaddy.Text = ""
>     txtPhonenumber.Text = ""
>     txtBarcode.Text = ""
>     imageCheck.Picture = LoadPicture
>
> I started this email a while ago...  I've done some research.  My MySQL
> DB
> fname field is set to a lenght of 20 if I put in my name, Dean, it works
> fine.  If I put in Marge with 5 letters, it errors.  I figured maybe it
> was
> putting all the white space in as well and it was totalling over 20
> characters...  I bumped fname up to 40, and a 5 character name on up
> brings
> on the error.  Any help would be greatly appreciated.
>
> Thanks,
>
> Dean
> PS I'm posting this same Q. to the VB newsserver.

Thread
mysql and VB issuesDean MacIsaac Jr.19 Mar
  • RE: mysql and VB issuesAdam Hooper19 Mar
    • Re: mysql and VB issuesDean MacIsaac Jr.19 Mar