Hi,

Could you try with " mark? I had similar problem and it helped.


e.g.:
SELECT GEN_ID("SEQUENCE_NAME", 1) AS NEWKEY FROM RDB$DATABASE

daniel

STbc> Hello Roman,

STbc> I have tried this under beta one and I get the following:

STbc> java.sql.SQLException: GDSException: org.firebirdsql.gds.GDSException:
STbc> Dynamic SQL Error
STbc> SQL error code = -901
STbc> feature is not supported
STbc>       at
STbc> org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:89)
STbc>       at
STbc> org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:178)
STbc>       at QASRipper.GuidGenerator$Key.loadKey(GuidGenerator.java:49)
STbc>       at QASRipper.GuidGenerator$Key.<init>(GuidGenerator.java:28)
STbc>       at QASRipper.GuidGenerator.getNextValue(GuidGenerator.java:76)
STbc>       at QASRipper.Test.main(Test.java:24)

STbc> This is using a PreparedStatement, not just a normal statement.

STbc> Regards,

STbc> Stephen.

STbc> -----Original Message-----
STbc> From: rrokytskyy [mailto:rrokytskyy@...]
STbc> Sent: 31 May 2002 14:36
STbc> To: Firebird-Java@yahoogroups.com
STbc> Subject: [Firebird-Java] Re: Selecting generators.


STbc> Hi,

>> Am I correct in thinking that the following can not be performed in
>> a prepared statement in the beta one release?
>>
>> SELECT GEN_ID(SEQUENCE_NAME, 1) AS NEWKEY FROM RDB$DATABASE