Lester B. Cuevas wrote:

> Ann,
> Good Day. Hi there. Can you give me a couple of SOURCE CODE
> regarding to my problem about multi-module of Embedded SQL. I hope you
> give me a example of this kind of tasks.

Here's some code from qli ...



from the help module which accesses only the help database, which
is accessed from only this module - target is variously defined
for different operating systems:


DATABASE HELP_DB = STATIC "help.fdb" RUNTIME target;


from meta.epp which accesses the target database and maintains
a separate connection for miscellaneous work. The "yachts.lnk"
reference is for compilation. Note there is no runtime
qualifier since the "real" database name is only known at runtime
and the connection is made through a runtime attach call. Note
also there is no EXTERN/STATIC qualifier - this is the primary
reference.


DATABASE DB = FILENAME "yachts.lnk";
DATABASE DB1 = FILENAME "yachts.lnk";



From proc.epp which stored qli procedures (quite different
from stored procedures) into a table called QLI$PROCEDURES.
Note the EXTERN keyword.


DATABASE DB1 = EXTERN FILENAME "yachts.lnk";
DATABASE DB = EXTERN FILENAME "yachts.lnk";

From show.epp which handles requests to display metadata
objects in human comprehensible form. Again, note the
EXTERN keyword.


DATABASE DB = EXTERN FILENAME "yachts.lnk";


What you want (I think) is STATIC on each declaration.

Hope this helps,


Ann