On Friday 04 August 2006 11:56 am, Norman Palardy wrote: > On Aug 04, 2006, at 10:40 AM, D Jungk wrote: > > Hi all, > > After a little experimenting, it looks like REALSQL Table names can > > include > > alphanumeric characters and "$". Since I'm working on something > > that will > > have user created tables whose names will very likely contain illegal > > characters, I have considered two options. > > > > 1) Name the tables: "Table01", "Table02", etc and keep a list in > > prefs so that > > I can display them as they were entered. > > 2) Use EncodeBase64 to change the names and then substitute the "$" > > for the > > "/" that can appear in the Base64 name. (I can strip off the "=") > > > > So, do the experienced people here think either of these is a good > > idea or is > > there some standard way to deal with this? > > > > Thanks, > > DJ > > Or option 3 > > 3) Save yourself the trouble and don't allow users to create tables > that include illegal characters. > A map of "user name" to "real name" will make constructing queries > immensely painful as you will have to replace the user name with the > real name all the time and any mistakes will ruin the results.
Thanks for the input. Unfortunately, this isn't exactly a standard use of the database and the table names will be coming from file names. Each table will be a book (novel, textbook etc.) with one sentence per record. It will be used to search for phrases in context for people learning a language. For now, what I've done is make a Master table that holds the title of the book and the table name that goes with it. We'll see how it works. Thanks again for the input, Don _______________________________________________ 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>
