+ Reply to Thread
Results 1 to 4 of 4

ADO SQL: Im getting CRAZY

  1. #1
    Registered User
    Join Date
    07-07-2005
    Posts
    2

    ADO SQL: Im getting CRAZY

    Hi all!

    I cant solve very simple task.
    All I need is a query "SELECT * FROM Table WHERE Field LIKE '*value*'"

    But it seems Microsoft is too huge company to let me just do that like in PHP.

    Im using DAO because hope it will work more often then ADO now do :)

    1) DAO worked ONLY whith syntax [TableName$] but most of examples not using it.
    2) I have working query

    Sql = "SELECT * FROM [TestList$]"
    Set rs = db.OpenRecordset(Sql)

    3) But cant make work WHERE clause like this:

    "SELECT * FROM [TestList$] WHERE A LIKE 'asdas'"

    It gives me Run-Time 3061. In the internet I read about some _parameters_ in query.
    Anybody can tell me which more PARAMETERS wants from me crazy excel programmres?

    Or just wrong syntax?
    Please help.

  2. #2
    K Dales
    Guest

    RE: ADO SQL: Im getting CRAZY

    The syntax is OK but I think probably the interpreter is having some trouble
    due to ambiguity in the names (it is interpreting the [TestList$] as a
    parameter, apparently - but only when you have the WHERE clause). The first
    thing I would try is to give a complete reference to your WHERE clause like
    this:
    "SELECT * FROM [TestList$] WHERE [TestList$].[A] LIKE 'asdas'"
    This might help MS Jet (assuming you are using Access) interpret the table
    name and column correctly.

    If that does not work, try building the query - at least this simple one -
    using MSQuery instead of directly through ADO, and then view the SQL code
    within MSQuery to see how it is written there. If you can get the query to
    run in MSQuery, you can see what the proper syntax looks like and modify it
    however you need to.

    "VladimirM" wrote:

    >
    > Hi all!
    >
    > I cant solve very simple task.
    > All I need is a query "SELECT * FROM Table WHERE Field LIKE '*value*'"
    >
    > But it seems Microsoft is too huge company to let me just do that like
    > in PHP.
    >
    > Im using DAO because hope it will work more often then ADO now do
    >
    > 1) DAO worked ONLY whith syntax [TableName$] but most of examples not
    > using it.
    > 2) I have working query
    >
    > Sql = "SELECT * FROM [TestList$]"
    > Set rs = db.OpenRecordset(Sql)
    >
    > 3) But cant make work WHERE clause like this:
    >
    > "SELECT * FROM [TestList$] WHERE A LIKE 'asdas'"
    >
    > It gives me Run-Time 3061. In the internet I read about some
    > _parameters_ in query.
    > Anybody can tell me which more PARAMETERS wants from me crazy excel
    > programmres?
    >
    > Or just wrong syntax?
    > Please help.
    >
    >
    > --
    > VladimirM
    > ------------------------------------------------------------------------
    > VladimirM's Profile: http://www.excelforum.com/member.php...o&userid=24993
    > View this thread: http://www.excelforum.com/showthread...hreadid=385216
    >
    >


  3. #3
    Sean Connolly
    Guest

    RE: ADO SQL: Im getting CRAZY

    Hi Vladimir,

    Before I go off in the wrong direction and give you an answer to a question
    that you haven't asked, can you confirm a couple of things for me/us please?

    Do I understand correctly that you are trying to use VBA, ADO and/or DAO
    from one Excel workbook to fire off a query and return some records from a
    table (named range or worksheet) in some other Excel workbook?

    Or is it some VBScript that you're looking for us to help you with in order
    to return a recordset to a web page?

    Grateful if you can please confirm and provide a bit more information in
    regards to your purpose and that will give me/us the best chance to help you
    to help yourself. Any code snippets of how far you've already got would
    probably assist too.

    (As an aside, personally I normally prefer ADO over DAO and regardless, the
    LIKE operator is always a bit tricky because you have to use the SQL
    'flavour' and syntax that the host provider/database understands.)

    Cheers, Sean.

    "VladimirM" wrote:

    >
    > Hi all!
    >
    > I cant solve very simple task.
    > All I need is a query "SELECT * FROM Table WHERE Field LIKE '*value*'"
    >
    > But it seems Microsoft is too huge company to let me just do that like
    > in PHP.
    >
    > Im using DAO because hope it will work more often then ADO now do
    >
    > 1) DAO worked ONLY whith syntax [TableName$] but most of examples not
    > using it.
    > 2) I have working query
    >
    > Sql = "SELECT * FROM [TestList$]"
    > Set rs = db.OpenRecordset(Sql)
    >
    > 3) But cant make work WHERE clause like this:
    >
    > "SELECT * FROM [TestList$] WHERE A LIKE 'asdas'"
    >
    > It gives me Run-Time 3061. In the internet I read about some
    > _parameters_ in query.
    > Anybody can tell me which more PARAMETERS wants from me crazy excel
    > programmres?
    >
    > Or just wrong syntax?
    > Please help.
    >
    >
    > --
    > VladimirM
    > ------------------------------------------------------------------------
    > VladimirM's Profile: http://www.excelforum.com/member.php...o&userid=24993
    > View this thread: http://www.excelforum.com/showthread...hreadid=385216
    >
    >


  4. #4
    Registered User
    Join Date
    07-07-2005
    Posts
    2
    Hi, Sean!

    thank you for yuor answer.
    That was Excel book, but I already solved my problem.

    This error appears when wrong fields name in a query.

    I must name it F1, F2 ... But this information I could get from one of the phorums only.

    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1