Hallo.
If I want to add an extra empty field when I do a SQLselect i do like this:
sqlexec(nHandle,"select Table1.*, space(19) as extrafield from Table1","Mytable")
for an extra character field,
sqlexec(nHandle,"select Table1.*, 0 as extrafield from Table1","Mytable")
for an extra integer field,
sqlexec(nHandle,"select Table1.*, alltrim(space(256)) as extrafield from Table1","Mytable")
for an extra memo field... and so on.
BUT, how do I do if I want an extra logical field???
I cant use a zero because it will result in an integer field, and I have tried 'false', and even an 'L'. (The 'L' was a last desperate try, when nothing else worked :-) )
Nothing I do works, so I will ask if someone knows how to add an empty logic field to my SQLselect???
Thanks
/Kjell