Is it possible to use session.execute to alter the users in the configuration?

Roy Lambert

Roy,

<< Is it possible to use session.execute to alter the users in the
configuration? >>

Sure.  All of the DDL statements for users can be executed via the
TEDBSession.Execute method.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Is it possible to use session.execute to alter the users in the
>configuration? >>
>
>Sure. All of the DDL statements for users can be executed via the
>TEDBSession.Execute method.

I used it to determine if the user existed eg session.execute('select * from users where name = ''xxx'''); and that worked fine. I tried using the session to CREATE/ALTER and that didn't. Can't remember now if it was just CREATE, just ALTER or both that didn't work. Its easy enough to drop a query onto the form and use it so no big deal.

Roy Lambert

Roy,

<< I used it to determine if the user existed eg session.execute('select *
from users where name = ''xxx'''); and that worked fine. I tried using the
session to CREATE/ALTER and that didn't. Can't remember now if it was just
CREATE, just ALTER or both that didn't work. Its easy enough to drop a query
onto the form and use it so no big deal. >>

All that the TEDBSession.Execute method does is instantiate a TEDBQuery, set
the SessionName to the current session, set the DatabaseName to
'Configuration', and then execute the passed SQL.

--
Tim Young
Elevate Software
www.elevatesoft.com