OpenEuphoria

Re: ODBC formatting

• Posted by Matt Lewis <matthewwalkerlewis at gmail.?o?> Dec 18, 2007
• 698 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