General information
Category:
Coding, syntax & commands
>>>>Is there some way to force the type of field in a table created by SQL? I know with currency, you can do $0.00 AS ... But what about the other types.
>>>>
>
>CREATE CURSOR IntegerCursor (Field1 I) && or any type you wish.
>APPEND BLANK
>
>SELECT SomeFieldNames, Field1 AS MyNewFieldOfAnyType ;
> FROM SomeTable, IntegerCursor ;
> INTO CURSOR Result
>
>No join condition required. Does that work for you?
Interesting, but I think it's simpler just to alter the table.
Thanks,
-Michelle
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only