Yes, Derby supports VALUES expression. ij> values 1; 1 ----------- 1
1 row selected Regards, Yip Ng --- Julian Hyde <[EMAIL PROTECTED]> wrote: > The ANSI-compliant syntax for evaluating a scalar > expression without > reference to a table is > > VALUES (1) > > I don't know whether Derby supports this. > > Julian > > > -----Original Message----- > > From: Ken Johanson [mailto:[EMAIL PROTECTED] > > Sent: Thursday, January 11, 2007 11:20 PM > > To: [email protected] > > Subject: Database ping? ('select 1'?) > > > > This syntax: > > > > select 1 > > > > Seems to always throw a: > > > > SQLException: Syntax error: Encountered "<EOF>" at > line 1, column 8. > > > > Is this table-less syntax going to be supported at > some > > point, and what > > would be the next best means to do table-less > select (such as for > > testing scalars, etc) > > > > Of course this exmaple is also common for database > connection > > pings, in > > systems where the connection may timeout or FIFO.. > but is > > there a better > > (and equally efficient) approach to pinging? > > > > I also tried `select values (1)`. > > > > Thank you, > > Ken > > > > ____________________________________________________________________________________ 8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news
