• Welcome, Guest. Please login.
 
February 23, 2020, 04:31:28 am

News:

Welcome to the SQLitening support forums!


Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Fim

1
Thank you, that looks good.
Right now I have other problems.
Will return.
2
You've got Questions? We've got Answers! / Re: slSelBind
December 29, 2019, 06:15:06 am
Thanks,
I'll dig into this and see if I understand it.
/Fim W.
3
You've got Questions? We've got Answers! / slSelBind
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.
4
lSetProcessMods "L0" No effect
I will return later with an example.
/ Fim W.
5
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.
6
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.
7
Ok, thanks for the answer.
/Fim W.
8
SELECT strftime('%H:%M:%f','now','localtime')
Is it the timestamp from the server or the client.
I can't find it in the manual, or I'm bad at finding it.

And, if it is from the client, how to get it from the server?
/Fim W
9
Thank you.
/Fim W.
10
According to https://sqlite.org/cli.html item 18, two parameters can be used.
This works ok:
sqlite3 winova.db3 .help
But not this:
sqlite3 winova.db3 .read export.sql
Then I got the error message: Usage: .read FILE
Am I doing something wrong or ....
/Fim W
11
Have you used slCloseSet ?
/Fim W.
12
You've got Questions? We've got Answers! / Re: Encryption
December 19, 2018, 04:54:40 am
With sqlitenings encryption you can not use SELECT * FROM TEXT WHERE ORD = 'ab??rice'
but you can do that with SQLite's encryption.
Am I right??

/Fim W.
13
cj,
Many thanks.
Now it works as it should with 32 bit version.
The error was that I had downloaded the 64 bit version.

/Fim W
14
Cj,
With version 3.14, everything works as it should.
But with version 3.26 I get the error.
So I have had to switch back to version3.14, and then it works. Strange.

I was wrong, the version that works as i should is 3.7.13
/Fim W
15
All I've done is to change sqlite3.dll from versions 3.14 to 3.26. Then I get wrong. There is nothing in the log file.