Subject | Problems opening IBQuery |
---|---|
Author | Freddy Holst Christensen |
Post date | 2001-04-15T22:03:08Z |
Hey ALL
I'm in the process of creating my first program with Interbase and IB
Objects, and started with a simple table.
But when I try to open the query, for editing and insert into the table,
I'm having problems,
I get the following message
PROGRAM NAME raised an an Exception classEIB_ISCError with error
message: ISC Error code 335544569
ISC Error message
Dynamic SQL Error
SQL Error Code :-104
Unexpected end of command
Through the IB_Query's SQL Wizard, I have entered the following SQL
statements
On the SQL -tab
SELECT *
FROM AFDKMU
On the UpdateSQL-tab
editsql: UPDATE AFDKMU SET
CODE = :CODE,
AFDELINGKMU = :AFDELINGKMU
insertsql: INSERT INTO AFDKMU(CODE,
AFDELINGKMU)
deletesql: INSERT INTO AFDKMU(CODE,
AFDELINGKMU)
Where code is an meant to be an ID generated with a generator through
MasterLinks/GneratorLinks.
Any help will very much appreciated, as I have spend much of
today(Easter Sunday), searching for a Clue
Regards
Freddy
I'm in the process of creating my first program with Interbase and IB
Objects, and started with a simple table.
But when I try to open the query, for editing and insert into the table,
I'm having problems,
I get the following message
PROGRAM NAME raised an an Exception classEIB_ISCError with error
message: ISC Error code 335544569
ISC Error message
Dynamic SQL Error
SQL Error Code :-104
Unexpected end of command
Through the IB_Query's SQL Wizard, I have entered the following SQL
statements
On the SQL -tab
SELECT *
FROM AFDKMU
On the UpdateSQL-tab
editsql: UPDATE AFDKMU SET
CODE = :CODE,
AFDELINGKMU = :AFDELINGKMU
insertsql: INSERT INTO AFDKMU(CODE,
AFDELINGKMU)
deletesql: INSERT INTO AFDKMU(CODE,
AFDELINGKMU)
Where code is an meant to be an ID generated with a generator through
MasterLinks/GneratorLinks.
Any help will very much appreciated, as I have spend much of
today(Easter Sunday), searching for a Clue
Regards
Freddy