Re: Access97 problems with Informix Online 7.12 and I-CLI 2.5
On Mon, 9 Jun 1997, User Name wrote (and was heavily snipped): Nice name :=) > I am not sure if you have received an answer to your questions yet. Part > of our application uses Access. I have run into some of the same things. Whereas my following comments are purely speculation and guesses, due to the fact that I've been "enduring" Access today, trying to automate a nightly data load (ie: "load from file insert into accesstable"). Geez. What a pain. > > 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 > This is correct. Access does not have a "serial" type. They do, however, have a "counter" type. Don't know how easy it is to insert arbitrary values, though. > > - DECIMAL becomes a Text string > This is not correct. It should become Number(Double) I am not sure of > your problem here. I may -- you're from .de and Microsoft is generally bad about internationali[zs]ation -- are your decimals (not familiar with .de format) in the "1.233.455,32" format? This may be confusing Access. We all know it doesn't take much. > You cannot order by any column other than the one that has the index on > it. > Why? Because Access uses something called the Jet engine. There is one > way > around it and that is to make your access to the table read only. Ick. > > Why can't I change the sort order of an unindexed field? > > Well, its a long story. But to make a long story short its because > Microsoft > Databases can order by columns not in the Select and an Informix > Database > can't. Although that column has to be read anyway -- its more a case of MS hiding things that Informix makes explicit and required. Does one or the other of these behaviors break SQL specs? I don't remember what was said about that, if anything. -Richard