Hi

What is the best way to access data in an external module procedure? Do we have to create session, database and query (for example) to access
data? Or is there any other way to use the same session that called the procedure or session created specifically to that procedure? I'm just
guessing...

Does any one has some sample code showing how to access the database that the procedure belongs to? I'll be most appriciative...

Any help will be great. Many thanks in advance

Alfred,

<< What is the best way to access data in an external module procedure? Do
we have to create session, database and query (for example) to access data?
>>

Yes, external modules require that you use your own session, etc. for data
access.

<< Or is there any other way to use the same session that called the
procedure or session created specifically to that procedure? I'm just
guessing...  >>

No, the two are basically "fenced off" from one another.

<< Does any one has some sample code showing how to access the database that
the procedure belongs to? I'll be most appriciative... >>

If you need to perform database access, then you should consider using just
a straight stored procedure and moving only the non-database access work to
an external module.  It will be a) faster and b) allow your procedure to
access information that it normally would not have access to via the
external module.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim