May 25, 2022, 03:42:48 PM

News:

IonicWind Snippit Manager 2.xx Released!  Install it on a memory stick and take it with you!  With or without IWBasic!


CDatabase Bindvariable question

Started by Haim, November 19, 2007, 10:37:40 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Haim

Hello,
I am trying to read an excel file.
In some of the columns, the variable type cannot be predicted. It is sometimes text and sometimes a number.
Since I have to define the type in BindVariable(), I sometimes get garbage in the bound variable.
Does anyone know how to solve this?
Is there in Aurora a "TYPE" like EBASIC's ANYTYPE, that might perhaps be usefull for this situation?

Any suggestions would be appreciated.

Haim

Ionic Wind Support Team

Use a string variable.  The ODBC driver should convert any numerics to a string automatically.  If not then the driver is non-conforming.

Ionic Wind Support Team

Haim

Thanks,
I tried it as a string and things did not change.
Where can i get an up to date driver?

Haim