[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbms

Title:VAX DBMS
Notice:THIS NOTESFILE IS NOT A FORMAL SUPPORT CHANNEL
Moderator:SCARY::CHARLAND
Created:Thu Feb 20 1986
Last Modified:Tue Jun 03 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2642
Total number of notes:11044

2608.0. "BASIC accessing more than one DB?" by M5::BLITTIN () Thu Mar 13 1997 18:27

    
    I have a ct who is trying to access two(or more) dbs from a BASIC 
    application.  He was told that it is possible, but because you can 
    invoke only one db per compiled app, he created a subroutine to 
    invoke the second. However, if he links the main app with the
    sub, he isn't able to fetch anything from the first db, whether he
    does nothing with the second.
    
    Is this a limitation with basic and dml?  Or do we need to create
    separate subs for each invoke and return the info to a main app
    before accessing the second?  Does this make any sense?  Seems to
    be easier (less confusing) with Fortran...
    
    Thank You...
    
    
T.RTitleUserPersonal
Name
DateLines
2608.1ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportFri Mar 14 1997 08:184
   What happens when he tries to fetch from the first db?
   Is he using streams? 
   
   Peter
2608.2Nothing fetched...M5::BLITTINFri Mar 14 1997 13:485
    
    Nothing returned.  Gets some error, but he didn't have these to 
    give me.  Don't think he is using streams, but I'll check.
    
    Thank you...
2608.3ukvms3.uk.oracle.com::PJACKSONOracle UK Rdb SupportMon Mar 17 1997 08:267
>    Nothing returned.  Gets some error, but he didn't have these to 
>    give me.  Don't think he is using streams, but I'll check.
    
    He needs to use streams when acessing multiple databases from the same
    program.
    
    Peter
2608.4Thank You - 'Stream' did itM5::BLITTINMon Mar 17 1997 18:422
    
    Thank you much...the stream id fixed his problem.