>>>Hi everyone,
>>>
>>>I'd like to create an Integer field in a select statement. AFAIK, by default it creates Numeric field. How can I do this?
>>>E.g.
>>> Select space(1) as moditype, ctot('') as PostTime, ? as Error (should be Integer field), .f. as Posted, etc.
>>>
>>>Thanks in advance.
>>
>>sele 000 as intfield && creates three digit integer field
>
>It creates Numeric field, not Integer!!!!!!

Anyway, disregard my problem, because it turns to it doesn't matter for the goal, I tried to achieve...