SQLitening Support Forum

Have you used slCloseSet ?
/Fim W.

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.

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

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

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.

Paul,
That's what I've solved now.
/Fim

Thanks,
I'll skip it all.
/Fim W

I have a database of just over 60 tables. The names are always 3 letters, such as ARB, ART, FAB. Now I intend to insert a table description in each table on rowid = 0.
Is it good or bad?
/Fim W.

RMchart is an excellent product, but .....
It's dead, no further development, wondering if the product's author is still alive.
/Fim

Yes my intention is to pull the MIN and MAX values from a range of rows using SQL, but how?

/Fim W

Thanks.
I will have a look at it.
/Fim W.


MIN_MAX_START:
    TEMP_MIN = 100
    TEMP_MAX = -100

MIN_MAX_SELECT:
    SQL_SATS = "SELECT TEMP FROM TEMPERATUR WHERE DATE LIKE " + $SQ + 2017% +$SQ
    slSel(SQL_SATS)

MIN_MAX_READING:
    IF slGetRow = 0 THEN EXIT FUNCTION
    TEMP_=  VAL(slFN("TEMP" ))

MIN_OCH_MAX_LAGRING:
    TEMP_MAX = MAX(TEMP_MAX, TEMP)
    TEMP_MIN = MIN(TEMP_MIN, TEMP)
    GOTO MIN_MAX_READING


Is it possible to solve this in an SQL statement only?
/Fim

Thanks, now I know.
/Fim W.

I know that SQLite can handle UTF-16.
I have tested it and it works as I whish.
In my example slExe(RAD_IN, "E2") I was doing wrong, I had declareted RAD_IN as WSTRING.
As far as I understand it should be like this:

DIM RAD_IN AS STRING
DIM NYTT AS WSTRING
NYTT = "ABCD"
RAD_IN = "INSERT INTO ORD (ORDET) VALUES(NYTT)"
SLEXE(RAD_IN, "E2")

Right??
/Fim W

How to put strings coded with UTF-16 in a SQLite databas using SQLItening?

This does not work:

DIM RAD_IN AS WSTRING
slExe(RAD_IN, "E2")

Parameter mismatches definition says the compiler.
/Fim W.