PC SOFT

FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile

Inicio | Mensajes recientes | Conéctese... |  | Español FR
Inicio → WINDEV Mobile 2024 → update sqlite on windev mobile
update sqlite on windev mobile
Iniciado por Antonio, 21,jun. 2013 20:48 - 2 respuestas
#1
Publicado el 21,junio 2013 - 20:48
I have a database sqlite windev mobile

to update the database, I see that there is no standard solution
I was thinking of doing this
- Copy the old database to an external file, inside the device
- Create the database with the new structure, with hcreate
- Copy the external file record by record to the new database

I dont know if this can working .

Is there any other solution not so complicate ?
regards
#2
Publicado el 22,junio 2013 - 17:26
Hi Antonio

if you are using 18, hyperfile and HModifyStructure are available to do
all that work for you, so migrating to this DB might be an easier solution

Otherwise, SQLite supports a limited subset of ALTER TABLE statements,
and you may solve your problem this way

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

New web site (EXPERIMENTAL) http://www.fabriceharari.eu
(More information on http://www.fabriceharari.com)


On 6/21/2013 12:48 PM, Antonio wrote:
I have a database sqlite windev mobile

to update the database, I see that there is no standard solution
I was thinking of doing this
- Copy the old database to an external file, inside the device
- Create the database with the new structure, with hcreate
- Copy the external file record by record to the new database

I dont know if this can working .

Is there any other solution not so complicate ?
regards
#3
Publicado el 30,julio 2013 - 14:06
you do know that in V18 you can use HyperfileSQL classic? well in there its easy to use the Hmodifystructure. I would just change you app to the new HPFS stuff
→ Volver a WINDEV Mobile 2024