Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot create a table from array
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:
25
>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

Click here to load this message in the networking platform