Ralph,

<< 3. Registering the procedure? But How? Do I need to use the tabsheet
"procedures"? or "procedure users" What do I need to type there exactly in?
"onServerProcedure"? >>

<< 4. Which rights are necessary to ececute this procedure? and where can I
adjust it? >>

You can do this all in code in the actual server itself via these methods:

http://www.elevatesoft.com/dbisam4d7_tdbisamengine_addserverprocedure.htm
http://www.elevatesoft.com/dbisam4d7_tdbisamengine_addserverprocedureuser.htm

Or you can do it remotely via these methods:

http://www.elevatesoft.com/dbisam4d7_tdbisamsession_addremoteprocedure.htm
http://www.elevatesoft.com/dbisam4d7_tdbisamsession_addremoteprocedureuser.htm

You can modify or delete the same using similar methods:

http://www.elevatesoft.com/dbisam4d7_server_administration.htm

<< 5. Do I call from my normal application "Session.CallRemoteProcedure"
(and nothing more? I mean without parameters or somtething...?!) to execute
this procedure? >>

See Eryk's response - you use the RemoteParams property to add any necessary
parameters:

http://www.elevatesoft.com/dbisam4d7_calling_server_procedures.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim / Eryk


I may be missing something here but from my reading of Ralph's post all he needs is the datapath to add to the relative path so that he can eg display a jpg using shellexecute. The answers you're giving seem to be involved with sending the file across when all he needs is the path or is the answer the same for both cases?

I thought there was something built into the server to get the datapath given the database.


Roy Lambert

OK, understand...

But how can I access for example the correct file for a selected record?

Thank you in advance.

Best regards,

Ralph

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Ralph,

<< I've just read in the help files about server procedures.... is this
procedure always relevant for the selected record in the table? >>

Server-side procedures have no relation whatsoever to a table.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

> I may be missing something here but from my reading of Ralph's post all he needs is
> the datapath to add to the relative path so that he can eg display
> a jpg using shellexecute.

That would be a path from the perspective of the server so an attempt by
the client to ShellExecute it would almost certainly fail unless the
client and the server are on the same physical machine.

> I thought there was something built into the server to get the datapath given the database.

There is, I used it in the the example to retrieve the full path to the
file in order to send it back (Engine.GetServerDatabase).

Eryk

Ralph,

> But how can I access for example the correct file for a selected record?

The example I posted does that:

        RemoteParams.CreateParam(ftString,'DatabaseName').AsString:='Main';
RemoteParams.CreateParam(ftString,'FileName').AsString :=
    MyTable.FieldByName('FileName').AsString;

....it is passing the FileName from the currently selected record of
'MyTable'.

Eryk

Many Many Thanks to all of you guys!



Eryk Bottomley <no@way.com> wrote:

Ralph,

> But how can I access for example the correct file for a selected record?

The example I posted does that:

        RemoteParams.CreateParam(ftString,'DatabaseName').AsString:='Main';
RemoteParams.CreateParam(ftString,'FileName').AsString :=
    MyTable.FieldByName('FileName').AsString;

....it is passing the FileName from the currently selected record of
'MyTable'.

Eryk

Hi,

I am sorry again,

how can I retrieve the currrent Server DB-Path from the client side?

Many thanks,

Ralph


Ralph <ralphdietrich@gmail.com> wrote:

Many Many Thanks to all of you guys!



Eryk Bottomley <no@way.com> wrote:

Ralph,

> But how can I access for example the correct file for a selected record?

The example I posted does that:

        RemoteParams.CreateParam(ftString,'DatabaseName').AsString:='Main';
RemoteParams.CreateParam(ftString,'FileName').AsString :=
    MyTable.FieldByName('FileName').AsString;

....it is passing the FileName from the currently selected record of
'MyTable'.

Eryk

Hi,

when I use this for example:
 Engine.GetServerDatabase('TCSDB',sDesc,sRemoteDirectory);
 ShowMEssage(sRemoteDirectory);
Then sRemoteDirectory is always empty ('').

Any help please?

Thanks

Ralph


Ralph <ralphdietrich@gmail.com> wrote:

Hi,

I am sorry again,

how can I retrieve the currrent Server DB-Path from the client side?

Many thanks,

Ralph


Ralph <ralphdietrich@gmail.com> wrote:

Many Many Thanks to all of you guys!



Eryk Bottomley <no@way.com> wrote:

Ralph,

> But how can I access for example the correct file for a selected record?

The example I posted does that:

        RemoteParams.CreateParam(ftString,'DatabaseName').AsString:='Main';
RemoteParams.CreateParam(ftString,'FileName').AsString :=
    MyTable.FieldByName('FileName').AsString;

....it is passing the FileName from the currently selected record of
'MyTable'.

Eryk

Ralph,

> how can I retrieve the currrent Server DB-Path from the client side?

You can't do that from the client side using normal methods. You can use
an administrative session component (Session.GetRemoteDatabase) to do
it, but that functionality is really designed for writing SrvAdmin type
utilities rather than normal client applications.

The method I posted using the Engine component will only work when
EngineType = etServer ...which means from within the server executable,
as with a stored procedure.

Eryk

Ralph,

<< when I use this for example:
 Engine.GetServerDatabase('TCSDB',sDesc,sRemoteDirectory);
 ShowMEssage(sRemoteDirectory);
Then sRemoteDirectory is always empty (''). >>

Is the TCSDB database defined on the database server with a non-empty path ?

--
Tim Young
Elevate Software
www.elevatesoft.com