• Welcome, Guest. Please login.
 
September 17, 2019, 10:20:33 am

News:

Welcome to the SQLitening support forums!


Two questions

Started by Edwin Knoppert2, May 16, 2008, 02:44:09 pm

Previous topic - Next topic

Edwin Knoppert2

Hello,

I have two questions.

1)
Can i have multiple session handles in a single process?
The example shows only one handle, i would like to use multiple handles.

2)
A lot of the functions have parameters byref, but there does not really seems a need for this.
Suggestions is to make these byavl, it's more clear what  get's changed and what will not.

:)

Paul Squires

Hi Edwin,

Very nice to hear from you! It's not very often that we get to talk.
You should be able to have multiple session handles open in a single process, although I am not sure it would be of any great benefit to do so. Not sure why I made those parameters ByRef.... probably just so copies of strings wouldn't be made for performance reasons. I agree with you that its better for me to make them ByVal. Thanks!


Edwin Knoppert2

Someon asked me to make an example..
I will make use of an object since it will be autodestructed by the PowerBASIC compiler.
this way i am sure session and connection is terminated properly.

My wrappers use byval in most cases, the byref is just confusing but i already thought it was not required per se.

I seen remarks of your server before and i had no real use for it but after all the idea of remote access is actually a neat one.
Also that sqlite.dll can be installed at any location.
though it's replace by other parts, but i guess the client code is also available for direct inclusion.
Not investigated that yet.

At this moment i have little use for this server but someone asked so..

:)