Brian, Once again, great article. One thing that I'm still trying to work around is the SQL select. I've got programs where I apply logic to the data before it's returned to my .Net app. What I had been doing is building arrays of 'massaged' records and passing that back as string parameters and then parsing it in .Net. That slows down the .Net developers because they can't just bind the data directly to controls. Since I already have the data that I want in arrays, have you found any to return that as a dataset (maybe a formlist or something) short of writing it to a temp table and selecting it via SQL?
Another thing I was curious about but didn't try yet is rather than the SQLExecDirect, will an execute of SQL syntax work (EXECUTE "SELECT * FROM TABLE;")? Mike Randall, MCP -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Tuesday, June 10, 2008 3:43 PM To: [email protected] Subject: RE: [U2] New .Net data provider Mike Read my article on the .Net data provider in Spectrum :) You can download PDF versions from http://www.intl-spectrum.com Regards Brian Anybody out there trying to use the new .Net Data Provider? We seem to be having quite a time finding documentation and getting answers. The key area where we are having issues getting answers is returning datasets from UniBasic programs. With the new driver installed, BASIC programs are called like SQL stored procedures yet the driver doesn't seem to support a dataset/recordset object type. I'm hoping SOMEBODY else is using this stuff beside me. Right? Mike Randall, MCP ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
