#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    1
    Rep Power
    0

    Exclamation Problems with SQL Commands


    I have with problem with a querry.

    Someting like this

    select * from (
    select * from tipuridate
    )t

    gives me an error when i try to execute.
    The Error is:
    Invalid token.
    Dynamic SQL Error.
    SQL error code = -104.
    Token unknown - line 2, char 5.
    select.


    Can anybody to help me. What is wrong in my querry.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    Paris Uppland
    Posts
    2,385
    Rep Power
    391
    Seems like Firebird does not support derived tables.

    What are you trying to do?
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12

    Re: Problems with SQL Commands


    use a stored procedure or wait for firebird2 release

IMN logo majestic logo threadwatch logo seochat tools logo