dbmysql + bigint

BlitzMax Forums/Brucey's Modules/dbmysql + bigint

Retimer

(Posted 2009) [#1]

for some reason this line produces an error:

Conn.Character.XP = TDBInt(record.value(7)).value

the value it seeks is a BIGINT variable. When I change it to a basic INTEGER, the error doesn't surface.

Conn.Character.XP as both an int or a long has no effect on the error, and changing TDBInt to TDBLong has no effect as well, I think it's an issue with the module.

Brucey

(Posted 2009) [#2]

I suppose the error is that TDBInt(record.value(7)) returns Null, which you then cannot ".value".

You can't cast a TDBInt from a TDBLong.

If a BigInt field is detected, it will return a TDBLong object.

record.getLong(7) should also work, btw. (a shortcut).

Retimer

(Posted 2009) [#3]

Aha she works, thanks brucey.