Grupo
He visto que se puede usar 2 bases de datos SQLite en una aplicación y es precisamente lo que estoy necesitando, he visto documentación al respecto, pero me gustaría si alguien ya ha hecho eso y si me puede indicar con un ejemplo el CÓMO se puede hacer.
De antemano agradezco la ayuda al respecto.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
First of all, I'm sorry 4 my bad English
I need to use two SQLITE DB , are you have a example I meen I have CatalogDB and TransactionDB I need Attach a SQLITE DB and then use it in sentence like next:
Select c.Country_Id, c. Country_Name, t.Distributor_id, d.Distributor_Name
FROM CatalogDB AS C
INNER JOIN TransactionDB AS t on t.Country_Id = c.Country_Id
BUT I don't know how use ATTACH DATABASE and then how use the two database in muy prg
Thks for some LIGHT (luz in spanish)
Using 2 DB in SQLITE (ATTACH)
Moderator: Rathinagiri
-
- Posts: 113
- Joined: Mon May 19, 2014 7:43 pm
- DBs Used: DBF, SQLite, MS-SQL, ACCESS, MariaDB (en proceso)
- Location: Tizayuca, Hgo. México
- Been thanked: 12 times
- Contact:
Using 2 DB in SQLITE (ATTACH)
Cordialmente
POSADAS SOFTWARE
Jorge Posadas Ch.
Programador independiente
Tizayuca, Hgo.
M é x i c o .
Movil +52 55 2038 5338
SKYPE: jorge.posadasch
Email: posadas_software@outlook.com
POSADAS SOFTWARE
Jorge Posadas Ch.
Programador independiente
Tizayuca, Hgo.
M é x i c o .
Movil +52 55 2038 5338
SKYPE: jorge.posadasch
Email: posadas_software@outlook.com
- Anand
- Posts: 531
- Joined: Tue May 24, 2016 4:36 pm
- DBs Used: DBF
- Has thanked: 226 times
- Been thanked: 82 times
https://stackoverflow.com/questions/569 ... -databases gives an example of similar request. You may try it. I have not used same in HMG but.
Regards,
Anand
Regards,
Anand
-
- Posts: 113
- Joined: Mon May 19, 2014 7:43 pm
- DBs Used: DBF, SQLite, MS-SQL, ACCESS, MariaDB (en proceso)
- Location: Tizayuca, Hgo. México
- Been thanked: 12 times
- Contact:
Anand
Thanks but my problem is with SQLITE and using two different databases (SQLITE) and also I do not know how to use ATTACH
But I appreciate your help
Thanks but my problem is with SQLITE and using two different databases (SQLITE) and also I do not know how to use ATTACH
But I appreciate your help
Cordialmente
POSADAS SOFTWARE
Jorge Posadas Ch.
Programador independiente
Tizayuca, Hgo.
M é x i c o .
Movil +52 55 2038 5338
SKYPE: jorge.posadasch
Email: posadas_software@outlook.com
POSADAS SOFTWARE
Jorge Posadas Ch.
Programador independiente
Tizayuca, Hgo.
M é x i c o .
Movil +52 55 2038 5338
SKYPE: jorge.posadasch
Email: posadas_software@outlook.com
- dragancesu
- Posts: 819
- Joined: Mon Jun 24, 2013 11:53 am
- DBs Used: DBF, MySQL, Oracle
- Location: Subotica, Serbia
- Has thanked: 30 times
- Been thanked: 233 times
I do not know the structure of the database and tables,
Is it possible to put both tables in one base?
I do not use it but in MySQL you can
Try putting all tables in one base
Is it possible to put both tables in one base?
I do not use it but in MySQL you can
Code: Select all
Select c.Country_Id, c. Country_Name, t.Distributor_id, d.Distributor_Name
FROM base1.CatalogDB AS C
INNER JOIN base2.TransactionDB AS t on t.Country_Id = c.Country_Id
- Rathinagiri
- Posts: 5351
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Has thanked: 212 times
- Been thanked: 232 times
- Contact:
In this link you can have the Encrypt SQLite source code. I have used Attach Database in that.
http://hmgforum.com/download/file.php?id=2455
http://hmgforum.com/download/file.php?id=2455
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.