[U2] uonet
I need some help. I'm writing a front-end program using vb.net and uo.net. My form has single valued fields, text boxes and a datagrid. My backend is uv 10.3.3 in windows. Does anyone have or can they direct me to an example that shows how to loop thru a datagrid, pull out the values and update or insert into a uv file using uo.net without using UniSubroutine, preferrable using Unidynarray? Thx, Rudy Rudy Cooper Technical Lead Sage Publications Inc. 2455 Teller Road Thousand Oaks, Ca. 91320 USA T:805.410.7724 www.sagepub.comhttp://www.sagepub.com Los Angeles | London | New Delhi Singapore | Washington DC The natural home for authors, editors societies Please consider the environment before printing this email Learn more about SAGE Research Methods Online (SRMO) - the essential tool for researchers http://www.srmo.sagepub.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uonet
From: Rudy.Cooper Does anyone have or can they direct me to an example that shows how to loop thru a datagrid, pull out the values and update or insert into a uv file using uo.net without using UniSubroutine, preferrable using Unidynarray? Rudy - it seems to me your solution is fairly simple: 1) Find examples of extracting values from specific columns of specific grid rows. 2) Find examples of updating a file with a dynarray. Combine techniques. As usual, these how do I do X with MV questions can usually be answered simply by not trying to solve the problem as a unit. For another (non)answer I just recently got tired of the impedance mismatch between dynarray (or mv.NET mvItem) and ADO.NET DataTable and DataRows. So I created extension methods where I can pass items or collections of items and get a table or row in response. A similar process reverses that. So for example... myArray = table.Rows[i].ToDynArray(); DataTable table = myArray.ToDataTable(schemaInfo); DataRow row = anotherArray.ToDataRow(tableWithSchema); (For schema I pass in a class that identifies field names and data types) HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uonet
None of these articles give you exactly want you want...but they should point you in the right direction... :-) Brian Leach posted an example, which may help, some time ago: http://old.nabble.com/list-DICT-uniObjects-to24476618.html#a24476618 Also Brian wrote this detailed introduction to VB UO available from the U2Users Knowledge Base: http://109.104.64.69/kb/kbview.wsp?id=10 Brian also has his own website various items with tools, freebies and (for a reasonable fee) training manuals, etc. http://www.brianleach.co.uk/pages/books.htm Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: Friday, 7 January 2011 10:02 AM To: 'U2-Users@listserver.u2ug.org' Subject: [U2] uonet I need some help. I'm writing a front-end program using vb.net and uo.net. My form has single valued fields, text boxes and a datagrid. My backend is uv 10.3.3 in windows. Does anyone have or can they direct me to an example that shows how to loop thru a datagrid, pull out the values and update or insert into a uv file using uo.net without using UniSubroutine, preferrable using Unidynarray? Thx, Rudy ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] UONET connection pool problem
One of the reasons we CANNOT leave RedBack is the pricing logic of Connection Pools -- At least with RedBack, each new account only costs us the price of a single U2 seat and as long as the volume is not too high, you're good to go... The WebShare gives the bandwidth (how many transactions at once), but the Responders allow us a number of 'available' accounts cheaply. IBM knows all this -- I've complained about it every chance I get! Hopefully 'Market Noise' will cause them the correct their pricing flaw ... If not, I know Cache or QM will be excited about their pricing in the long run! g But one choice you DO have - build an account of nothing but pointers -- AcctName.FileName as the VocEntry -- and then use *those* to allow one Connection Pool port to 'multiplex' accounts. But it's a PAIN and requires a change to your code to know what account it uses and hence what file to open - and as a bonus, it's impossible to secure correctly! But as IBM will tell you - you DO have a a way to do it with just one CP... In my mind, the answer is that Connection Pooling pricing should be more in line with RedBack - buy a 'volume' in one column (pricey) then buy the number of accounts in the other (cheap)... Just my thought -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, August 21, 2008 4:30 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UONET connection pool problem Symeon: Isn't this the basic problem with U2 Connection Pooling licenses? They only work on a single account at a single time. Very bogus for multi-account activity. The limitations seem pretty broad in scope; mostly by design I'm afraid to say. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UONET connection pool problem
David: Nice thought. There never appears to be an end to the line of people that take short-term profit views to long-term profit potential. Just look at Toyota and General Motors. :-( Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Friday, August 22, 2008 8:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UONET connection pool problem One of the reasons we CANNOT leave RedBack is the pricing logic of Connection Pools -- At least with RedBack, each new account only costs us the price of a single U2 seat and as long as the volume is not too high, you're good to go... The WebShare gives the bandwidth (how many transactions at once), but the Responders allow us a number of 'available' accounts cheaply. IBM knows all this -- I've complained about it every chance I get! Hopefully 'Market Noise' will cause them the correct their pricing flaw ... If not, I know Cache or QM will be excited about their pricing in the long run! g But one choice you DO have - build an account of nothing but pointers -- AcctName.FileName as the VocEntry -- and then use *those* to allow one Connection Pool port to 'multiplex' accounts. But it's a PAIN and requires a change to your code to know what account it uses and hence what file to open - and as a bonus, it's impossible to secure correctly! But as IBM will tell you - you DO have a a way to do it with just one CP... In my mind, the answer is that Connection Pooling pricing should be more in line with RedBack - buy a 'volume' in one column (pricey) then buy the number of accounts in the other (cheap)... Just my thought -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Thursday, August 21, 2008 4:30 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UONET connection pool problem Symeon: Isn't this the basic problem with U2 Connection Pooling licenses? They only work on a single account at a single time. Very bogus for multi-account activity. The limitations seem pretty broad in scope; mostly by design I'm afraid to say. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UONET connection pool problem
I am using UniCommand to execute command on unidata server. When I set UniObjects.UOPooling = true;, I get the following error Unable to read data from the transport connection: A non-blocking socket operation could not be completed immediately.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed If I turn off UOPooling, the program runs properly. Any idea? Can I create two UniSessions (one UniSession uses UOPooling and the other does not use UOPooling) in one application? Thanks -- View this message in context: http://www.nabble.com/UONET-connection-pool-problem-tp19083668p19083668.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UONET connection pool problem
Hi Do you have connection pooling licensed on the U2 server - if you have the enterprise license you get 2 for free otherwise you have to purchase them. Either way you have to turn them on in the licensing program (confprod on udt) I have had problems having both pooled and non pooled connections for the same account in the same class in the same process. - Do some testing to make sure you get it right - you may need to set up a pseudonym account for the non pooled ones - i.e. a windows shortcut or *nix link so that account.np actually is linked through to account. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hugh Yang Sent: 21 August 2008 08:20 To: u2-users@listserver.u2ug.org Subject: [U2] UONET connection pool problem I am using UniCommand to execute command on unidata server. When I set UniObjects.UOPooling = true;, I get the following error Unable to read data from the transport connection: A non-blocking socket operation could not be completed immediately.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed If I turn off UOPooling, the program runs properly. Any idea? Can I create two UniSessions (one UniSession uses UOPooling and the other does not use UOPooling) in one application? Thanks -- View this message in context: http://www.nabble.com/UONET-connection-pool-problem-tp19083668p19083668.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.6/1624 - Release Date: 20/08/2008 19:11 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UONET connection pool problem
Symeon: Isn't this the basic problem with U2 Connection Pooling licenses? They only work on a single account at a single time. Very bogus for multi-account activity. The limitations seem pretty broad in scope; mostly by design I'm afraid to say. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Thursday, August 21, 2008 1:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UONET connection pool problem Hi Do you have connection pooling licensed on the U2 server - if you have the enterprise license you get 2 for free otherwise you have to purchase them. Either way you have to turn them on in the licensing program (confprod on udt) I have had problems having both pooled and non pooled connections for the same account in the same class in the same process. - Do some testing to make sure you get it right - you may need to set up a pseudonym account for the non pooled ones - i.e. a windows shortcut or *nix link so that account.np actually is linked through to account. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hugh Yang Sent: 21 August 2008 08:20 To: u2-users@listserver.u2ug.org Subject: [U2] UONET connection pool problem I am using UniCommand to execute command on unidata server. When I set UniObjects.UOPooling = true;, I get the following error Unable to read data from the transport connection: A non-blocking socket operation could not be completed immediately.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed If I turn off UOPooling, the program runs properly. Any idea? Can I create two UniSessions (one UniSession uses UOPooling and the other does not use UOPooling) in one application? Thanks -- View this message in context: http://www.nabble.com/UONET-connection-pool-problem-tp19083668p19083668.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.6/1624 - Release Date: 20/08/2008 19:11 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UONET connection pool problem
A classic case of the ibm engineers coming up with some good stuff - but it not really working in the real world yes. You can of course connect to multiple accounts each with its own connection pool but it soon gets rather expensive. Certainly makes other DB's more attractive at that point. Alternatively you can use your own, or another's (i.e. MV.NET) multiplexing technology - However the IBM EULA does clearly state that in such circumstances you are still in effect using pooling and should pay up ... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: 21 August 2008 10:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UONET connection pool problem Symeon: Isn't this the basic problem with U2 Connection Pooling licenses? They only work on a single account at a single time. Very bogus for multi-account activity. The limitations seem pretty broad in scope; mostly by design I'm afraid to say. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Thursday, August 21, 2008 1:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UONET connection pool problem Hi Do you have connection pooling licensed on the U2 server - if you have the enterprise license you get 2 for free otherwise you have to purchase them. Either way you have to turn them on in the licensing program (confprod on udt) I have had problems having both pooled and non pooled connections for the same account in the same class in the same process. - Do some testing to make sure you get it right - you may need to set up a pseudonym account for the non pooled ones - i.e. a windows shortcut or *nix link so that account.np actually is linked through to account. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hugh Yang Sent: 21 August 2008 08:20 To: u2-users@listserver.u2ug.org Subject: [U2] UONET connection pool problem I am using UniCommand to execute command on unidata server. When I set UniObjects.UOPooling = true;, I get the following error Unable to read data from the transport connection: A non-blocking socket operation could not be completed immediately.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed If I turn off UOPooling, the program runs properly. Any idea? Can I create two UniSessions (one UniSession uses UOPooling and the other does not use UOPooling) in one application? Thanks -- View this message in context: http://www.nabble.com/UONET-connection-pool-problem-tp19083668p19083668.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.6/1624 - Release Date: 20/08/2008 19:11 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.6/1624 - Release Date: 20/08/2008 19:11 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UONET connection pool problem
Symeon Thanks for your reply. I have connection pooling licensed and can see them by using listuser. I ran the example code on UniObjects for .NET Developerbs Guide page 2-28 and got the same error message. Rarely the code can go through and get the correct result. I assume I need change SocketTimeOut value. However, I can not load SocketTimeOut value from web.config to UniObjects. How can I load configurations from web.config to UniObjects? Thanks Hugh Symeon Breen wrote: Hi Do you have connection pooling licensed on the U2 server - if you have the enterprise license you get 2 for free otherwise you have to purchase them. Either way you have to turn them on in the licensing program (confprod on udt) I have had problems having both pooled and non pooled connections for the same account in the same class in the same process. - Do some testing to make sure you get it right - you may need to set up a pseudonym account for the non pooled ones - i.e. a windows shortcut or *nix link so that account.np actually is linked through to account. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hugh Yang Sent: 21 August 2008 08:20 To: u2-users@listserver.u2ug.org Subject: [U2] UONET connection pool problem I am using UniCommand to execute command on unidata server. When I set UniObjects.UOPooling = true;, I get the following error Unable to read data from the transport connection: A non-blocking socket operation could not be completed immediately.[IBM U2][UODOTNET - UNIRPC][ErrorCode=81009] The RPC failed If I turn off UOPooling, the program runs properly. Any idea? Can I create two UniSessions (one UniSession uses UOPooling and the other does not use UOPooling) in one application? Thanks -- View this message in context: http://www.nabble.com/UONET-connection-pool-problem-tp19083668p19083668.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.6/1624 - Release Date: 20/08/2008 19:11 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/UONET-connection-pool-problem-tp19083668p19101225.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/