none
Query builder query syntax for MS Access Data base RRS feed

  • Question

  • Dear All ,

    If you are using query builder(through dataset) for oracle database your were condition will be like
    select id, name from company where id  = :m_id

    this syntax for SQL Server database will be
    select id, name from company where id  = @m_id

    what will  be the syntax for MS Access data files?

    Thanks in advance.



    Robi
    Sunday, November 29, 2009 1:20 PM

Answers

  • The answer is
    select id, name from company where id  = ?

    This syntax is for MS Access data files.

    Robi
    • Marked as answer by zakir.hossain Sunday, November 29, 2009 5:03 PM
    Sunday, November 29, 2009 5:03 PM