Thanks y'all.
I updated the database to v17 to both export and import the data - this was
even worse!
So ... Chip ... yes please!
Thanks
Pat
On Tue, 21 Aug 2018 at 06:44, Nils Kollandsrud via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> Hi Pat,
>
> I started using Export/import sql to compact/move
Hi Pat,
I started using Export/import sql to compact/move data between versions
since v12, and I remember having issues
with certain versions of v12 when the exported fields contained
single-quotes in that they were not escaped correctly.
If I remember correctly, it was fixed in late v12 versions
Pat, There is a bug with dates when importing using SQL in v12. I don’t know if
it has been addressed in v16 but check that you don’t have years that have 5
digits.
> On Aug 20, 2018, at 5:22 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> I'm exporting data from a v12 database
Pat,
I have 4D native code that can do this task for you.
if you need ti let me know can get it to you tomorrow
Chip
> I'm exporting data from a v12 database using EXPORT SQL and importing it
> into a v16 database.
> For the most part this works OK, but in some tables, records are missing.
> I c
Hi pat
I have out code to clone data in v11 at one of summits. If you install that
code it should get all data for you. I am in Alaska on vacation so can not get
I for you till I return. Please advise if you have it.
Regards
Chuck
Sent from my iPhone
> On Aug 20, 2018, at 1:22 PM, Pat Ben
I'm exporting data from a v12 database using EXPORT SQL and importing it
into a v16 database.
For the most part this works OK, but in some tables, records are missing.
I can't see anything consistently different or wrong within the missing
records.
All text fields are stored within the records.
A
6 matches
Mail list logo