Oh thanks. I'll look into ooo.ijs. I guess a lot of us knows that OLE/COM data transfer is easier when the data is coming in from the J Session into .NET or the calling application. The rub lies on putting the data into the session. Like in my case, I may be reading an SQL table that have heterogeneous data like a varchar, currency and date and time columns in one row. In my case, since I use the SetB() interface ... trying to give J a 2 dimensional array of text and numbers will throw a "domain error".
I cant seem to wrap my brains around using the 3!:1 format from .NET so that J would be able to read it properly. I guess I'm really lazy. Hahahahahah. Which asks the question ... does anybody have code that will convert .NET arrays into the 3!:1 format? Is there a way where I can just populate a J variable with a .NET ARRAY variable without conversion first? (I just re-read this and my question is sooo n00b) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of bill lam Sent: Monday, February 26, 2007 2:38 PM To: Programming forum Subject: Re: [Jprogramming] ole array argument Alex Rufon wrote: > Um. Do we have more information online about this? > > You see, since I use the JEXEServer.SetB interface exclusively, I have > been forced to convert my data to string. > > As an example, here is my C# code which takes a .NET DataTable and > creates a CSV string delimited by (16{a.) and (17{a.) for columns and > rows using the StringBuilder class. As you can imagine, when converting > 49,000 rows of data ... there is a very noticeable delay before the data > read from MS-SQL is actually given to the J Session. > Um, I do not have experience with JEXEServer, but you may download the new ooo.ijs to see if anything useful. However I guess that even if it is possible to pass data without converting to string, the overhead of calling idispatch is still very large if it is called repeatedly for 49000 times. You have to minimise this traffic too. Any -- regards, bill ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
