> Greetings > I have a problem - I can query a sqlite database using > > SELECT ssym,sclose FROM shistory where (sdate='2009-05-06') and sclose<.75 > and sclose > .1 order by ssym,sdate; > > and receive the following output: > AAC|0.24 > AAME|0.64 > AAU|0.61 > ABMC|0.16 > ABTL|0.5 > ACLS|0.47 > > but when I do the same in gambas and write it out I receive > AAC -1076125292 > > sclose is defined as a integer in the sqlite database. Can anyone tell me > what function to use to convert this to a string so I can output it to a > report or grid? > > Thank You > > > Ivan > > I never saw a wild thing sorry for itself. > A small bird will drop frozen dead from a bough > Without ever having felt sorry for itself. > > -- D.H. Lawrence > > Linux - Live Free or Die. > >
Which version of Gambas do you use? Can you send me your sqlite database (or part of it), so that I can reproduce your request on my own computer? Thanks in advance. -- Benoît ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
