Gerard,
Thank you for the links.
Regarding the Unique ID being an Integer, how can I trust an Integer to
be unique?
If this "rowid" is generated by SQLite, how will it be treated when
exporting datas out of the DB and back? How to maintain the "link"
between tables if I use these rowid for JOINS?
Concerning FileMaker, it is a very nice tool and on its latest versions
is getting really powerfull. Still not a real "language", and devoted to
DB development only. One really good thing is its lack of major bugs,
and fantastic stability. Now RB gives much much more in term of
possibilities of development ;-)
Cheers,
Youri
Dr Gerard Hammond wrote:
Hi Youri,
I use and recommend SQLlite manager.
http://www.sqlabs.net/sqlitemanager.php
It is well worth the small $'s.
An alternative is my own SyBrowser http://www.macsos.com.au but for you
I recommend Marco's super app.
PS.
An integer key is quite standard and probably the most efficient in
terms of speed and space. Much more so than a varchar string.
PPS.
FileMaker is a really good thing to start with and a great thing to
leave..... ;-)
At 9:03 AM +0200 16/10/06, Youri wrote:
Thanks Gerard,
Relying on an Integer seems a strange behavior to me for a unique key.
Coming from FileMaker world I took the habit to define my own keys,
sort of : "aer458yh56h8u45" usually on 10 to 15 character, define me
as a paranoiac if you whish to ;-)
That is why I was looking for a lead on how to define such a key
easily with RB.
Have a nice day in the "Land down under",
Youri
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
