V4MD SQL statement trouble

[Ruslan Zasukhin]

On 9/24/04 10:26 PM, "Doug Brown" <dougb at finitemonkey.com> wrote:

Hi Doug,

> 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
> -----------------------

You use SQL92 syantx todo joing.

Valentina 1.x expect to see MS SQL syntax


SELECT Users.User_ID, Questions.Question_Track, Questions.Question_Type,
Responses.Question_ID, Responses.Response

FROM Questions ,Users, Responses
HERE 
    (Users.User_ID=Responses.User_ID and
    Questions.Question_ID=Responses.Question_ID)
AND
    Users.User_ID=1






-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------