Hi,

 

My problem is that I made a utility in J which create SQL statements
that are retrieved by C# to be executed on an MS-SQL connection. The
original result of my method returns a vector of SQL commands. This was
ok before since I just let C# loop through the vector and execute each
sql statement.

 

Now my problem is that I now want to send a bunch of SQL statement to
the C# connection and the surprising thing is that instead of strings,
C# is getting a byte array.

 

To simulate this problem, try the following:

NB. Original code

   [res=: ;: 'aa bb cc'

+--+--+--+

|aa|bb|cc|

+--+--+--+

NB. The code above is retrieve properly by C# where is can see it as a
string[]

NB. The problem is when I now do the following

   [res=: >;: 'aa bb cc'

aa

bb

cc

   $res

3 2

NB. Now C# treats the data as a 3 x 2 byte array. 

 

I just need to get the data as a string delimited by CRLF or LF ... I
would appreciate any help.

 

Thanks.

 

r/Alex

 

P.S.

Wow, its 11:22pm and its raining outside ... I need to be extra careful
driving home on my bike.

 

----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm

Reply via email to