Last calls for............
Robert Taylor described a problem, mostly lost in the quoted text, with an INTERVAL value used from Visual Basic. One poster suggested the VB6 str() function. Robert replied his workaround was a stored procedure that selects the INTERVAL and returns it as a CHAR field, and asked for any better way. No better solution was given.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Does anyone know what I'm on about ? Has anyone else hit this wall ? Be like Jerry Springer and give me your final thought. Thats not an invitation for cheek and abuse though !!:-) >C'mon , one of you cats must know. >Whose the wise owl ? >Hi can anyone shed any light on how to deal with a returned interval ( YEAR >TO MONTH ) from Informix via an ADO connection. What should the selected >value be read into ( in VB6 ) ? >Transferring the returned value into a textbox causes an error ? >VB6 , IDS 7.3, ADO 2.0 >So who's going to be quickest on the draw pardners ?
Robert Taylor wrote: > Does anyone know what I'm on about ? > Has anyone else hit this wall ? > Be like Jerry Springer and give me your final thought. Thats not an > invitation for > cheek and abuse though !!:-) > > >C'mon , one of you cats must know. > >Whose the wise owl ? > > >Hi can anyone shed any light on how to deal with a returned interval ( YEAR > >TO MONTH ) from Informix via an ADO connection. What should the selected > >value be read into ( in VB6 ) ? > > >Transferring the returned value into a textbox causes an error ? > > >VB6 , IDS 7.3, ADO 2.0 > > >So who's going to be quickest on the draw pardners ? When in doubt ask Obnoxio The Clown, he can come up with a good response, even if it is just four a lough. ;-) -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web) For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------
Have you tried using the VB6 str(number) function, ie. txtbox.Text = str(interval) ? Robert Taylor <robertt@scotlegal.com> wrote in message news:876ton$7ss$1@plutonium.btinternet.com... > Does anyone know what I'm on about ? > Has anyone else hit this wall ? > Be like Jerry Springer and give me your final thought. Thats not an > invitation for > cheek and abuse though !!:-) > > >C'mon , one of you cats must know. > >Whose the wise owl ? > > >Hi can anyone shed any light on how to deal with a returned interval YEAR > >TO MONTH ) from Informix via an ADO connection. What should the selected > >value be read into ( in VB6 ) ? > > >Transferring the returned value into a textbox causes an error ? > > >VB6 , IDS 7.3, ADO 2.0 > > >So who's going to be quickest on the draw pardners ? > > > > > > > > >
Stop falling asleep !! The way around this is to execute a stored procedure , it selects the INTERVAL and returns it as a CHAR field. If anyone finds a better way let me know. > >Hi can anyone shed any light on how to deal with a returned interval YEAR > >TO MONTH ) from Informix via an ADO connection. What should the selected > >value be read into ( in VB6 ) ? > > >Transferring the returned value into a textbox causes an error ? > > >VB6 , IDS 7.3, ADO 2.0 > > >So who's going to be quickest on the draw pardners ?