Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    46

    Unanswered: ADODC - Syntax error in FROM clause.

    Hi,
    I'm using the following code and I get the above error:

    Csql = "SELECT ML1.Caption AS English, CAP.Description, ML2.Caption AS Spanish, ML1.LastUpdate FROM(CAPTION AS CAP inner join((SELECT * FROM MULTI_LANGUAGE_CAPTION WHERE LanguageID = 1)AS ML1 LEFT JOIN (SELECT * FROM MULTI_LANGUAGE_CAPTION WHERE LanguageID = 2) AS ML2 ON ML1.CaptionID=ML2.CaptionID) on ML1.CaptionID = CAP.ID) where CAP.ID=3"

    Adodc.RecordSource = Csql
    Adodc.Refresh

    Here I get "Syntax error in FROM clause".

    Using a simple query without "select *" works.
    I also check for the commandType of the control to be adCmdUnknown.

    How do I resolve this problem?
    Please advise
    Thanks

  2. #2
    Join Date
    Aug 2002
    Posts
    46

    Talking

    hI Guys,
    I managed without the 'select *' part in the syntax and it works fine.
    Thanks any way

Posting Permissions

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