I liked you previous email about abandoning the complaxities and going back to simple natural things.
So if you apply the same approach to passing array in and out of J, what is the simplest and efficient form(s) to minimize boxing and handle heterogenity passing a table? The single call string approach is not bad. But still it's worth comparing it with the optimized one. --- Alex Rufon <[EMAIL PROTECTED]> wrote: > 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 > ____________________________________________________________________________________ TV dinner still cooling? Check out "Tonight's Picks" on Yahoo! TV. http://tv.yahoo.com/ ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
