SQLitening Support Forum

Check this link - the solution at the end might help to solve your problem.

http://www.ozzu.com/mswindows-forum/problem-obtain-and-dns-address-automatically-t1017.html

Rolf

That is kind of odd. And that is of course causing your problems.

I have no idea why your server is doing that.

Rolf

With cable connection there really should be no connection problems. I sometimes experience them with interntet connections.

Rolf

How are you connected to the network? Cable connection, WLAN, or internet?

Rolf

Where the IP adresses you had assigned in the same range?
If the server for example has the IP 192.168.2.100 then the clients should have adresses like this:
192.168.2.121
192.168.2.70
etc.

The first three numbers should always be the same.

If the Server IP does not change then the server should always be reachable. I have designed my clients that I can run them from an usb stick from any computer.

Rolf

Quote1) Why is that so?

Sounds strange...

Quote2) Is it ok to allow the computer assign IP address to the client computers automatically when using SQLitening?

Yes. Sometimes it happens that the DNS server of a server or router changes the IP adress of a client. If the server works also as DNS server this should be no problem.

Quote3) Is it a must to create an exception for the port No (51234) on the client computers or is it only done on the server computer?

Only on the Server. If you start your client software on a client computer the first time, Windows might ask for permission to let the software communicate on that port.

Rolf

Then really the value of the field QuantityCurrent in tblMainInventory should change, provided all the the other fields in your trigger statement are set properly.

I would suggest you test the behaviour of the trigger in something like sqlite expert. There you can make easily changes to it. That worked quite well for me.

Rolf

What really happens on tblSales? Are you inserting a new record or are you updating an existing one?

Fred's trigger should really work. Did you delete the original trigger first?

Rolf

Hi Fredrick,

the trigger becomes an integral part of your database - just like an index.The trigger will be executed every time you make changes to the table depending on the definition of the trigger. In your case the trigger will be executed each time after adding a row.

You need to set the trigger only once. Trying to add it a second time will give you the error.

See SQLite website for more information:
http://www.sqlite.org/lang_createtrigger.html

Quote
The CREATE TRIGGER statement is used to add triggers to the database schema. Triggers are database operations that are automatically performed when a specified database event occurs.

A trigger may be specified to fire whenever a DELETE, INSERT, or UPDATE of a particular database table occurs, or whenever an UPDATE occurs on on one or more specified columns of a table.

Rolf

Quote from: D. Wilson on February 02, 2012, 11:57:36 PM
If my memory is correct you were looking at Basic 4 Android. Have you looked into this ??

Yes, I am using it for a couple of months now. It is absolutely great. I got my first applications finished. The learning curve is very low if one has Basic knowledge. I had started with Java and Eclipse, but I found that a nightmare. But Basic4Android speeded things up tremendously. Excellent editor, good debugging. Good SQLite support also.

But a SQLitening Client - that would be my dream!

Rolf

Quote from: cliv on February 02, 2012, 02:59:44 AM
Can you post a tutorial how to setup SQLitening Server for web and connection string for client..?

There is nothing special involved of setting up the SQLitening Server as a web server.

You can set up a computer, install the SQLitening server files on it and run it. You would need to get a fixed IP adress from your internet provider or a service like No-Ip.com, DynDns.orr, or similar.

Alternatively you could rent a virtual or dedicated server from web hosting provider. You just need to take care that it is Windows based, not Linux, since the SQLitening Server is a Windows S

The maximum size of an SQLite database will be more or less confined by the limits of your phone - storage space, memory, processor speed. With very large databases it might be better to host them on a server.

Which brings me to my dream - an Android Client for SQLitening!

Rolf

Quote from: cliv on February 01, 2012, 09:58:03 AM
...but i not use compression

Fred may correct me here, but I think SQLitening uses compression in c/s mode for faster data transfer.

Rolf

OK, here is the full project attached.

All dll's are v1.54.
I have included two exe files:
Local.exe reads from the local db file.
ClientInternet.exe reads from my internet hosted server. That server runs Windows Server 2008 net.

Both read all 10,000 records lightening fast.

Rolf