PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → Merging 2 tables with same name in different database in one database
Merging 2 tables with same name in different database in one database
Débuté par Eric Strybos, 10 sep. 2018 15:10 - 1 réponse
Posté le 10 septembre 2018 - 15:10
Scenario:
======
1. HFSQL Client/Server database : DB1 and DB2

2. Table A in ANALYSE1 (DB1) have the same description and name of table A in ANALYSE2 (DB2)

Question
======

How can I read the Table A of DB1 and write it in Table A of DB2 by means of the Windev language in one new project ???
In fact records of Table A in DB1 must be added in Table A of DB2.

Error
===
When i make a new project and import both files in my new analyze and changing one of the table names i get a message that the name on disk or the same for the two tables !

What could be the solution ? Any ideas are welcome.

Thanks in advance,

Eric
Membre enregistré
26 messages
Posté le 17 septembre 2018 - 18:08
1. Add first TableA of DB1
2. Go to the description of data files/Info and change name,caption,associated entity, name on disk (eg TableA1)
3. Go to the description of data files/reports and queries and change also the multilingual name and caption of data file (eg TableA1)
4. Add TableA of DB 2
5. Execute HChangeName(TableA1, "TableA") before accessing TableA of DB1