Thread: ODBC / SQL question

  1. #1
    Seeking motivation... endo's Avatar
    Join Date
    May 2002

    ODBC / SQL question

    I have just got my application up and running and connected to an access database and now I've started playing with the SQL a bit. Using a class derived from CRecordset in the MFC I have overridden getDefaultSQL to return the string "select * from competitors". This works fine, although when I try to add a where clause in the SQL it crashes at runtime and I dont know why. I have been trying SQL strings such as "select * from competitors where age < 18" but this doesn't seem to be working.

    Any advice is welcome, or if not it'd be great if someone could direct me to a helpful website

  2. #2
    Registered User
    Join Date
    Jul 2002
    That SQL string is about as basic as it gets and appears correct to me. I don't know anything about the CRecordset object though. Sorry.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Speed/size advantage to SQL?
    By MK27 in forum Tech Board
    Replies: 15
    Last Post: 06-26-2009, 11:28 AM
  2. another do while question
    By kbpsu in forum C++ Programming
    Replies: 3
    Last Post: 03-23-2009, 12:14 PM
  3. Question...
    By TechWins in forum A Brief History of
    Replies: 16
    Last Post: 07-28-2003, 09:47 PM
  4. .NET Question
    By gvector1 in forum C# Programming
    Replies: 1
    Last Post: 05-20-2003, 11:41 PM
  5. opengl DC question
    By SAMSAM in forum Game Programming
    Replies: 6
    Last Post: 02-26-2003, 09:22 PM