Subject | Generate For Table (update sql in TIB_Query) |
---|---|
Author | radevojvodic |
Post date | 2007-06-26T06:45:33Z |
I have a simple query
SELECT B.BANKA_ID
FROM BANKA B
KeyRelation = B
KeyLinks = BANKA_ID
Button Generate forTable in UpdateSQL tab in TIB_Query Editor
generates following SQL.
EDIT:
UPD TE SET
WHERE
RDB$DB_KEY = :DB_KEY
INSERT:
INSER) INTO (
VALUES )
DELETE:
DELETE FROM
WHERE
RDB$DB_KEY = :DB_KEY
What am i doing wrong (it is the same for interbase7.0 or firebird2.0)
Rade
SELECT B.BANKA_ID
FROM BANKA B
KeyRelation = B
KeyLinks = BANKA_ID
Button Generate forTable in UpdateSQL tab in TIB_Query Editor
generates following SQL.
EDIT:
UPD TE SET
WHERE
RDB$DB_KEY = :DB_KEY
INSERT:
INSER) INTO (
VALUES )
DELETE:
DELETE FROM
WHERE
RDB$DB_KEY = :DB_KEY
What am i doing wrong (it is the same for interbase7.0 or firebird2.0)
Rade