>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
Maybe, you want NULL value; and anyway why do you need it at all?
Edward Pikman
Independent Consultant