If you still want to use long field names but don't need persistance between sessions, use CREATE CURSOR instead of CREATE TABLE... the cursor can have long field names and they are always free (not part of the database). The cursors will disappear when the application closes. (They actually get stored as .TMP files in the temp directory while the app runs)
>Ricardo,
>
>Don't put your temporary tables into your main DBC. Create them as a free tables or if you need them to be in a DBC create a separate DBC for a temporary tables only.
>
>>Hi,
>>
>>I have an application that at the begining delete some DBF files that are "connected" to a database (they are not free tables, because i need big field names). So, as i enter at the application i do:
>>
>>LOCAL i
>>OPEN DATABASE DBC() EXCLUSIVE
>>IF ADBOBJECTS(abc, 'TABLE') > 0
>> WAIT WINDOW "Deleting temporary files..." NOWAIT
>> FOR i = 1 TO ALEN(abc)
>> IF USED(abc(i))
>> USE IN (abc(i))
>> ENDIF
>> DROP TABLE (abc(i))
>> NEXT i
>> RELEASE abc
>>ENDIF
>>
>>But, when we have 60 files this become a nightmare for the user, since it take a lot of time. It there any way to delete these files, in a quicker way? NOTE: i cannot use DELETE FILE, otherwise it will give me errors because the "connection" to the database isn't deleted.
>>
>>Any idea?
>>
>>
>>Thanks in advance.