Ok I've been looking and I can't figure out how to get the field type from a sql database... I want to be able to open a database with the information in the database the way it was inserted. Here's what I mean:
I set up a database mapping each variable TEXT, INT, DOUBLE, LONG
I save the data to the database
When I open the database after putting the data into it, I'd like to be able to pull the info from the database in the format it was put in... if I put a DOUBLE or a LONG into the database right now, when I read from it, it comes out as a string and I lose any info from beyond the decimal point but it's rounded up (eg: 10.668 comes out as 11) which doesn't work for the info I'm trying to use. If I could determine the field type in the database to begin with then I could test the type before setting the variable Dim to get the info properly. Anyone have any ideas on how to acheive this? :sign0085:
I set up a database mapping each variable TEXT, INT, DOUBLE, LONG
I save the data to the database
When I open the database after putting the data into it, I'd like to be able to pull the info from the database in the format it was put in... if I put a DOUBLE or a LONG into the database right now, when I read from it, it comes out as a string and I lose any info from beyond the decimal point but it's rounded up (eg: 10.668 comes out as 11) which doesn't work for the info I'm trying to use. If I could determine the field type in the database to begin with then I could test the type before setting the variable Dim to get the info properly. Anyone have any ideas on how to acheive this? :sign0085:
