Bill,
Can a stored procedure as you describe be used to pull in data from a
variety of datasources, simply using Connect db's and sel's.
ie, set up the dbms with some datasource... then, can the stored procedure
connect to other local rbase db's and pull data... thereby ending up with an
array with data from disparate datasources?
Thanks
Brent Skean
Current Solutions
-----Original Message-----
From: Bill Downall <[EMAIL PROTECTED]>
To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
Date: Sunday, September 22, 2002 9:05 AM
Subject: Re: Witango-Talk: Stored Procedures
On Sat, 21 Sep 2002 19:30:28 -0400, Benjamin Strickland wrote:
>What is the technique or procedure for running stored procedures in a
R:Base database and are there any limitations to during this?
Depending on the SP, it could be as simple as a direct dbms with the
value:
CALL procedurename(parameterlist)
Or
SELECT (CALL procedurename(parameterlist)) from dummytable
where limit = 1
Any SP run from R:Tango or Witango must not have any R:Base user
interface commands in it: no DIALOG, no PAUSE, no EDIT, no
BROWSE. Restrict yourself to flow control commands, variable
manipulation, and SQL DML commands (SELECT, UPDATE, INSERT,
DELETE)
Bill
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
