954,529 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Delphi 7 with dbexpress

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?

Singlem
Light Poster
49 posts since Feb 2010
Reputation Points: 10
Solved Threads: 8
 

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

Singlem
Light Poster
49 posts since Feb 2010
Reputation Points: 10
Solved Threads: 8
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You