Copy Table

[danten]

Hi all.
How can I copy data from one table to another table for DBGrid.Visible conditions.
thank you

[Medium]

Zitat:

Zitat von danten (Beitrag 1226675)

Hi all.
How can I copy data from one table to another table...

up until here, I can follow.

Zitat:

...for DBGrid.Visible conditions.

this part however needs some explaining.

Copying tables in SQL is rather easy. Create a second table with an identical structure like the one you want to copy, and then

SQL-Code:

INSERT INTO myNewTable SELECT * FROM originalTable

will fill it with a full copy. (It gets a bit trickier when triggers and/or constraints are present.) So far, I don't know how a DBGrid is relevant to the copying itself.

[danten]

DBGrid =>> Export to SQL ?

[Perlsau]

Zitat:

Zitat von danten (Beitrag 1226682)

DBGrid =>> Export to SQL ?

DBGrid is a visual component to show data of a query or dataset.

What do you want to do? Export the contents of a query to SQL-Text? Maybe you should train your English or look for a forum in your language ...

[Furtbichler]

Zitat:

Zitat von danten (Beitrag 1226682)

DBGrid =>> Export to SQL ?

Sorry, Daniel. I could not find the word '=>>' in my english dictionary. Even google translate couldn't help.

Would you mind to put your brain in gear, especially the part responsible for human communication. Thank you.

To put it in simple words: Describe what you want, in full full english sentences. Explain your goal. Show what you have tried so far.

BTW: You may use '=>>' in your programming environment.

[olaf]

Hello,

have a look to these examples:

BatchMove
CopyTable

You can find them in the Demo-files of absolut database.

Olaf