Member Avatar for Singlem

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
  • 151 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Singlem
Member Avatar for Singlem

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.