We use create table instead (then issue alter table if necessary) and delete it when we are done with it.
>I wonder if anybody could comment whether or not it is reliable to use ALTER TABLE command against cursors created as a result of queries sent to SQL Server database (via SQLEXEC, sql pass-through) or just created with CREATE CURSOR. We used to use ALTER TABLE often in these situations, however, I found this comment in VFP 8.0 documentation (look at "ALTER TABLE - SQL Command" topic) and now I am not sure if ALTER TABLE is a reliable command against cursors:
>
>"ALTER TABLE might not produce consistent results when used with Visual FoxPro cursors created by the CREATE CURSOR command. In particular, you can create a Visual FoxPro cursor with features, such as long field names, that are normally available only with tables that are part of a database container. ALTER TABLE saves a temporary copy of the cursor, so the rules that apply to free tables also apply, and any features requiring database support are lost or changed in an unpredictable manner. Therefore, you should generally avoid using ALTER TABLE with Visual FoxPro cursors unless you have tested and understood the outcome."
>
>Specifically, this comment pays attention to long column names, which we use in our programming and it seems to always work reliably... So, what does this comment really mean?
>
>Thank you,
>Igor.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"