RE: syntax for column names

2007-06-06 Thread Fantry, John
Sounds like you are using an ordinary SQL92 identifier. Convert it to a delimited identifier by placing quotes around it and I think you'll be ok. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 10:05 AM To:

RE: Results portion

2006-08-09 Thread Fantry, John
This question has bean asked several times already . . . Once by me ;-) The answer is NO. There is no way to retrieve rows in this fashion. I had to create an extra index column in my table in order to simulate this kind of behavior. Big pain in the . . . -Original Message- From:

RE: Results portion

2006-08-09 Thread Fantry, John
asking and which is supported by multiple RDBMSs. -Original Message- From: Fantry, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 10:00 AM To: Derby Discussion Subject: RE: Results portion This question has bean asked several times already . . . Once by me

How to monitor progress during data import

2006-07-26 Thread Fantry, John
I am using Derby to import a large text file into a table. I would like to be able to display a progress dialog to the user while the import is processing. In order to provide a useful progress bar I need to be able to calculate the % complete of the import procedure. Does anyone know if

RE: How to monitor progress during data import

2006-07-26 Thread Fantry, John
- From: Mike Matrigali [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 11:27 AM To: Derby Discussion Subject: Re: How to monitor progress during data import Andreas Korneliussen wrote: Fantry, John wrote: I am using Derby to import a large text file into a table. I would like

Paginating result sets

2006-07-19 Thread Fantry, John
I need some help figuring how to paginate result sets with Derby. Ihave scanned the list archives and have found one similar thread that never received a complete answer from May 2005. From what I understand this pagination behavior is possible in MySQL by using the 'LIMIT' query. This