• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu
Menu

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.

Show posts Menu

Messages - Fim

#31
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
#32
Have you used slCloseSet ?
/Fim W.
#33
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.
#34
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
#35
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
#36
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.
#37
Paul,
That's what I've solved now.
/Fim
#38
Thanks,
I'll skip it all.
/Fim W
#39
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.
#40
RMchart is an excellent product, but .....
It's dead, no further development, wondering if the product's author is still alive.
/Fim
#41
Yes my intention is to pull the MIN and MAX values from a range of rows using SQL, but how?

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

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
#44
Thanks, now I know.
/Fim W.
#45
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