SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

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

Pages: [1] 2 3 ... 11
1
You've got Questions? We've got Answers! / Re: Encryption
« on: December 19, 2018, 03:24: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.

2
You've got Questions? We've got Answers! / Re: Can not start the server
« on: December 05, 2018, 06:56:26 AM »
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

3
You've got Questions? We've got Answers! / Re: Can not start the server
« on: December 05, 2018, 03:51:40 AM »
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

4
You've got Questions? We've got Answers! / Can not start the server
« on: December 04, 2018, 12:35:54 PM »
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.

5
You've got Questions? We've got Answers! / Re: Using rowid zero
« on: November 20, 2018, 03:26:59 AM »
Paul,
That's what I've solved now.
/Fim

6
You've got Questions? We've got Answers! / Re: Using rowid zero
« on: November 19, 2018, 12:07:19 PM »
Thanks,
I'll skip it all.
/Fim W

7
You've got Questions? We've got Answers! / Using rowid zero
« on: November 19, 2018, 07:40:22 AM »
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.

8
You've got Questions? We've got Answers! / Re: SQLitening & RMChart
« on: November 03, 2018, 03:30:36 PM »
RMchart is an excellent product, but .....
It's dead, no further development, wondering if the product's author is still alive.
/Fim

9
You've got Questions? We've got Answers! / Re: Finding min and max
« on: August 06, 2018, 11:15:13 AM »
Yes my intention is to pull the MIN and MAX values from a range of rows using SQL, but how?

/Fim W

10
You've got Questions? We've got Answers! / Re: Finding min and max
« on: August 05, 2018, 02:59:42 AM »
Thanks.
I will have a look at it.
/Fim W.

11
You've got Questions? We've got Answers! / Finding min and max
« on: August 04, 2018, 06:19:00 AM »
Code: [Select]
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

12
You've got Questions? We've got Answers! / Re: UTF-16
« on: May 21, 2018, 05:01:29 AM »
Thanks, now I know.
/Fim W.

13
You've got Questions? We've got Answers! / Re: UTF-16
« on: May 21, 2018, 03:22:46 AM »
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:
Code: [Select]
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


14
You've got Questions? We've got Answers! / UTF-16
« on: May 19, 2018, 06:53:43 AM »
How to put strings coded with UTF-16 in a SQLite databas using SQLItening?

This does not work:
Code: [Select]
DIM RAD_IN AS WSTRING
slExe(RAD_IN, "E2")
Parameter mismatches definition says the compiler.
/Fim W.

15
You've got Questions? We've got Answers! / Re: Division with zero
« on: April 22, 2018, 02:04:05 AM »
Thank you for all the tips and advice. Because it's a bit difficult with division with zero, I've decided to go another way. I will ensure that term PRISKVANT is always greater than zero.
/Fim

Pages: [1] 2 3 ... 11