it gives the following error me when property KEYGENERATOR is used.
"ERROR en la actualización
Dynamic SQL Error
SQL error code = -502
Attempt to reopen an open cursor"
this error takes place with the 2.0.0.0Fe version and not in 2.0.0.0F.
error in KEYGENERATOR
We can't reproduce this problem. Please do the following to help us detect its reason:
1. Specify your Firebird client/server version and your IDE version.
2. Add IBDACVCL to your Uses clause.
3. Set the Debug property, of dataset witch uses generators, to True.
4. Run your program.
5. Check that the SQL executed at insertion time is correct.
Note: IBDAC automatic SQL generation behavior depends on the Firebird server version you are using. In case of Firebird 2 and DataSet's GeneratorMode property set to gmPost (default settings) generator call is included in the insert SQL statement. In other cases the generator value will be explicitly retrieved using a dedicated SQL query.
Also if it is possible, send us a complete small sample project with script to create server side objects.
Send your message to IBDAC support address(see Support.html in IBDAC installation folder)
1. Specify your Firebird client/server version and your IDE version.
2. Add IBDACVCL to your Uses clause.
3. Set the Debug property, of dataset witch uses generators, to True.
4. Run your program.
5. Check that the SQL executed at insertion time is correct.
Note: IBDAC automatic SQL generation behavior depends on the Firebird server version you are using. In case of Firebird 2 and DataSet's GeneratorMode property set to gmPost (default settings) generator call is included in the insert SQL statement. In other cases the generator value will be explicitly retrieved using a dedicated SQL query.
Also if it is possible, send us a complete small sample project with script to create server side objects.
Send your message to IBDAC support address(see Support.html in IBDAC installation folder)
Do you receive my mails?
The 23/02 I sent the message with an example to [email protected] but I did not receive answers.
We received 2 your mails (23-Feb-2007 and 27-Feb-2007) and answered both of them. Please check your spam filter settings or specify another e-mail address we should use to answer you.
We have checked your example, but we still can not reproduce this problem.
Please send us the executable file and specify version of the InterBase/Firebird client you are using. To determine the client version, please perform the following steps:
- open the IBDAC connection editor in design time by double click on a TIBCConnection object;
- assign connection parameters and perform connect;
- open the connection editor again and copy information on the "Info" tab.
This information should look like following:
Server Version: WI-V6.3.0.12745 Firebird 2.0 Release Candidate 5
Client Version: 2.0
ODS Version: 11.0
Client Library: gds32.dll
Database SQL Dialect: 3
We have checked your example, but we still can not reproduce this problem.
Please send us the executable file and specify version of the InterBase/Firebird client you are using. To determine the client version, please perform the following steps:
- open the IBDAC connection editor in design time by double click on a TIBCConnection object;
- assign connection parameters and perform connect;
- open the connection editor again and copy information on the "Info" tab.
This information should look like following:
Server Version: WI-V6.3.0.12745 Firebird 2.0 Release Candidate 5
Client Version: 2.0
ODS Version: 11.0
Client Library: gds32.dll
Database SQL Dialect: 3