Type mistake. query should be "SELECT " + tableName + ".NEXTVAL FROM SYS.DUAL";
Lihui -----Original Message----- From: Pang, Lihui Sent: November 29, 2005 3:24 PM To: 'Henner Kollmann' Cc: jdbforms-interest@lists.sourceforge.net Subject: RE: [dbforms] It's possible to get key by generator? Henner, I think using generator in DBForm will be a nice feature and it's quite common in current database design. The query is quite simple: "SELECT " + tableName + "_SEQ.NEXTVAL FROM SYS.DUAL"; tableName is the sequence table name I suggest to pass in as Field attribute (optional). Lihui -----Original Message----- From: Henner Kollmann [mailto:[EMAIL PROTECTED] Sent: November 29, 2005 3:17 PM To: Pang, Lihui Cc: jdbforms-interest@lists.sourceforge.net Subject: RE: [dbforms] It's possible to get key by generator? That will only work for specific databases - not in general. Or do you now a method which will work with standard sql? Henner > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Pang, Lihui > Sent: Tuesday, November 29, 2005 8:41 PM > To: jdbforms-interest@lists.sourceforge.net > Subject: [dbforms] It's possible to get key by generator? > > Hi, > > I check the DBspec 2.5. It looks like there is no way to get > the key by the generator. I suggest to add one more attribute > in Field class called generatorName. The generatorName is the > sequence table name which is used to generate the key of a > certain table. > > > Lihui > > ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
