General information
Category:
Coding, syntax & commands
I agree, Nancy.
The original question, as I understood it, was given a particular table that was the result of a SQL SELECT, how can you know if this table is a cursor or a DBF. I don't believe you can choose to assign an alias other than the table name in a SELECT .... INTO TABLE.tablname. Unless, of course, you USE that table AGAIN giving it an alternative alias.
>Dore, Alan-
>
>>IF JUSTSTEM(DBF('alias1')) # 'alias1'
>
>This is prone to introduced nightmarish bugs if you ever happen to use aliases other than the table name.
>
>IMHO, it would be much more solid design to decide that the sources for this type of work will be either views or tables. Views would be better, IMO.
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