SQLite and field name

Pagesot

Member
Licensed User
Longtime User
:sign0098:Hello

You may use the expression GetValue (Index) the name of the field instead of your index?

I can not find information ...

Regards
 

Pagesot

Member
Licensed User
Longtime User
:sign0098:

OK, Thanks for the answer ... one more thing, abusing your kindness, I read that there is a command (I think it is vacuum), which is equivalent to the order to compact the database

If it is true that there is this command ... as would be implemented?

Regards
Jordi Lladonosa
 

Pagesot

Member
Licensed User
Longtime User
SQLite Vacuum

:sign0013:Hello, I can not run the VACUUM command in my application ... SQLite processes the command and it not returns error, but the database continues with the same size, which is what I do wrong?

Sub VacuumDB

WaitCursor(True)
modDBs.InitConnDB
modDBs.ConnDBApp.BeginTransaction
modDBs.CmdDBApp.CommandText = "Vacuum"
modDBs.ConnDBApp.EndTransaction
modDBs.CloseConnDB
WaitCursor(False)

End Sub

I guess the syntax is not correct but I've been looking and only find information on command line syntax

Thanks
Pagesot
 

PepSoft

Member
Licensed User
Longtime User
Sub VacuumDB

WaitCursor(True)
modDBs.InitConnDB
modDBs.ConnDBApp.BeginTransaction
modDBs.CmdDBApp.CommandText = "Vacuum"
modDBs.ExecuteNonQuery
modDBs.ConnDBApp.EndTransaction
modDBs.CloseConnDB
WaitCursor(False)

End Sub

Try now

PepSoft
 

Pagesot

Member
Licensed User
Longtime User
Ok Pep:sign0060:, un milió de gràcies, he retirat també l'inici i el final de la transacció perque si no em retornava error.

Salut.!!
Jordi
 
Top