Data column expression

  • Thread starter Thread starter KPH
  • Start date Start date
K

KPH

Hi,

Consider the following code statement:

dstest.Tables("test").Select("intfield = " + CStr(intval))

Suppose table test has the column name "intfield" with
int32 datatype. Let's dataset test contain the following
rows

Test:
Col 1, Col 2, Col 3 ..., "intfield", ... ,Col 1[0-9]
* , * , * ..., 17 , ... , *
* , * , * ..., 16 , ... , *
* , * , * ..., 6 , ... , *

Could the result of the statement return 0 row if the
intval has the value 6?

It shouldn't, right? However, what we had found for the
return number of rows is really 0. Why is that?

Best regards,
KPH
 
Hi,

What is the datatype of that intfield in your DataTable? Did you try to use
(for test purposes) explicit value of 6

dstest.Tables("test").Select("intfield = 6")
 
Hi,

Datatype of intfield is Int32, and I already had tried to
use "dstest.Tables("test").Select("intfield = 6")" but
the result is not changed.

Did you have any suggest for me?

KPH.

-----Original Message-----
Hi,

What is the datatype of that intfield in your DataTable? Did you try to use
(for test purposes) explicit value of 6

dstest.Tables("test").Select("intfield = 6")

--
Val Mazur
Microsoft MVP
Check Virus Alert, stay updated
http://www.microsoft.com/security/incident/blast.asp


KPH said:
Hi,

Consider the following code statement:

dstest.Tables("test").Select("intfield = " + CStr (intval))

Suppose table test has the column name "intfield" with
int32 datatype. Let's dataset test contain the following
rows

Test:
Col 1, Col 2, Col 3 ..., "intfield", ... ,Col 1[0-9]
* , * , * ..., 17 , ... , *
* , * , * ..., 16 , ... , *
* , * , * ..., 6 , ... , *

Could the result of the statement return 0 row if the
intval has the value 6?

It shouldn't, right? However, what we had found for the
return number of rows is really 0. Why is that?

Best regards,
KPH


.
 
Hi KPH,

I cannot reproduce the problem you've experienced. Please try to check if
that row has been filled into Table("test") of the dataset.

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| Content-Class: urn:content-classes:message
| From: "KPH" <[email protected]>
| Sender: "KPH" <[email protected]>
| References: <[email protected]>
<#[email protected]>
| Subject: Re: Data column expression
| Date: Wed, 15 Oct 2003 20:48:40 -0700
| Lines: 60
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOTmGNBEJvyBTHNTs2hzLMga14WZA==
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:63741
| NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Hi,
|
| Datatype of intfield is Int32, and I already had tried to
| use "dstest.Tables("test").Select("intfield = 6")" but
| the result is not changed.
|
| Did you have any suggest for me?
|
| KPH.
|
|
| >-----Original Message-----
| >Hi,
| >
| >What is the datatype of that intfield in your DataTable?
| Did you try to use
| >(for test purposes) explicit value of 6
| >
| >dstest.Tables("test").Select("intfield = 6")
| >
| >--
| >Val Mazur
| >Microsoft MVP
| >Check Virus Alert, stay updated
| >http://www.microsoft.com/security/incident/blast.asp
| >
| >
| >| >> Hi,
| >>
| >> Consider the following code statement:
| >>
| >> dstest.Tables("test").Select("intfield = " + CStr
| (intval))
| >>
| >> Suppose table test has the column name "intfield" with
| >> int32 datatype. Let's dataset test contain the
| following
| >> rows
| >>
| >> Test:
| >> Col 1, Col 2, Col 3 ..., "intfield", ... ,Col 1[0-9]
| >> * , * , * ..., 17 , ... , *
| >> * , * , * ..., 16 , ... , *
| >> * , * , * ..., 6 , ... , *
| >>
| >> Could the result of the statement return 0 row if the
| >> intval has the value 6?
| >>
| >> It shouldn't, right? However, what we had found for the
| >> return number of rows is really 0. Why is that?
| >>
| >> Best regards,
| >> KPH
| >>
| >
| >
| >.
| >
|
 
Hi KPH,

I'd like to know if this issue has been resolved. Is there anything that I
can help? I'm still monitoring on it.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| X-Tomcat-ID: 121901996
| References: <[email protected]>
<#[email protected]>
<[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: (e-mail address removed) (Kevin Yu [MSFT])
| Organization: Microsoft
| Date: Thu, 16 Oct 2003 07:27:48 GMT
| Subject: Re: Data column expression
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Lines: 69
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:63752
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hi KPH,
|
| I cannot reproduce the problem you've experienced. Please try to check if
| that row has been filled into Table("test") of the dataset.
|
| If anything is unclear, please feel free to reply to the post.
|
| Kevin Yu
| =======
| "This posting is provided "AS IS" with no warranties, and confers no
| rights."
|
| --------------------
| | Content-Class: urn:content-classes:message
| | From: "KPH" <[email protected]>
| | Sender: "KPH" <[email protected]>
| | References: <[email protected]>
| <#[email protected]>
| | Subject: Re: Data column expression
| | Date: Wed, 15 Oct 2003 20:48:40 -0700
| | Lines: 60
| | Message-ID: <[email protected]>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="iso-8859-1"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| | Thread-Index: AcOTmGNBEJvyBTHNTs2hzLMga14WZA==
| | Newsgroups: microsoft.public.dotnet.framework.adonet
| | Path: cpmsftngxa06.phx.gbl
| | Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.adonet:63741
| | NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| |
| | Hi,
| |
| | Datatype of intfield is Int32, and I already had tried to
| | use "dstest.Tables("test").Select("intfield = 6")" but
| | the result is not changed.
| |
| | Did you have any suggest for me?
| |
| | KPH.
| |
| |
| | >-----Original Message-----
| | >Hi,
| | >
| | >What is the datatype of that intfield in your DataTable?
| | Did you try to use
| | >(for test purposes) explicit value of 6
| | >
| | >dstest.Tables("test").Select("intfield = 6")
| | >
| | >--
| | >Val Mazur
| | >Microsoft MVP
| | >Check Virus Alert, stay updated
| | >http://www.microsoft.com/security/incident/blast.asp
| | >
| | >
| | >| | >> Hi,
| | >>
| | >> Consider the following code statement:
| | >>
| | >> dstest.Tables("test").Select("intfield = " + CStr
| | (intval))
| | >>
| | >> Suppose table test has the column name "intfield" with
| | >> int32 datatype. Let's dataset test contain the
| | following
| | >> rows
| | >>
| | >> Test:
| | >> Col 1, Col 2, Col 3 ..., "intfield", ... ,Col 1[0-9]
| | >> * , * , * ..., 17 , ... , *
| | >> * , * , * ..., 16 , ... , *
| | >> * , * , * ..., 6 , ... , *
| | >>
| | >> Could the result of the statement return 0 row if the
| | >> intval has the value 6?
| | >>
| | >> It shouldn't, right? However, what we had found for the
| | >> return number of rows is really 0. Why is that?
| | >>
| | >> Best regards,
| | >> KPH
| | >>
| | >
| | >
| | >.
| | >
| |
|
|
 
Back
Top