RE: [U2] UniSelectList problem

2007-09-27 Thread Dave Davis
So can't you just use SELECT with BY SEQ instead of SSELECT? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 26, 2007 5:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniSelectList problem Found two

RE: [U2] UniSelectList problem

2007-09-27 Thread Charles_Shaffer
. Thanks. Charles Shaffer Senior Analyst NTN-Bower Corporation Dave Davis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/27/2007 08:05 AM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:RE: [U2] UniSelectList problem So can't you just

RE: [U2] UniSelectList problem

2007-09-26 Thread Brian Leach
Charles What happens if you get the entire list, using slAP.ReadListAsStringArray() You can then check the contents of the list stepping through and iterate through the array instead of using the Next() method. Brian, I tried the following. I set a breakpoint at If Seq = 000 Then ---

RE: [U2] UniSelectList problem

2007-09-26 Thread Charles_Shaffer
] Sent by: [EMAIL PROTECTED] 09/26/2007 05:40 AM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:RE: [U2] UniSelectList problem Charles What happens if you get the entire list, using slAP.ReadListAsStringArray() You can then check

RE: [U2] UniSelectList problem

2007-09-26 Thread Charles_Shaffer
Found two things The LastRecodRead property doesn't seem to work for me unless records are being read. (Despite code samples that show it used this way.) So I ended up using: strAP = A_P-INV_MA ECMD = sess.CreateUniCommand() ECMD.Command = SELECT strAP _

Re: *SPAM* RE: [U2] UniSelectList problem

2007-09-25 Thread Charles_Shaffer
Analyst NTN-Bower Corporation David Jordan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/24/2007 05:54 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:*SPAM* RE: [U2] UniSelectList problem Hi Charles Use the slap.lastrecordread

Re: *SPAM* RE: [U2] UniSelectList problem

2007-09-25 Thread Charles_Shaffer
To: u2-users@listserver.u2ug.org cc: Subject:*SPAM* RE: [U2] UniSelectList problem Hi Charles Use the slap.lastrecordread property to check end of select rather that key . You could run into funny issues including type mismatches that could fall over. Also aren't

RE: [U2] UniSelectList problem

2007-09-25 Thread Brian Leach
Charles Does it work if you pull the sequence number from the key (AP_ID) rather than trying to get it from dynAp.Extract(0) ? That's just the record... Regards Brian Hello, I am new to the list, but old to PICK. Working with Uniobjects in VB.NET to access a Unidata 7 backend database. I

RE: [U2] UniSelectList problem

2007-09-25 Thread Charles_Shaffer
To: u2-users@listserver.u2ug.org cc: Subject:RE: [U2] UniSelectList problem Charles Does it work if you pull the sequence number from the key (AP_ID) rather than trying to get it from dynAp.Extract(0) ? That's just the record... Regards Brian Hello, I am new

RE: [U2] UniSelectList problem

2007-09-24 Thread David Jordan
Hi Charles Use the slap.lastrecordread property to check end of select rather that key . You could run into funny issues including type mismatches that could fall over. Also aren't you meant to look in field 3 not field 2 of the key for 000. If you are new to VB, it is worth considering your

Re: [U2] UniSelectList problem

2007-09-24 Thread Kate Stanton
@listserver.u2ug.org Sent: Tuesday, September 25, 2007 10:54 AM Subject: RE: [U2] UniSelectList problem Hi Charles Use the slap.lastrecordread property to check end of select rather that key . You could run into funny issues including type mismatches that could fall over. Also aren't you meant to look