MAS90 [英] MAS90
问题描述
有没有人连接到MAS90会计应用程序?
我有连接工作,但我似乎无法得到查询
正确。
我正在使用的简单查询是
这是有效的
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
不起作用
SELECT *
来自AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
和invoiceDate =''3/1/2006''
错误:无效的运算符
也不是这个
SELECT *
来自AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
和invoiceDate = 3/1/2006
错误:无效的运营商
这未能实现
SELECT *
来自AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
和invoiceDate =#3/1/2006#
错误:意外T oken
不确定要使用的其他格式?
我的标准是日期范围。
不确定MAS90数据库是什么是什么选择(我知道它是
而不是MSSQL)
Has anyone over connected to a MAS90 Accounting Application?
I have the Connection working but I cannot seem to get the query
correct.
The simple Query I am using is
This works
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
Does not work
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
and invoiceDate = ''3/1/2006''
Error: Invalid Operator
nor this
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
and invoiceDate = 3/1/2006
Error: Invalid Operator
this fails to
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
and invoiceDate = #3/1/2006#
Error: Unexpected Token
Not Sure what other format to use?
My criteria is a date range.
Not Sure what the MAS90 database is what are the choice(I know it is
not MSSQL)
推荐答案
尝试更改:
和invoiceDate =''3/1/2006''
到此:
和invoiceDate =#3/1/2006#
-
PC数据表
您的资源获取Access,Excel和Word应用程序的帮助
超过1150位用户来自新闻组请求帮助
re ****** @ pcdatasheet.com
" Scott" < SC *********** @ itfirst.com>在消息中写道
news:11 ********************* @ e56g2000cwe.googlegro ups.com ...
Try changing this:
and invoiceDate = ''3/1/2006''
To This:
and invoiceDate = #3/1/2006#
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1150 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
"Scott" <sc***********@itfirst.com> wrote in message
news:11*********************@e56g2000cwe.googlegro ups.com...
有没有人连接到MAS90会计应用程序?
我有连接工作,但我似乎无法得到查询
正确。
简单我正在使用的查询是
这是有效的
SELECT *
来自AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
不起作用
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
和invoiceDate =''3/1/2006''
错误:无效的运算符
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
和invoiceDate = 3/1/2006
错误:无效的运营商
这无法选择*
来自AR_InvoiceHistoryHeader
WHERE InvoiceNo =''0021171''
和invoiceDate =#3/1/2006 #
错误:意外令牌
<不确定要使用哪种格式?
我的标准是日期范围。
不确定MAS90数据库是什么选择(我知道它不是MSSQL)
Has anyone over connected to a MAS90 Accounting Application?
I have the Connection working but I cannot seem to get the query
correct.
The simple Query I am using is
This works
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
Does not work
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
and invoiceDate = ''3/1/2006''
Error: Invalid Operator
nor this
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
and invoiceDate = 3/1/2006
Error: Invalid Operator
this fails to
SELECT *
FROM AR_InvoiceHistoryHeader
WHERE InvoiceNo = ''0021171''
and invoiceDate = #3/1/2006#
Error: Unexpected Token
Not Sure what other format to use?
My criteria is a date range.
Not Sure what the MAS90 database is what are the choice(I know it is
not MSSQL)
我试过那个不工作的例子3我认为这是一个访问类型
查询但是这个也没用。
I tried that in not workong example 3 I thought it was an access type
query as well but this did not work either.
PCD写道:
尝试更改此内容:
和invoiceDate =''3/1/2006' '
对此:
和invoiceDate =#3/1/2006#
Try changing this:
and invoiceDate = ''3/1/2006''
To This:
and invoiceDate = #3/1/2006#
-
对于阅读此主题的人:
人们普遍认为这些新闻组是免费的
交换信息。请注意,PC数据表
是一个臭名昭着的求职者。如果你正在考虑与他做生意,那么我建议你先看看下面的链接
。
http://home.tiscali.nl/arracom/whoissteve.html
兰迪哈里斯
--
To anyone reading this thread:
It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.
http://home.tiscali.nl/arracom/whoissteve.html
Randy Harris
这篇关于MAS90的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!