Message
From
16/12/2006 20:53:04
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01178324
Message ID:
01178334
Views:
27
>I have a routine that creates a TEMP table of the same structure as original. Here is the code:
>
>
>select ORIG_FILE
>local array aDbfStruct[1]
>afields( aDbfStruct )
>create table TEMP_COPY from array aDbfStruct
>
>
>But on the line Create Table TEMP_COPY from array aDbfStruct I get the following error:
>
>
>Feature is not supported for non-.DBC tables
>
>
>What could be wrong with this table?

It could be using some of dbc-only properties (default values, triggers, long field names, nulls etc). Set a breakpoint on the create table command, and in the debugger look at the aDbfStruct array. If there's anyting non-default in any columns beyond the 5th, that's it.

You may be better off with
select * from orig_file into cursor temp_copy readwrite nofilter;
   where .f.
In the end, if you really want the content of the cursor in a free table for later, you can copy it out by a simple copy command.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View