SQL Question

Results 1 to 4 of 4

Thread: SQL Question

  1. #1
    pnub Guest

    Default SQL Question

    I am trying to &#039sort&#039 an access database before outputting the contents. What is wrong with the following:<BR><BR>SQL = "SELECT * FROM strBook ORDER BY font_name"<BR>objRecordset.Execute(SQL)

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: SQL Question

    What error(s) are you getting specifically? I think you might mean to run the Execute method of a connection object?

  3. #3
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: SQL Question

    BTW, the SQL looks fine, assuming it is a valid table in your database and the column name you are sorting on is a column in the table that is not of type memo (or text)

  4. #4
    pnub Guest

    Default RE: SQL Question

    You can&#039t sort a column if that column is text?


Posting Permissions

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