Yup, you took the words right out of my mouth Ted! That's exactly how I do it.
Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -----Original Message----- From: Ted Wolfley [mailto:[email protected]] Sent: May-21-09 1:23 PM To: [email protected] Subject: RE: Witango-Talk: db connection string in Tango Hi, Using direct dbms action, here is sample of a call I use that passes a parameter and returns a value. DECLARE @return_value int, @vmatrixido int SELECT @vmatrixido = 0 EXEC @return_value = [dbo].[ps_matrix] @vordernumberlist = N'@@user$vordernumberlist', @vmatrixido = @vmatrixido OUTPUT SELECT @vmatrixido as N'@vmatrixido' SELECT 'Return Value' = @return_value Ted -----Original Message----- From: George [mailto:[email protected]] Sent: Thursday, May 21, 2009 12:03 PM To: [email protected] Subject: Re: Witango-Talk: db connection string in Tango Rick, I'm curious to know how you would call store proc's in witango. Do you also pass parameters? Thx George On May 21, 2009, at 9:47 AM, "Rick Sanders" <[email protected]> wrote: I also use SQL Server quite alot. If you're in the same boat as me, the SQL that WiTango generates doesn't quite make the app perform as well as it should, and sometimes the SQL doesn't work the way it should either. What I do is write dtored procedures and just call them from WiTango. Simple queries I let WiTango build for me, but the bigger ones I will do in a stored procedure. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -----Original Message----- From: Alec Katz [mailto:[email protected]] Sent: May-21-09 10:12 AM To: [email protected] Subject: RE: Witango-Talk: db connection string in Tango Thanks for reply, Rick. We use SQL Server on Windows. Alec -----Original Message----- From: Rick Sanders [mailto:[email protected]] Sent: Wednesday, May 20, 2009 1:29 PM To: [email protected] Subject: RE: Witango-Talk: db connection string in Tango I believe you can only do this with Oracle on windows, and Filemaker on the Mac. If I'm wrong, I'm sure someone will jump in. Rick Sanders Webenergy Canada: 902-431-7279 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -----Original Message----- From: Alec Katz [mailto:[email protected]] Sent: May-20-09 2:21 PM To: [email protected] Subject: Witango-Talk: db connection string in Tango Hello, Is it possible in Tango to use db connection string instead of ODBC? Thanks, Alec ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
