• Welcome, Guest. Please login.
July 23, 2021, 06:54:09 PM


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.

Topics - Marty Francom

How do I add a new tablet to an existing SQLite database ?

I want to first check if the table exists in the database and then add it if it
does not exist.
I wrote a simple program and it works perfectly in "Local Mode"  but
when I run it in "Server Mode" the database opens OK  but when the
program searches for a record I get the error message:

        1 = no such table; Prescribers

Here's the INI setup for remote mode:


DBpath=\RSI Easy Script\WexPrescribers
;IP= (your servers IP address or the Computer's name)

Any ideas what might be the problem?
I have used SQLitening on and off for a couple years.  But not often enough to keep proficient.  I apologize for this rather rudimentary question.  I have SQLite database with a Customer table. The customer table has several fields in it.  One field, CDate. contains the next contact date  in YYYYMMDD format.   

I need to retrieve all the CDate fields from the Customer Table and then programmatically manipulate the date and the write it back to the database.

I currently get one record at a time,  make the necessary changes (programmatically) and write it back to the database one record at a time.  This worked fine while the database was small but the database has grown and the process has become painfully slow.

I know that I should be able to get all the records in one statement to the database then programmatically manipulate the data and then write the data back to the database in one statement.

I have made a couple attempts at writing the statements but I am hopelessly tangled up.

Would anyone have the time to write some sample SQLitening statements that I could use as templates in solving my problem.  Your assistance will be most appreciated. Thanks.   
I have quite a number of customers that are using SQLitening v1.4 and I would
like to upgrade them to version 1.54.

To do it correctly, what steps are recommended?

Can I just just delete the old files and copy the new file to their hard disk?
Does the SQLitening Server need to be UnInstalled first?
Do they need to reboot their computer.

I need to be able to automate the process because most of my customers are
not computer literate.  Any suggestions?

   Is the new version backward compatible with programs compiled using version 1.40 Include file?
Or do those programs need to be recompiled with the 1.50 include file?
I notice that the new version zip file does not contain the zLib.DLL file.   Is this file no longer required?
I am getting a error  -14  that I am having trouble tracking down.  Occurs only occassionally.

What would be the most likely cause? 

What might be the best way track this error down?
I have a report that I want to build and I need to get ALL the records in a Table for this report.
I have been getting the records one at a time but I am sure there is a better way.

How would I get all the records (with all there fields) in a Table with one SQLitening call?
That is how should I build the call ?
Also, can the record be returned sorted by one of the fields?
I have a function that loops through record gathering records that need changes.

Currently I find a record anthe make the change to the record.  This works OK but
is reather slow.   I would rather gather all records that need changes then make one
call to SQLite to write the records.  I have tried to do this but I must be doing someting
wrong.   From this code snippet, can you tell me what I am doing wrong?

             'rc = slExe (slBuildInsertOrUpdate(sTbl, wk, lDgF, wStr), "E")
             allRecs = slBuildInsertOrUpdate(sTbl, wk, lDgF, wStr)
             cnt2 += 1 
             sTxt = Parse$(DrgRec, Chr$(127), 5) & "!"
        rc = slExe (allRecs,  "E") 

Do I need to insert a "separator" between record sets?
General Board / I need some enlightenment
February 07, 2011, 01:32:25 AM
    I have a report writer that I would like to use to create reports from my SQLite database.  However, it can not connect. (Or at least it I can't find a way to connect to it).  In the docs it says to use an ODBC driver.  I am not sure what an ODBC driver is.     Can someone enlighten me?

   Would SQLiteningServer be an ODBC driver?   

    Fred,  if not,  would it be possible to compile the SQLiteningServer into an ODBC driver?

I got the following warning message:

It seems the "case" of the "path" is of importance.

Could this be the reason that the SQLiteningServer fails to start  for me on rebooting the computer?
You've got Questions? We've got Answers! / Can I use
January 25, 2011, 12:36:17 AM
Can I use the new SQLite3.DLL  that was released on 8th Dec 2010 ?

I have tried it an it seems to be OK with the current SQLitening,  but I thought
maybe I shoould check with Fred before making this version available to my customers.

Fred... Any problem using v 3.7.4 with SQLitening?
Does anyone here know if SQLitening/SQLite are compatible with Alpha-5 ?

Alpha-5 has indicated that it is as long as their is an  ODBC driver for SQLite.

Does anyone here have any experience with Alpha-5 RAD?

General Board / Report Writers
January 23, 2011, 11:48:12 PM
I have been looking for a Report Writer Tool that I can use with my SQLite db.
Here's a link to a video of one such report writer.  I claims compatible with
any SQL database.   
Does anyone here have experience with this report writer?
Is it compatible with SQLite?


Fred,  If the connection time out is set to -1   Does this mean that SQLitening will consider
a connection active even after the user ends his application?   
   If so, is there a way to forse a connection closed when timeout is set to -1 ?

The reason I ask is that my application counts the number of active connections and
uses this to determine if the user has exceeded his allowed maximum number of users.

I am having a problem with some customers having more active connections than they
have applications running.   
This seams to only happen with my Win7 customers XP has not shown this problem.
The problem:

SQLitening Server is installed on Win-7  using "Run as Administrator"   all works fine
until the customer reboots.  Then, the application won't start get error -16   

Then I run SQLiteningServerAdmin  and it shows the server is running and askes if
I want to "STOP" it.    If I Stop it and Restart it the that application can connect to the

I have looked at and modified settings using  Service.msc  but that has made no
difference.  The problem still occurs.  This seams to be a Win-7 specific problem.

Has anyone else experienced this problem?  More importantly, Have you found a solution?

Fred,  On rebooting the computer, Is it possible for SQLitening to check and restart it's self
if it is not functioning?
I have a strange situation.   I have a customer that is
getting the message  "Maximum Connections Exceeded"

I believe this message is coming from SQLitening (but I am not sure).
Fred:    Is this a message that SQLitening might generate?

If so, then it might be generating in error.   Here's the situation:
My customer has has two work stations.  One is a laptop.
If both workstations are connected to the database and he shut down his laptop and takes it home. Then when he comes back and recoonectes to the Network and tries to run the application which connects to the database, he will then get the  "Maximum Connections Exceeded"  error.    He then must shut down and restart the SQLiteningServer  before he is able to reconnect both workstations.

Is there anything I can do to resolve this problem?
In my program I have a field for Initial  (single character field)  If a  + - . character is put in that field and the record is saved, then I get an:
     SQLite or SQLitening error            1 = near "+" : syntax error

Field is a character field.  Are character fields of 1 character long not allowed to have a  + - or .  character in them?   Why is that ?

I decided to use: 
   Replace$ chr$(0,43,0) with chr$(0,0) in sFld$
to remove these troublesome characters.   Is there a better way to handle the problem?  Are there other characters that would cause this problem?

    When I was setting up the SQLiteningServer using Windows Server Manager.  I noticed a strange character at the end of the path  (see picture).   Is that supposed to be there?    The reason i ask is because I have been having problems with the server not properly restarting.  I have it set to Automatically restart.   Just want to rule out that this is the cause of the problem.
    The default Font Size on this forum is too small.  My old eyes can barely read the messages.       Is it possible for you to  increase the default font size for the forum to say  10 or 12 point ?