0

Hey

I'm using a dbexpress to connect to a mysql server, that works.
I then do a query and from that assign values to variables.

Now my issue it that I can't seem to find a way to read a 'NULL' value from the Database and assign it to a variable.

error: "Could not convert variant of type (NULL) into type (string)"

The Data in that field is not anyways a NULL value, so What can I do in order to read that Value and then work with if?

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by Singlem
0

Ok found if I modify my query, by doing: 'SELECT *,IFNULL(aCol,0) as aColName FROM aTable;' and reading aColName it works.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.