Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
session.execute & users |
Sun, Dec 21 2008 9:35 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Is it possible to use session.execute to alter the users in the configuration?
Roy Lambert |
Mon, Dec 22 2008 2:23 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Dec 23 2008 8:13 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Dec 23 2008 2:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |