I need to return the name of my currently open database.
The DBC() function should be the solution for this.
However, when I use it in my code, I always get a data type mismatch error.

According to the help, it always returns an character.
Not true for me.
I have a database opened
If I issue:
? dbc()
it displays the path and .dbc file to the screen correctly.
If I issue:
? type(dbc())
it returns U for undefined. It should be returning a charcter shouldn't it?

I am using it in code like this
? DBGETPROP(DBC()+'.'+field(1,(thisform.zAlias)),"FIELD","CAPTION")
this is returning the data type mismatch error.

How can I return a character value of the current database name?