Re: ODBC formatting
- Posted by Matt Lewis <matthewwalkerlewis at gmail.?o?> Dec 18, 2007
- 599 views
Mike777 wrote: > > I apologize if this posts twice. > > I can read my ODBC databases, but I'm having a tough time figuring out how to > interpret somee of the data types. Anything coming through as an SQL_VARCHAR > can be echoed to the screen with: > }}} <eucode> > for i = 1 to length(myData) > VOID= message_box(sprintf("Here is the > data:[%s",mySequence[i][1])&"]","Test Data",0) > next i > </eucode> {{{ > > But I haven't figured out how to work with things that are numeric. Two > examples. > If I have an SQL_INTEGER (which is a 4) which has the value -693341829. And > an SQL_SMALLINT (which is a 5) which has the value 20. They are displaying as: > 3601625467 and 0. > > The display statement I'm using is (x is the field number being displayed): > > VOID= message_box(sprintf("Here is the data:[%d",mySequence[i][x])&"]","More > Test Data",0) > > Is this just a fault in the ODBC driver that I'm using and therefore there is > "no hope"? Or is there a format I can use to visually display these values > properly? I think this is the fault of the wrapper. Looking at the code, it appears to interpret a SQL_INTEGER as an unsigned int, which seems incorrect. And it doesn't understand SQL_SMALLINTs at all. Matt