>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
Kjell,
I saw your backend is SQL Server, BUT in SQL Server there is NO ALLTRIM() function, If you use SQL Server you could use this to get an logical field:
sqlexec(nHandle,"select Table1.*, CAST(0 AS Bit) as extrafield from Table1","Mytable")
If you use VFP:
sqlexec(nHandle,"select Table1.*, .f. as extrafield from Table1","Mytable")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.