Re: XDP 4.0 and Informix 5.03

In article <3th45k$h7v@eunet.login.eunet.no>, aamodt@login.eunet.no says... > >I have been scanning this conference for a while now, >and I haven't seen anyone mentioning the combination of >XDP and Informix yet. > >Is it because XDP is seldom used or what? > Hi Geir, we also use XDP from Plexus. For the last 7 month we have been waiting for it to support ONLINE V7.1. When AD V4.1 is released - now delayed until september - it should be able to run with a 7.1 backend. I think AD (XDP) is an excellent product for handling images, scanning, compression, scaling and so on. Performance is very good, even with 386 PC's with 4 Mb >Anyway, I hope someone can help me with a little problem I have. > >I am trying to use the TIME statement directly in a SQL INSERT sentence, >but I get the 4GL error -4373 (grammatical error) when I am doing it. > >The sentence is: >INSERT INTO ImageData (x,timechanged,y) VALUES (szX, TIME, szY)> > >The timechanged variable is a "datetime Hour to Second" > >To try I workaround I then assigns the TIME variable to a CHAR var. >But then I get an C-ISAM error 1262. > > >My second workaround was to define the timechanged variable as an >"interval hour to second" and this works when the TIME variable is >passed on as a CHAR variable. > > >I hope that someone can help me with this, and I also hope that >some nice people can provide me with information, bugs/fixes, workarounds, >and (if it exists) ftpsites concerning XDP (and Informix 5.03). > >Yours sincerely > > >Geir R. Aamodt > In our application, we have defined the "time"-variable as CHAR(8), and then you can make your INSERT. Med venlig hilsen, og ha det godt Tom -- +-------------------------------------------------------+ | Tom Jakobsen Email: tja@pfa.dk | | PFA Pension Phone: +45 31207711 | | Sundkrogsgade 4 Fax : +45 31207875 | | DK-2100 Copenhagen, Denmark | +-------------------------------------------------------+