• Welcome, Guest. Please login.
 
May 11, 2021, 09:01:37 PM

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 - Jean-Pierre LEROY

1
Dear all,

Is-it possible to setup the error logging Callback provided by SQLite when we use SQLitening ?

More info here:

https://www.sqlite.org/errlog.html

Thanks,
Jean-Pierre
2
Hi cj,

It almost impossible to read your message in this forum.

The font you use is so small, impossible to read.

Regards,
Jean-Pierre
3
Hi Fim,

Yes you should try the CASE expression in your SELECT statement:

SELECT CASE PRISKVANT WHEN 0 THEN 1 ELSE BES_KVANT * PRIS / PRISKVANT END FROM IRA

More info here https://www.sqlite.org/lang_expr.html

Hope that helps,
Jean-Pierre Leroy

4
General Board / Re: Forum just moved to new web host
April 05, 2018, 08:52:36 AM
SQLitening is an extraordinary piece of software ... works perfectly in production environment with many users.

Thank you Paul for keeping this forum alive.
5
Dear all,

For the first time a user got this message The above request was unsuccessful because the database is currently locked. Want to try again?

I'm using two SQLite databases for distinct applications on one server; using my administrator account I ran the Admin Tools to list all the active connections and only one user was still connected to the locked database : user nlefeuvre TCP File Number  6169

So I tried to kill this connection 6169 but without any success; this connection is always there!

Is there anything that could prevent the connection to be killed ? any ideas ?

I knwo I can stop the SQLitening services ... but the problem is that I have other users connected to the other database.

Regards,
Jean-Pierre
6
Thanks a lot for the corrected version  :)

I will do more tests.

Regards,
Jean-Pierre
7
Many thanks. I will try to use your example.

Regards. JPL
8
or why not a function two reverse a two dimensional string Array ?
9
slSelArray is very powerful function to retrieve many records and later display them using a virtual ListView or a grid.

By example, for a specific application, I'm able to retrieve and display thousands of records (30 000) in less than 10 seconds.

Currently slSelArray fills the Array by column then row: Array(Column, Row).

In order to use Array Scan or Array Sort I need the Array in the reverse order, i.e. Array(Row, Column).

Your help will be appreciated.

Thanks.
Jean-Pierre

10
Try LEFT JOIN ART instead of JOIN ART
11
Hi Bern,

A few months ago, you gave me the solution to this issue; I made the change that you mentioned and it works perfectly. Thank a lot.

I think this change should be in implemented in the standard distribution of SQLitening.

This change is very useful with applications with multiple non-modal Windows, where the same end user could (by error) try to edit twice the same record.

Thanks,
Jean-Pierre
12
Hi,

Thank you for your answer.

This workaround should work fine obviously but the only drawback is that the programmer has to manage it.

I was asking myself if SQLitening was not updating internally a system table like this when an slOpen is issued?

Regards,
Jean-Pierre
13
Dear all,

I know the slGetStatus(2) function which returns all connections to the SQLitening server.

I would like to know if someone has created a new function to retrieve the connections to a specific database ?

What I need is the list of users which are currently connected to the database.

Thanks,
Jean-Pierre

14
Currently I'm in vacation.

I will do some tests when I will be back.

It's an interesting topic.

Regards.
Jean-Pierre
15
Dear all,

You'll find two screen-shot from an application that use SQLitening with success.

On a tab called "Summary" we display information about:

- the physical server
- the database engine
- the database file
- the database management system (SQLitening).

Everyday we do :

- a copy of the database at 7:15 pm using this command:

lResult = slCopyDatabase(gDataBase+".sav","E")


- a vacuum at 9:00 pm using this command:

slExe "Vacuum"


On another tab called "Connections & Named locks" we display:
- on the upper part the all connections to the server (it could be useful to be able to filter only the connections to the database(s) used by an application but I don't know how to do that).
- on the bottom part all the named locks on the server.

PS: by convention for my applications, all the named locks are composed of three parts:
1. A prefix with 3 characters used to identify the application.
2. The name of the table on which the named lock is set.
3. The record ID

Example: +LIT:Tasks:22961

With the first part it is easy to filter and display only the named locks associated to the current application.

SQLitening linked with SQLite is very robust; we never had a problem on the server or on the client side. Also the support with this forum is excellent. We've upgraded our version of SQLitening a week ago and so far, no problem at all.

My objective was just to share with you our beautiful experience with SQLitening and SQLite.

I hope that will give others some ideas.

Regards,
Jean-Pierre