PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV Mobile 2024 → update sqlite on windev mobile
update sqlite on windev mobile
Iniciado por Antonio, jun., 21 2013 8:48 PM - 2 respostas
#1
Publicado em junho, 21 2013 - 8:48 PM
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 em junho, 22 2013 - 5:26 PM
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 em julho, 30 2013 - 2:06 PM
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
→ Voltar para WINDEV Mobile 2024