- Welcome, Guest. Please login.
21
You've got Questions? We've got Answers! / Error Code 7 A malloc() faile...
Last post by Fim - April 01, 2020, 05:02:06 AMIn my system, I handle all processing of a Sql database via a special IO module, a module for each table. Everything works as I had imagined. But in a special case I get error code 7. I have done some tests and it seems I do NOT get error if I make all SQL calls directly in a program without going through an io module.
I get the error after 3732 calls with function GU (get unique).
Tips where to look for errors are gratefully received.
/Fim W.
I get the error after 3732 calls with function GU (get unique).
Code Select
FUNKTION_GU:
'===========
'
GU_SELECT:
slOpen TRIM$(KOM.DATABAS)
SET_NUMMER = slGetUnusedSetNumber
SEL_STRANG = "SELECT * FROM ART WHERE ARTNR= " + $SQ + TRIM$(ART.ARTNR) + $SQ
SVAR = slSel(SEL_STRANG, SET_NUMMER) ' Ska ge noll
IF SVAR <> 0 THEN
KOM.FELTEXT = "SYSTEMFEL i ARTIO GU slSel=" + STR$(SVAR) <<============
GOTO SYSTEMFELHANTERING
EXIT SUB
END IFTips where to look for errors are gratefully received.
/Fim W.
22
You've got Questions? We've got Answers! / Re: slSelBind
Last post by Fim - January 15, 2020, 08:50:05 AMThank you, that looks good.
Right now I have other problems.
Will return.
Right now I have other problems.
Will return.
23
You've got Questions? We've got Answers! / Re: Beep Notification
Last post by Fredrick Ughimi - January 03, 2020, 01:48:12 PMHello Cj,
>>sUsers = "127.0.0.1, mycomputer"
I need a little explanation here. Is 127.0.0.1 IP address of the computer I am notifying? I guess 'mycomputer' stands for the name of my computer (the sending conputer)?
>>sUsers = "127.0.0.1, mycomputer"
I need a little explanation here. Is 127.0.0.1 IP address of the computer I am notifying? I guess 'mycomputer' stands for the name of my computer (the sending conputer)?
24
You've got Questions? We've got Answers! / Re: Beep Notification
Last post by Fredrick Ughimi - January 02, 2020, 08:29:41 PMHello Cj,
This would serve as well.
Thanks for the codes. Would try it out.
This would serve as well.
Thanks for the codes. Would try it out.
25
You've got Questions? We've got Answers! / Re: Beep Notification
Last post by Bern Ertl - December 30, 2019, 05:20:11 PMSQLiteningServer doesn't have any methods for pushing notifications to connected clients that I recall.
Your best bet is probably to have connected clients read a transaction file on the server periodically to check for saved updates.
Your best bet is probably to have connected clients read a transaction file on the server periodically to check for saved updates.
26
You've got Questions? We've got Answers! / Re: slSelBind
Last post by Fim - December 29, 2019, 06:15:06 AMThanks,
I'll dig into this and see if I understand it.
/Fim W.
I'll dig into this and see if I understand it.
/Fim W.
27
You've got Questions? We've got Answers! / slSelBind
Last post by Fim - December 28, 2019, 09:17:41 AMWhat 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.
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.
28
You've got Questions? We've got Answers! / Beep Notification
Last post by Fredrick Ughimi - December 26, 2019, 04:32:55 AMHello,
Running SQLitening in Client/Server mode, is it possible to send a notification (a Beep or play a wave file) to another computer on the network when I save a file?
Anyone done this before?
Best regards.
Running SQLitening in Client/Server mode, is it possible to send a notification (a Beep or play a wave file) to another computer on the network when I save a file?
Anyone done this before?
Best regards.
29
You've got Questions? We've got Answers! / Re: Database locked in local m...
Last post by Fim - December 21, 2019, 04:41:06 AMlSetProcessMods "L0" No effect
I will return later with an example.
/ Fim W.
I will return later with an example.
/ Fim W.
30
You've got Questions? We've got Answers! / Re: Database locked in local m...
Last post by Fim - December 20, 2019, 05:46:15 AMYour proposal did not affect the situation.
What I can see, a failed INSERT causes the database to be locked when I try with a REPLACE instead. It only applies in local mode. At the moment, I solve it by doing slClose immediately followed by a slOpen. in case of a failed INSERT.
I will return later with an example.
/ Fim W.
What I can see, a failed INSERT causes the database to be locked when I try with a REPLACE instead. It only applies in local mode. At the moment, I solve it by doing slClose immediately followed by a slOpen. in case of a failed INSERT.
I will return later with an example.
/ Fim W.