Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
How to get database path in a stored proc? |
Mon, Nov 13 2006 1:39 PM | Permanent Link |
"Bern Rudisill" | I have the following stored proc
if (AnsiCompareText(ProcedureName, 'DatabasePath') = 0) then begin with ServerSession do begin ServerSession.GetRemoteDatabase(RemoteParams.ParamByName('DatabaseName') ..AsString, sDatabaseDesc, sDatabasePath); RemoteParams.Clear; RemoteParams.CreateParam(ftString, 'DatabasePath').AsString := sDatabasePath; end; end; but sDatabasePath is always blank. How do I get the path of a database in a stored proc? Bern -- |
Mon, Nov 13 2006 2:21 PM | Permanent Link |
"Bern Rudisill" | Bern Rudisill wrote:
> I have the following stored proc > > if (AnsiCompareText(ProcedureName, 'DatabasePath') = 0) then > begin > with ServerSession do > begin > > ServerSession.GetRemoteDatabase(RemoteParams.ParamByName('DatabaseName > ') .AsString, sDatabaseDesc, sDatabasePath); > RemoteParams.Clear; > RemoteParams.CreateParam(ftString, > 'DatabasePath').AsString := sDatabasePath; > end; > end; > > but sDatabasePath is always blank. How do I get the path of a database > in a stored proc? > > Bern Figured this one out instead of using ServerSession I had to use ServerEngine -- |
Mon, Nov 13 2006 4:57 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bern,
<< Figured this one out instead of using ServerSession I had to use ServerEngine >> Correct. The proper call was TDBISAMEngine.GetServerDatabase. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |