Quote from Gaev on July 2, 2021, 1:54 pm

@s7shanbe

Is it possible to copy all the contents of one table to another table?

It does not appear that there is a native neoDBpro command to do this, but you can use dbpExecSQL ...

https://neodbprohelp.visualneo.com/AdvancedSQL.html

to accomplish this ... here ...

https://www.w3schools.com/sql/sql_select_into.asp

.. you will find the syntax of the native SQL command.

Quote from Vadim on July 2, 2021, 2:10 pm

@s7shanbe

I would export to an external file and then import into a new table.
Or you can copy one record at a time in a loop.
There are probably other ways, I haven't tried them.

Quote from Gaev on July 4, 2021, 1:34 am

@s7shanbe
@vadim

To copy Tables ...

dbpExecSQL "nameOfYourDatabaseIdHere" "syntax of SQL goes here" ""

Syntax of SQL ...

a) make a copy of a table in the same database ...

SELECT * INTO nameOfYourNewTable FROM nameOfTheTableToBeCopied;

b) make a copy of a table in another (existing) database ...

SELECT * INTO nameOfYourNewTable IN 'anotherDatabase.mdb' FROM nameOfTheTableToBeCopied;

 

If you run into problems, just holler.