datatable.select问题 [英] datatable.select problem
本文介绍了datatable.select问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用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屋!
查看全文