>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.
If you use VFP9 you can use CAST function to create fields of the desired type.
However, if you want to run your statement against different back-end, you would not always be able to convert to desired field type if the backend doesn't support it. In this case you can have a cursor with needed structure and append from the resulting cursor.
If it's not broken, fix it until it is.
My Blog