SQLitening Support Forum

SQLitening Support => You've got Questions? We've got Answers! => Topic started by: Fim on December 28, 2019, 09:17:41 am

Title: slSelBind
Post by: Fim on December 28, 2019, 09:17:41 am
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.
Title: Re: slSelBind
Post by: Fim on December 29, 2019, 06:15:06 am
Thanks,
I'll dig into this and see if I understand it.
/Fim W.
Title: Re: slSelBind
Post by: Fim on January 15, 2020, 08:50:05 am
Thank you, that looks good.
Right now I have other problems.
Will return.
Title: Re: slSelBind
Post by: Fim on July 12, 2020, 01:56:54 pm
I previously received some wise answers to my question. But they have disappeared now that I should take up the matter.
Fim W.