• Welcome, Guest. Please login.
 
April 24, 2019, 09:35:58 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
Have you used slCloseSet ?
/Fim W.
2
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.
3
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
4
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
5
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.
6
Paul,
That's what I've solved now.
/Fim
7
Thanks,
I'll skip it all.
/Fim W
8
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.
9
RMchart is an excellent product, but .....
It's dead, no further development, wondering if the product's author is still alive.
/Fim
10
Yes my intention is to pull the MIN and MAX values from a range of rows using SQL, but how?

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

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
13
Thanks, now I know.
/Fim W.
14
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

15
You've got Questions? We've got Answers! / UTF-16
May 19, 2018, 09:23:43 am
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.