• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu
Menu

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.

Show posts Menu

Messages - Rolf Brandt

#61
Hello Steve,

maybe these links might help you a little further:

http://www.sqlitening.com/support/index.php?topic=3059.msg15576;topicseen#msg15576

http://www.sqlitening.com/support/index.php?topic=2504.msg12494;topicseen#msg12494

Search this forum for 'encryption' to find more threads.

Rolf
#62
General Board / Re: The future of SQLitening
February 07, 2013, 04:52:24 AM
Paul, that is absolutely great! It will be in good hands with you.

I don't know what improvements Fred had cooking meanwhile. but maybe you could get in touch with Lynda, Fred's wife, to get his latest sources. At present though Lynda has no access to Fred's computer since she does not know Fred's password.

Rolf


#63
General Board / Re: Is Fred OK?
February 04, 2013, 01:00:03 PM
Real sad news. I also had tried to contact Fred. We once in while chatted a little on the phone. Today I had to find out that Fred had died on January 9, 2013 at the age of 75 years. I spoke to his wife Lynda today, she told me that Fred had suffered a heart attack and died immediately.

Here is the text of the Obituary:

QuoteFred Herman Meier
11/01/37 to 01/09/13

Fred was born in Menlo, Kansas on 11/01/37. He passed away in Littleton, Colorado on 01/09/13

A funeral mass was held Tuesday, January 15th, 2013 at 10:30 AM at St. Mary
#64
RowID is a record (row) number usually automatically assigned by SQLite. If your row # 2 has the value 'CONCERT' in the ListName column then there cannot be a row # 2 with 'TEST' in then ListName column. RowID is unique. Really the SELECT statement does not make sense. It should be either

Select * FROM MailingList WHERE RowID = 2

or

Select * FROM MailingList WHERE ListName = 'TEST'

The first statement would return just one row. The second statement would return two records - those that have the value 'TEST' in ListName.

What is your reason to use RowID? If sorting is the issue you could use

Select * FROM MailingList WHERE ListName = 'TEST' ORDER BY RowID

You could use ORDER BY of course on any other field like Name, City, etc.

Rolf
#65
Hi Bern,

I have the same problem with remote connections. First I was thinking it might be a timeout, but that cannot be because my client app calls the server at least once a minute.

Rolf
#66
I am just back from a 4 week vaccation in the US, so I had not been following this thread.

I had the same problem using version SQLitening v1.54.
I have v1.50 on the server (Release date 2011-07-04) but had SQLitening.dll und SQLiteningClient.dll as v1.54 (Release date 2011-10-23) on the client. After slDisconnect and slConnect the client would crash - no error, just crash. After replacing the files on the client side to the identical files on the server the problem vanished.

I'm gonna try to see what happens if I update to v1.60.

Which version of SQLitening are you using?

The connection was an internet connection. Server is reached via a fixed IP address provided by NoIp.

Rolf

#67
Great...
#68
Example:

SELECT DonatedItems.MemberID, DonatedItems.OtherField, Members.Address
FROM DonatedItems
INNER JOIN Members ON DonatedItems.MemberID = Members.MemberID


You can then add a WHERE clause.

Rolf
#69
Hi Graham,

Welcome to SQLitening.

QuoteI am looking for a DB system that can handle windows and android clients.

I am pondering over this for a while already, but haven't gotten to it yet. I am using Basic4Android for Android programming and was thinking of a SQLitening Client class.

Rolf
#70
That will be quite helpful at times.

Rolf
#71
An additional parameter for slGetStatus might be a good place for that.

Rolf
#72
I am afraid this is not the right forum for this.

SQLitening is a Client/Server environment for SQLite databases written entirely in PowerBasic. It has superb support for PowerBasic. You can though use it in other languages.

The SQLitening Server runs as a Windows Service, so it will not be combatible with Linux/Unix systems.

Rolf
#73
Here is a piece of code that would do that in PowerBasic using the SQLitening library.


Function Test() As Long
   'This creates a new empty database or open it in case it does exist already.
   slOpen "MySqliteDb.db3", "C"
   'Create table Foo
   slExe "Create Table If Not Exists Foo ([bar])"
   'Add a record
   slExe slBuildInsertOrUpdate ("Foo", "fnord", "bar")
   'Query the table
   slSel "SELECT bar FROM Foo"
   Do While slGetRow
      result$ = slFN("bar")
      'do something with the results
   Loop
   'Close the set
   slCloseSet
End Function


Note:
SQLitening is a Client/Server environment for SQLite databases written entirely in PowerBasic. You can though use it in other languages.

Rolf
#74
Here is a litte more info on the DateTime function from the SQLite website:

http://www.sqlite.org/lang_datefunc.html

Rolf
#75
OK, just found the easy way;

Connect to your server.
Open a database
Use slSelStr("SELECT datetime('now')


#COMPILE EXE "..\Bin\ServerTime.exe"
#DIM ALL
#INCLUDE "..\Inc\SQLitening.Inc"

FUNCTION PBMAIN () AS LONG
   LOCAL s AS STRING
   LOCAL res AS STRING

   slConnect "192.168.2.101"
   slOpen "status.sld"
   s = "SELECT datetime('now')
   res = slSelStr(s)
   MSGBOX res
   slClose
END FUNCTION


Rolf