#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0

    Unexpected end of command


    Good evening,

    I have problem executing query string into FOR EXECUTE STATEMENT command :
    Code:
    ' WHERE  e.employeur_id=' || :employeur_id || ' AND ' || ' e.employe_id<=' || :START_ROW || ' ORDER BY E.EMPLOYE_ID DESC';
    The select statement is so long with joinable tables, so I remove it .
    The problem is only the in sql string above can you help me please to correct the quoted string ?
    Thanks
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2017
    Posts
    4
    Rep Power
    0
    It 's solved it was a problem with null value in variable.
    Thanks anyway and sorry.

IMN logo majestic logo threadwatch logo seochat tools logo