SQLite and field name

[Pagesot]

Hello

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

I can not find information ...

Regards

[Erel]

Currently not.

[Pagesot]

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

[Erel]

Vacuum is part of the SQLite syntax: SQLite Query Language: VACUUM
As such it is supported by the SQL library.

[Pagesot]

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]

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]

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

Salut.!!
Jordi