ODBC + Stored Procedures in Multiple Libraries = Trouble

["Eric N. Wilson" <doulos1@xxxxxxxx>]

We are using stored procedures for the majority of our Client/Server stuff.
One problem that we have is that if we have the stored procedure defined in
multiple libraries (SPECIFIC_SCHEMA) when we ask for the parameters we get
the parameters x times. Now this is not too big of a problem with Delphi
because you can delete the extra parameters but in Powerbuilder it is a
"whole nuther ball of wax". This problem even occurs if you fully qualify
the name. The only way that we have been able to address this problem is to
delete all but one of the stored procedure definitions then hook up the
DataWindow and then we can recreate the rest of the stored procedures....
All in all an unpleasant process. Now as to why my client wants to use
powerbuilder only they can tell...



______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---