|
| Inicio → 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 |
| Iniciado por software, 10,sep. 2018 15:10 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 10,septiembre 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 |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
26 mensajes |
|
| Publicado el 17,septiembre 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 |
| |
| |
| | | |
|
| | | | |
| | |
|