OpenEuphoria

Eusql question

• Posted by sixs <sixs at ida.net> Apr 08, 2005
• 455 views

Hi,
I am  accessing the Eusql database in a wxEuphoria program and want to 
display the data that I am putting into a line of data into a listbox.  
I am reading several records so I am using the FOR loop to access the  
records and then another loop to access the fields. I can display the 
data if it is described as text, but I cannot display the data when it 
is a number.  I am trying to use the command
fn = (sql[1][x1][x2])
    ft= get_field_datatype ( thisdb, thistbl,fn)
If I get ft I would use this to
for x1 = 1 to listlen do
    for x2 = 1 to 13 do
        trace(1)
        fn = (sql[1][x1][x2])
        ft= get_field_datatype ( thisdb, thistbl,fn)
        if ft = "9" then
            line = line &        sprintf("%d",sql[2][x1][x2])&", "
        else
            line = line &(sql[2][x1][x2])&", "
        end if
    end for
    add_item(Combo8, line)
end for

Thanks for any help
Jim