• Welcome, Guest. Please login.
 
July 04, 2020, 12:47:08 pm

News:

Welcome to the SQLitening support forums!


slSelBind

Started by Fim, December 28, 2019, 09:17:41 am

Previous topic - Next topic

Fim

What I'm getting is slSelBind is a method of using "Prepared Statement Object" in SQLite
In an ERP system there is something called "requirements explosion" and I have programmed it, works ok, but it takes time.
This slSel-sts is executed 220 times for a particular item:
"SELECT MTRLNR, POS, QUANT, FROM_VECKA, TOM_VECKA, SORT_1 FROM STR WHERE ARTNR =" + $ SQ + TRIM $ (ARTNR) + $ SQ + "ORDER BY MTRLNR"
Instead, I've tried this:
slFIX = slBuildBindDat ("$ SQ + TRIM $ (ARTNR) + $ SQ")
..
..
slSelBind ("SELECT MTRLNR, POST, QUANTITY, FROM_VECKA, TOM_VECKA, SORT_1 FROM STR WHERE ARTNR =? ORDER BY MTRLNR", slFIX, SET_NUMMER_TABELL (NIVA))

But it does not work, I think wrong, but I do not know what.
Fim W

Fim

Thanks,
I'll dig into this and see if I understand it.
/Fim W.
Fim W

Fim

Thank you, that looks good.
Right now I have other problems.
Will return.
Fim W