Results 1 to 3 of 3

Thread: Help Please Problem With SQL1

  1. Apr 18th, 2005, 03:28 PM #1
    Argh two glass eyes
    Argh two glass eyes is offline

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Location
    Glastonbruy
    Posts
    14

    Exclamation Help Please Problem With SQL1

    Can you please help. I am having a problem with some sql that i copied from access into a variable. Everytime i run the program and click the button which uses the sql it crashes. See Pics below





    Thank you in advance ATGE!
    Reply With Quote Reply With Quote
  2. Apr 18th, 2005, 03:39 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Help Please Problem With SQL1

    Just post code rather than screen shots.

    You are missing some spaces in your sql statement. Common mistake when concatenating lines together.

    VB Code:
    1. MySQLTxt = MySQLTxt & " From..."

    2. MySQLTxt = MySQLTxt & " Where..."

    3. 'instead of 

    4. MySQLTxt = MySQLTxt & "From..."

    5. MySQLTxt = MySQLTxt & "Where..."
    Reply With Quote Reply With Quote
  3. Apr 18th, 2005, 03:52 PM #3
    Argh two glass eyes
    Argh two glass eyes is offline

    Thread Starter
    New Member
    Join Date
    Jan 2005
    Location
    Glastonbruy
    Posts
    14

    Re: Help Please Problem With SQL1

    ok! Sorry about that. Cheers for the help
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width