Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
"Reiner Kunz" — — source: Informix-list mailing list archive (1991-1998)
Hi there,
I'm using Access as frontend for informix online.Now, I have some
questions: I have Access 97, Informix Online 7.12 and I-CLI 2.5. I can
connect to my informix tables but have some strange problems.
a.) The informix datatypes are different from the access ones:
- SERIAL becomes an Access NUMBER
- DECIMAL becomes a Text string
Is this correct? How do I get the same (or at least similar data types)
with access?
b.) When I try to change the sort order I get an error -309 from my odbc
driver (I-CLI, Intersolv). The Group By field should also be in the SELECT
statement. But changing the sort order of an indexed field works correct.
Why can't I change the sort order of an unindexed field?
Many thanks for your help!
cu Reiner (munich, germany)
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.