Your problem might be in the UpdateSQL.Statements. I think there is a bug in
creating the UpdateSQL- and the InsertSQL-Statement if there are two primary
keys in the related table. I get the same error with a table like this:
CREATE TABLE aTable ( FirstField INTEGER NOT NULL, SecondField INTEGER NOT
NULL);
ALTER TABLE aTable ADD PRIMARY KEY (FirstField, SecondField);
The result of generating the UpdateSQLs for this table is:
UPDATESQL:
UPDATE aTable SET
FirstField =:FirstField, /*PK*/
FirstField =:Secondfield, /*PK* <-- here are the faults with the comma
and the missing "/" after PK*
WHERE
FirstField = :OLD_ FirstField AND
SecondField = :OLD_ SecondField
INSERTSQL:
INSERT INTO aTable (
FirstField, /*PK*/
SecondField, /*PK*) <-- again: the comma is not allowed before ")" and
"/" is missing after PK*
VALUES (
: FirstField,
: SecondField)

Herbert

-----Ursprungliche Nachricht-----
Von: Tom Deprez [mailto:zifnabbe@...]
Gesendet: Freitag, 14. Dezember 2001 13:05
An: ibobjects@yahoogroups.com
Betreff: [IBO] Can somebody help me understand the following error message?
Where do I've to look?

ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command

STATEMENT:
TIB_STATEMENT:

"<TApplication>.RegionForm.qrRegionPostcodes.IBOqrqrRegionPostcodes.<TIB_Upd
ateSQL>.<TIB_Statement>."

ST'. Process stopped. Use Step or Run to continue.

It is a query which contains the following code:

SELECT *
FROM VIEW_REGIONPOSTCODES P
WHERE P.REGION_ID = :REGION_ID

And I've used the 'Generate for table' button to create the UpdateSQL
statements...

Thanks in advance,
Tom.


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/