05-01-2018, 02:04 AM
I am in need to find the time modified information of qm-items in a .qml file. I have written the following macro to get column names. I failed to locate the time modified info. Any advice is much appreciated.
Function QML_Columns
Function QML_Columns
str sPath="K:\QM Backup\18.4847_180429073652_Porto-Res.qml"
str s s0 s1
Sqlite x.Open(sPath 1)
SqliteStatement t g
t.Prepare(x "SELECT text,rowid FROM texts")
g.Prepare(x "SELECT * FROM items WHERE rowid=?1")
int m=g.GetColumnCount
int i rowid
rowid=t.GetInt(1)
rowid=12
g.BindInt(1 rowid)
g.FetchRow
for i 0 m
,s0=g.GetColumnName(i)
,s=g.GetText(i)
,out F"{i} {s0} : {s}"
ret