Home > Archive > Clarion > October 2006 > Triggers in Firebird and C63EE
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Triggers in Firebird and C63EE
|
|
|
| Hi,
I have in mind to convert some apps to use firebird sql and
i made an example app that use some firebird tables, problem is how to
handle autoinc sql triggers.
I cant add any data to firebird table from clarion form if sql table
includes before insert trigger.
How to handle these triggers ?
Regards KLo
| |
| softsistem@gmail.com 2006-10-22, 6:55 pm |
|
B.U.T wrote:
> Hi,
>
> I have in mind to convert some apps to use firebird sql and
> i made an example app that use some firebird tables, problem is how to
> handle autoinc sql triggers.
> I cant add any data to firebird table from clarion form if sql table
> includes before insert trigger.
> How to handle these triggers ?
>
> Regards KLo
Do not use database triggers for autoinc.
Ask database for next generated ID before insert record.
Use combination of App triggers and procedures which return ID.
Regards Djole
|
|
|
|
|