ADO Functions and Integers

[John Messingham]

Hi,

Is there any known reason why I would not be able to read an integer field from Firebird/MySQL via the ADO wrapper in FF 2.8?

I do not seem to be getting the values when I use FF_AdoRecordset_GetCollect.

I have no problem with text/char fields.

Edited to say I am connecting to the database via odbc.

[John Messingham]

Quick update.

By using the 'GetString' command (http://planetsquires.com/support/index.php?topic=1268.0) I can see the values are being returned. I just cannot seem to access them.

[Jose Roca]

Which kind of integer? Use VARIANTVT in the returned variant and tell us which type is.

[John Messingham]

Hi Jose,

Thanks for the reply.

Type 3, Long-integer.

[Jose Roca]

Then use VARIANT# to retrieve the value. Maybe are you using VARIANT$, that is for strings only?

[John Messingham]

Jose strikes again.

Replaced Variant$ with Variant# and all is ok now.

Thank you for your time.

[John Messingham]

Can I ask the same question about currency fields (type 6) please.

[Jose Roca]

Same reply: VARIANT#

[John Messingham]

Cheers, I should have looked closer at what I was doing.