Results 1 to 4 of 4

Thread: My select statement did not work,,Pls help

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jul 1999
    Location
    Saudi Arabia, Gulf side, Qatif
    Posts
    141
    When I run this sql:

    mysql = "select * from cri where stock like '[89*]';"
    Data1.RecordSource = mysql
    Data1.Refresh

    I am getting this error:
    Too vew parameters, expected 1 (3061)

    What could be wrong in my select statement, and how to learn the equation of putting the correct position of commas, punctuation, semicolon etc so I will not face this kind of problem

    Please help
    Appreciated in advance

  2. #2
    Lively Member
    Join Date
    Aug 2000
    Posts
    125
    try

    mysql = "select * from cri where stock like '89*'"

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Jul 1999
    Location
    Saudi Arabia, Gulf side, Qatif
    Posts
    141
    Same error occurred !!!!

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Jul 1999
    Location
    Saudi Arabia, Gulf side, Qatif
    Posts
    141
    What a mestake I was doing, The feild name was not completed, it was stock number not only stock,,,,I reaply the sql with the correct name and it work correct

    Thanks for your particiption

Posting Permissions

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



Click Here to Expand Forum to Full Width