Anyone have a simple example of how you might save and retrieve attributes in the users table?  This looks like it could be very useful but I'm not seeing the light yet.

Thanks,

Dale

Dale


The simplest example is

ALTER USER "FRED" ARRIBUTES 'this is a test'

A good way to try these things is to use EDBManager and then look at SQL History

Roy Lambert [Team Elevate]

Dale,

<< Anyone have a simple example of how you might save and retrieve
attributes in the users table?  This looks like it could be very useful but
I'm not seeing the light yet. >>

You can use a simple TStrings to act like an .ini file via its Names and
Values properties.  You can then save the contents as the attributes via the
Text property.

--
Tim Young
Elevate Software
www.elevatesoft.com

I've been thinking of using this as a way to update remotely synchronized
databases.  When the client application connects, it could query the version
of the table and if the local one is out of date, get the attributes of the
remote server and use it as a SQL Script to update itself.  There might be
an easier way to accomplish this than using attributes (like a separate
table of update scripts).  I haven't played around with all scenarios yet.

David Cornelius
Cornelius Concepts

"Dale Derix" wrote in message
news:34B712F3-C187-44F1-B757-32FA03F8E9D5@news.elevatesoft.com...

Anyone have a simple example of how you might save and retrieve attributes
in the users table?  This looks like it could be very useful but I'm not
seeing the light yet.

Thanks,

Dale