Re: What special little thing does table.select need?
From: Marina (someone_at_nospam.com)
Date: 06/29/04
- Next message: Lloyd Sheen: "Re: Express Version Kills Current Version - PS"
- Previous message: Lloyd Sheen: "Express Version Kills Current Version"
- In reply to: mklapp: "Re: What special little thing does table.select need?"
- Next in thread: mklapp: "Re: What special little thing does table.select need?"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 29 Jun 2004 16:08:40 -0400
I don't understand what 'False' you are talking about. Is the length of the
array being returned from Select 0?
The only thing I can say is make sure the value you are looking for is
actually there - and identical to what you are looking for.
"mklapp" <mklapp@discussions.microsoft.com> wrote in message
news:0BC63579-D2C5-4CED-850D-6DD862E0F10B@microsoft.com...
> 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
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >
- Next message: Lloyd Sheen: "Re: Express Version Kills Current Version - PS"
- Previous message: Lloyd Sheen: "Express Version Kills Current Version"
- In reply to: mklapp: "Re: What special little thing does table.select need?"
- Next in thread: mklapp: "Re: What special little thing does table.select need?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
