SQLitening Support Forum

Instructions added to post #1

>>Definitely.  See the first post in the general forum.

That means no need for port number and the server computer name and ipadress don't matter?

sServer = "Server"
sPort = "Default"
slConnect(sServer, Val(sPort))


Hello CJ,

>>the log (SqliteningServer.log) would look like this:
07-21-2019 14:45:23  SELECT * FROM parts LIMIT 1
07-21-2019 14:45:55  SELECT * FROM parts LIMIT 2 ORDER BY PRICE

I guess it be great if the user or computer on the network is also shown in the log.

Definitely.  See the first post in the general forum.

Thanks CJ,

All done now. Would do some testing in the days to come.

>>REM slConnect

And it would still run on a LAN?

The link is to a modified SQLiteningServer.bas that might already do what you want.
Compile it and copy  SqliteningServer.exe to whereever your current SQLiteningServer.exe is.

If you installed the modified SQLiteningServer.Bas
the log (SqliteningServer.log) would look like this:

07-21-2019 14:45:23  SELECT * FROM parts LIMIT 1
07-21-2019 14:45:55  SELECT * FROM parts LIMIT 2 ORDER BY PRICE

Also, if you run the filewatcher.exe program, every time someone
accesses the server you would see a scrolling window move up one
line to show you the last line in the log file (SqliteningServer.log)

Sounds like all you need to do is install the modification
and optionally run file watcher to see the changes to the log in real-time.

Quote from: undefinedI've noticed running without the server is much faster on a local network
and not sure it is even needed by most.

>> Really? How does that work?

REM slConnect

Hello CJ,

Thank you for your response.

>>1. Did you download and install this:
https://sqlitening.planetsquires.com/index.php?topic=9697.msg26453;topicseen#msg26453

I think I downloaded it. But I haven't installed it. I will now. How do you use it?

>>Is this to add a time stamp to
  Every insert (unlikely)

Yes. Every Insert, Update, Delete, etc

>>Create a table logging all entries?

Yes. Something like that.

>>Create a flat file text log on disk?

Yes.

>>3. This is for the server, right?

Yes.

>>I've noticed running without the server is much faster on a local network
and not sure it is even needed by most.

Really? How does that work?

Kind regards.

Fredrick,

I haven't used procs, but was thinking of making it easier to insert functions into the server.
I'm not convinced adding code to the server is harder than using a proc once a function is added to demonstrate it that can be duplicated and modified.

After the modification below, SQliteningServer.bas compiles with a click.

1. Did you download and install this:
https://sqlitening.planetsquires.com/index.php?topic=9697.msg26453;topicseen#msg26453

2. Is this to add a time stamp to
  Every insert (unlikely)
  Create a table logging all entries?
  Create a flat file text log on disk?

3. This is for the server, right?

I've noticed running without the server is much faster on a local network
and not sure it is even needed by most.

Downloaded 97-times.
Wonder if anyone uses it?

Might add a new function or two to see if it would
be easier and faster than using the Procs method.
The code compiles "as is" with the update above.

Hello Bern,

This is exactly what I have been looking for.

What is the difference SQLiteningProcsA and SQLiteningProcsB?

Which should I used to implement your codes here.