Ask Your Question
0

Base 'Type formatting' when copying tables

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:

Double [DOUBLE] and Double [DOUBLE PRECISION]

or:

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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Ratslinger gravatar image
edit flag offensive delete link more

Comments

Thanks for the link.

EasyTrieve gravatar imageEasyTrieve ( 2017-11-07 04:50:29 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 22 times

Last updated: Nov 06 '17