datatable.select问题 [英] datatable.select problem

问题描述

我使用datatable.select选择数据集中表格中的行。我在choosetring中使用

&符号并得到一个不支持的错误。

语句在企业管理器的查询分析器中工作正常。

select就像：''1& val2''

我使用&有一个二进制AND比较=来检查val2的第0位是否是

设置。

我是否犯了错误？有解决方法吗？

谢谢

Frank

Hi, I use datatable.select to select row in a table in a dataset. I use an
ampersand in the selectstring and get an error that it is unsupported. The
statement works fine in the query analyzer of enterprise manager.
select is like: ''1 & val2''
I use the & to have a binary AND comparison=to check if bit 0 of val2 is
set.
Do I make a mistake? Is there a workaround?
Thanks
Frank

推荐答案

DataTable的语法。选择条件与

DataColumn.Expression属性相同，并在该标题下详细说明。


我的解释是有一个布尔AND运算符但是按位

运营商不受支持。

" Frank" < FR *** @ frank.com>在消息中写道

news：42 ********************* @ news.xs4all.nl ...

The syntax for a DataTable.Select criteria is the same as for the
DataColumn.Expression property and is detailed under that heading.

My interpretation is that there is a boolean AND operator but bitwise
operators are not supported.
"Frank" <fr***@frank.com> wrote in message
news:42*********************@news.xs4all.nl...

我使用datatable.select来选择数据集中表格中的行。我在choosetring中使用了
&符号并得到一个不受支持的错误。
语句在企业管理器的查询分析器中工作正常。
选择如：''1& val2''
我用&有一个二进制AND比较=来检查val2的第0位是否已设置。
我是否犯了错误？有解决方法吗？
谢谢
Frank

Hi, I use datatable.select to select row in a table in a dataset. I use an
ampersand in the selectstring and get an error that it is unsupported. The
statement works fine in the query analyzer of enterprise manager.
select is like: ''1 & val2''
I use the & to have a binary AND comparison=to check if bit 0 of val2 is
set.
Do I make a mistake? Is there a workaround?
Thanks
Frank

Stephany，谢谢你的答复非常快。我将用sqlserver db中的函数来解决它。

Frank

" Stephany Young" <没有人@本地> schreef in bericht

news：eo ************* @tk2msftngp13.phx.gbl ...

Stephany, thanks for a very fast answer. I will solve it with a function in
the sqlserver db.
Frank
"Stephany Young" <noone@localhost> schreef in bericht
news:eo*************@tk2msftngp13.phx.gbl...

DataTable的语法。选择条件与
DataColumn.Expression属性相同，并在该标题下详细说明。

我的解释是有一个布尔AND运算符但是按位运算符不是支持。

" Frank" < FR *** @ frank.com>在消息中写道
新闻：42 ********************* @ news.xs4all.nl ...

The syntax for a DataTable.Select criteria is the same as for the
DataColumn.Expression property and is detailed under that heading.

My interpretation is that there is a boolean AND operator but bitwise
operators are not supported.
"Frank" <fr***@frank.com> wrote in message
news:42*********************@news.xs4all.nl...

我使用datatable.select来选择数据集中表格中的行。我在选择字符串中使用了&符号并得到一个不支持的错误。
该语句在企业管理器的查询分析器中工作正常。
选择如：''1& val2''
我用&有一个二进制AND比较=来检查val2的第0位是否已设置。
我是否犯了错误？有解决方法吗？
谢谢
Frank

Hi, I use datatable.select to select row in a table in a dataset. I use
an ampersand in the selectstring and get an error that it is unsupported.
The statement works fine in the query analyzer of enterprise manager.
select is like: ''1 & val2''
I use the & to have a binary AND comparison=to check if bit 0 of val2 is
set.
Do I make a mistake? Is there a workaround?
Thanks
Frank

Stephany，我解释了select命令错误。在阅读了关于

的文档之后的表达式。一个sqlserver函数当然不能解决这个问题。

我确实需要逐位比较，我找不到相关的东西。

Frank

弗兰克 < FR *** @ frank.com> schreef in bericht

news：42 ********************* @ news.xs4all.nl ...

Stephany,I interpreted the select command wrong. After reading the doc about
the expression. A sqlserver function of course does not solve the problem.
I have indeed need bitwise comparison and I can''t find something about that.
Frank
"Frank" <fr***@frank.com> schreef in bericht
news:42*********************@news.xs4all.nl...

斯蒂芬妮，谢谢你的回答非常快。我将在sqlserver db中使用函数解决它。
Frank
Stephany Young <没有人@本地> schreef in bericht
新闻：eo ************* @tk2msftngp13.phx.gbl ...

Stephany, thanks for a very fast answer. I will solve it with a function
in the sqlserver db.
Frank
"Stephany Young" <noone@localhost> schreef in bericht
news:eo*************@tk2msftngp13.phx.gbl...

DataTable.Select标准的语法是与
DataColumn.Expression属性相同，并在该标题下详细说明。

我的解释是有一个布尔AND运算符，但不支持按位运算符。 />
Frank < FR *** @ frank.com>在消息中写道
新闻：42 ********************* @ news.xs4all.nl ...

The syntax for a DataTable.Select criteria is the same as for the
DataColumn.Expression property and is detailed under that heading.

My interpretation is that there is a boolean AND operator but bitwise
operators are not supported.
"Frank" <fr***@frank.com> wrote in message
news:42*********************@news.xs4all.nl...

我使用datatable.select来选择数据集中表格中的行。我在选择字符串中使用了&符号，并得到一个不支持的错误。该声明在企业管理者的查询分析器中工作正常。
选择如：''1& val2''
我用&有一个二进制AND比较=来检查val2的第0位是否已设置。
我是否犯了错误？有解决方法吗？
谢谢
Frank

Hi, I use datatable.select to select row in a table in a dataset. I use
an ampersand in the selectstring and get an error that it is
unsupported. The statement works fine in the query analyzer of
enterprise manager.
select is like: ''1 & val2''
I use the & to have a binary AND comparison=to check if bit 0 of val2 is
set.
Do I make a mistake? Is there a workaround?
Thanks
Frank

这篇关于datatable.select问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！