• Welcome, Guest. Please login.
 
June 02, 2020, 01:53:06 am

News:

Welcome to the SQLitening support forums!


Recent posts

Pages 1 2 3 4 ... 10
11
You've got Questions? We've got Answers! / Re: Beep Notification
Last post by Fredrick Ughimi - January 03, 2020, 01:48:12 pm
Hello 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)?
12
You've got Questions? We've got Answers! / Re: Beep Notification
Last post by Fredrick Ughimi - January 02, 2020, 08:29:41 pm
Hello Cj,

This would serve as well.

Thanks for the codes. Would try it out.
13
You've got Questions? We've got Answers! / Re: Beep Notification
Last post by Bern Ertl - December 30, 2019, 05:20:11 pm
SQLiteningServer 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.
14
You've got Questions? We've got Answers! / Re: slSelBind
Last post by Fim - December 29, 2019, 06:15:06 am
Thanks,
I'll dig into this and see if I understand it.
/Fim W.
15
You've got Questions? We've got Answers! / slSelBind
Last post by Fim - 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.
16
You've got Questions? We've got Answers! / Beep Notification
Last post by Fredrick Ughimi - December 26, 2019, 04:32:55 am
Hello,

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.
17
You've got Questions? We've got Answers! / Re: Database locked in local m...
Last post by Fim - December 21, 2019, 04:41:06 am
lSetProcessMods "L0" No effect
I will return later with an example.
/ Fim W.
18
You've got Questions? We've got Answers! / Re: Database locked in local m...
Last post by Fim - December 20, 2019, 05:46:15 am
Your 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.
19
You've got Questions? We've got Answers! / Database locked in local mode ...
Last post by Fim - December 17, 2019, 09:17:34 am
I am building a smaller ERP system with Powerbasic and SQLitening. It works as it should when I run in Remote mode. But when I run in Local mode I get "Database locked" every now and then. It does not appear to be a systematic error. Does anyone have a tip where to look for the error?
/Fim W.
20
You've got Questions? We've got Answers! / Re: Debtors List
Last post by Fredrick Ughimi - December 13, 2019, 06:25:41 am
Hello CJ,

>>Call slSelAry (or slSel once.)

I still will like to make yours work for me.
Pages 1 2 3 4 ... 10