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.
_______________________________________________
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>
