Errors using Live Queries using DATETIME on Informix 7.3

Mark Stinson

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Errors using Live Queries using DATETIME on Informix 7.3

I'm trying to select a group of live records from Informix Dynamic Server
7.3 on an NT system. I'm trying to use a DATETIME in the selection. For
example:

select * from lane where start_when > DATETIME( 1990-01-01) TEAR to DAY

This works when it's not a live query, but if I try to make it live I get a
"Capability not supported" message. I tried this is the informix ISQL
program and didn't get any errors. I also tried to switch the DLLs and
chagned some of the database configuration parameters, but wasn't able to
get a working combination. Help!

Mark

Ramesh Theivendra

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Errors using Live Queries using DATETIME on Informix 7.3

This is a known restriction and the live query parser doesn't handle server
specific syntax and functions.

T.Ramesh.

Quote

Mark Stinson wrote:
> I'm trying to select a group of live records from Informix Dynamic Server
> 7.3 on an NT system. I'm trying to use a DATETIME in the selection. For
> example:

> select * from lane where start_when > DATETIME( 1990-01-01) TEAR to DAY

> This works when it's not a live query, but if I try to make it live I get a
> "Capability not supported" message. I tried this is the informix ISQL
> program and didn't get any errors. I also tried to switch the DLLs and
> chagned some of the database configuration parameters, but wasn't able to
> get a working combination. Help!

> Mark

Mark Stinso

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Errors using Live Queries using DATETIME on Informix 7.3

Thanks for the confirmation. I must say I'm surprised. Isn't that a fairly
significant restriction? I've always touted Delphi as the best product
around with the best features. Do other solutions have similar restrictions,
I wonder?

Quote

Ramesh Theivendran wrote in message <364B25DD.45125...@inprise.com>...
>This is a known restriction and the live query parser doesn't handle server
>specific syntax and functions.

>T.Ramesh.

>Mark Stinson wrote:

>> I'm trying to select a group of live records from Informix Dynamic Server
>> 7.3 on an NT system. I'm trying to use a DATETIME in the selection. For
>> example:

>> select * from lane where start_when > DATETIME( 1990-01-01) TEAR to DAY

>> This works when it's not a live query, but if I try to make it live I get
a
>> "Capability not supported" message. I tried this is the informix ISQL
>> program and didn't get any errors. I also tried to switch the DLLs and
>> chagned some of the database configuration parameters, but wasn't able to
>> get a working combination. Help!

>> Mark

Russell L. Smit

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Errors using Live Queries using DATETIME on Informix 7.3

If you think about what the live query parser does, it is already quite
complex (and flexible, for that matter). Supporting server-specific
functions would add an entire new layer that Inprise must write for each
server. At least developers can take control of updates through the
TUpdateSQL component.

As far as other "solutions" go, which ones even support live queries at all?

V/R
Russell L. Smith

Quote

Mark Stinson wrote in message <72j3il$h...@forums.borland.com>...
>Thanks for the confirmation. I must say I'm surprised. Isn't that a fairly
>significant restriction? I've always touted Delphi as the best product
>around with the best features. Do other solutions have similar
restrictions,
>I wonder?

Other Threads

1. Informix live query with selection on datetime field

2. Stored Procedure using Informix 7.3

3. Parameterized query with datasource using Delphi 4 C/S Oracle 7.3

4. Error add records en TQuery request live Oracle 7.3

5. Pros and Cons of using live queries

6. EDBE engine error (SQL run-time error using Informix database)

7. Very bad performance when using the cache (Delphi C/S 3.0 + Oracle 7.3)

8. Using/Creating Oracle 7.3 Stored Procedures

9. Oracle 7.3 Packages using TStoredProc

10. Problems using BDE 5.01 and Oracle 8 drivers reading Oracle 7.3 databases