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