>>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.
Yes I saw the error when the message was saved. It should be Ltrim or Rtrim instead of Alltrim.
Yes, CAST works on local tables, but not with SQLselect to SQLserver 2005.
So my exampe is the only way I know, to make an empty memofield.
Thakyou for your answer
/Kjell