V4MD SQL statement trouble

Doug Brown dougb at finitemonkey.com
Fri Sep 24 15:26:38 CDT 2004


Can anyone spot what is wrong with this SQL statement? I keed getting a
VCursor object with a VOID record count, although this same SQL
statement works fine in Access.

-----------------------
SELECT Users.User_ID, Questions.Question_Track, Questions.Question_Type,
Responses.Question_ID, Responses.Response
FROM Questions INNER JOIN (Users INNER JOIN Responses ON
Users.User_ID=Responses.User_ID) ON
Questions.Question_ID=Responses.Question_ID
WHERE Users.User_ID=1
ORDER BY Questions.Question_Track, Responses.Question_ID
-----------------------

Thanks,
Doug Brown
dougb at finitemonkey.com


More information about the Valentina mailing list