|
| Two analysis: one MySql, one HFSQL classic |
| Iniciado por jobind, 04,mar. 2020 17:58 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 04,marzo 2020 - 17:58 |
Considering the following situation:
- project has one analysis with a connexion to a MySql db
- there is an internal component with a HFSQL classic analysis
- the 2 analysis are identical in their content for table names et
structures
How can the application access both analysis at the same time?
Since the tables have identical names, how do you differentiate them?
_________________
Denis Jobin
Longueuil, Québec |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,marzo 2020 - 19:01 |
"...the 2 analysis are identical in their content for table names et
structures..."
If that is the case, then you need only ONE analysis, described as HF classic
Then, in your init code, you use hconnexion(open, change, etc) to describe two DATABASES, one mysql, one HF and link to them
and finally, because files have the same names on both side, you use halias to describe alternate names, then hchangeconnexion to connect these alternate names to one of the two
In your code, the regular file name are used against one DB, and the alternate ones against the other. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,marzo 2020 - 13:54 |
HAlias looks like an interesting option.
I will look into it.
Thanks Argus!
_________________
Denis Jobin
Longueuil, Québec |
| |
| |
| | | |
|
| | | | |
| | |
|