Pat,
I have done this sort of thing a lot over the years. When there are changes
involving deleting and reusing tables I've found it's easier to open the
data file in the old developer structure and manipulate the data there. I'm
not sure how it will work to add tables that exist in the new
you might not have to do "special programming"
a simple loop over the tables might suffice
i.e.
// open a document referenced by $Doc_Ref
For ($i; 1; Size of array($Bad_Tables))
$Current_Table:=$Bad_Tables{$i}
all records($Current_Table->)
$Record_Count:=records in
I think this is due to UUIDs for each table.
even though you renamed table [Data_61] to [Data_61_x] the uuid is the
same, and probably the upgrade processes the table(s) by uuid not table
name.
the only solution I can think of (off the top) would be to:
- export from the old system the data in
Chuck,
Hmmm. this is a one-off exercise so I would prefer not to do some special
programming. I would like to understand what's going on in the database
though!
Thanks
Pat
On Fri, 15 Jun 2018 at 02:51, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> How about using sql to bring data
How about using sql to bring data from old database into new one
Regards
Chuck
Sent from my iPhone
> On Jun 14, 2018, at 8:36 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> I'm updating a client's database from an old version of my app, in 4D v12,
> to the latest version,
I'm updating a client's database from an old version of my app, in 4D v12,
to the latest version, using v16. There have been various modifications to
the structure in between the version they are using and the current
version. Tables have been added, deleted, repurposed. The result is that
when
6 matches
Mail list logo