Re: What special little thing does table.select need?

From: mklapp (mklapp_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 12:58:01 -0700

As have I. I have used Select on several occasions and have never had this issue. Of course this was filled from an Oracle DB. Is that an Issue? I don't know.

I have counted the zeroes even though the value here is only entered once into the DB and propagated programmatically.

In the Immediate Window, I never got the 'False' result until I placed 0000015615 (or whatever) in double quotes. My inclination is to use double quotes, but haven't get them into strFind.

I find it hard to believe that since the source of the data was Oracle, there was some sort of inherent condition that complicates this. After all, this is a disconnected dataset.

"Marina" wrote:

> Perhaps you have one too many or not enough 0's in the ID you are looking
> for.
>
> if the Length of the array being returned is 0 - then typically the issue is
> a type or something like that. I've definitely done Selects on non-key
> columns and gotten results.
>
> "mklapp" <mklapp@discussions.microsoft.com> wrote in message
> news:242F2B6E-D44A-4248-9F6E-0527726DE918@microsoft.com...
> > OK. You have a point. However, the value is present in the table in the
> column specified and yet Select is not returning any rows. This is
> undesirable. I could stop everthing and recode to use my own trusty binary
> search routine but I expect documented methods to work as documented (just
> an "old School" programmer, I guess).
> >
> > Anyway, bottom line, How do I get Select to work as advertised. Have I
> left something out? Do I have something wrong i the excerpted code. The
> oracle column is nvarchar(10) and the sought after value is also 10
> characters long.
> >
> > Why is Select not returning rows?
> >
> > "Marina" wrote:
> >
> > > IsNothing yields False - which means there is a result coming back.
> > >
> > > Now, Select always returns an array of rows - even if that array is of
> > > length 0. So I think the statement you have there will always return
> False -
> > > the array object will never be Nothing - it might be of length 0, but
> that's
> > > not the same thing.
> > >
> > > "mklapp" <mklapp@discussions.microsoft.com> wrote in message
> > > news:9464BB9C-254E-4B98-B78E-E15E3DD0DFAD@microsoft.com...
> > > > Hello,
> > > >
> > > > I have opened a datset from an Oracle Database.
> > > >
> > > > I am trying to 'Select' a non key column.
> > > >
> > > > strFind = "INTERNAL_EMPL_ID = '" & provId & "'" - This yields :
> > > >
> > > > "INTERNAL_EMPL_ID = '0000015615'"
> > > >
> > > > drArray = ds.Tables(0).Select(strFind)
> > > >
> > > > This should return a single row row array but it does not. No
> exception
> > > is thrown.
> > > >
> > > > in the immediate window the phrase :
> > > >
> > > > ? isNothing(ds.tables(0).select("INTERNAL_EMPL_ID = '0000015615'"))
> > > >
> > > > Yields False and I have seen the id in the table. I know it is out
> there.
> > > Why won't Select find it?
> > > >
> > > > help.
> > > >
> > > > mklapp
> > > >
> > >
> > >
> > >
>
>
>

Relevant Pages

  • Re: What special little thing does table.select need?
    ... array being returned from Select 0? ... Of course this was filled from an Oracle DB. ... quotes, but haven't get them into strFind. ... >> search routine but I expect documented methods to work as documented ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle hash-list?
    ... >>1) What's the hashing algorithm? ... > Unknown, it's proprietary. ... it's also aggressively defended by Oracle - I know of ... two occasions in which a legal Cease & Desist has been fired off... ...
    (Pen-Test)