|XP is just a number|
Inserting to a bigint data type in Sybase using prepare statementsby j_ochoa (Novice)
|on Jul 07, 2017 at 10:59 UTC||Need Help??|
j_ochoa has asked for the wisdom of the Perl Monks concerning the following question:
I have a problem trying to insert into a column with data type as bigint and any help is much appreciated.
The error I get from the database is this:
Couldn't prepare statement: Server message number=257 severity=16 state=1 line=0 server=DEVEL1 procedure=DBD3 text=Implicit conversion from datatype 'VARCHAR' to 'BIGINT' is not allowed. Use the CONVERT function to run this query.
token_id column is a bigint data type
The conflicting line is where binding parameter 7
The code looks like this: