>>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
>
>You're wrong in the last sample, it doesn't create memo field.
It does (if there is no ALLTRIM() in it :o))
SQL Server has no ALLTRIM() function. AND ALLTRIM(SPACE(256)) == [] :-). I think Kjell has typo (or over typing) here ;o)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.