Ask Your Question

Base 'Type formatting' when copying tables [closed]

asked 2017-11-05 18:43:21 +0200

EasyTrieve gravatar image

When I copy a table between two databases (via drag and drop), what is the difference between the similar, optional types, for example between:



Integer [INT] and Integer [INTEGER]


In my case when moving to a MariaDB connected database it seems that I need to select Double [DOUBLE PRECISION], rather than Double [DOUBLE], otherwise I get this error:

image description

I suspect this has to do with my target database being connected to MariaDB, but am not sure.

A second question is that even if I select Double [DOUBLE PRECISION] (and thus don't get the above error), then once the new table is created it shows up as Double [DOUBLE]. This seems strange.

A bit of background in case you're curious: I recently bought a Gamma-Scout geiger counter to monitor any possible future fallout from these two nuclear nut cases (Donald v Kim) who are busy lobbing nuclear threats at each other. The Gamma-Scout can log data every hour (or whatever period I select). I'm testing moving this data to LO Base. So far I've got the data across USB and into CSV, and now into Base by connecting with Text/CSV to the directory where I have my CVS file.

But now when dragging and dropping (copying) the table from the initial .odb to a 2nd .odb connected to MariaDB, one of the dialogs I ran into is this one:

image description

It follows these two dialogs:

image description

image description

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2021-02-06 03:30:44.797919

1 Answer

Sort by » oldest newest most voted

answered 2017-11-06 03:48:54 +0200

Ratslinger gravatar image
edit flag offensive delete link more


Thanks for the link.

EasyTrieve gravatar imageEasyTrieve ( 2017-11-07 04:50:29 +0200 )edit

Question Tools

1 follower


Asked: 2017-11-05 18:43:21 +0200

Seen: 43 times

Last updated: Nov 06 '17