Select query from transaction table

Posted by jetspeed on April 11, 2007, 8:38 am

Please log in for more thread options

For some reason I can't run a select query on the transaction table. Other
tables work fine
eg. select * from transaction
returns
Incorrect syntax near the keyword 'transaction'

Any ideas?

Cheers

Posted by Glenn Adams [MVP - Retail Mgmt on April 11, 2007, 10:04 am

Please log in for more thread options

The rms database was originally designed in MS Access. It uses some SQL
Server reserved words as table names.
Transaction and Order spring to mind, but there may be a couple of others.

To query these tables you must delimit the tablenames:
select * from [transaction]

Same thing anywhere that you use the transaction table such as the
select list of joins. See the .qrp file for the Detailed Sales report
for examples...

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.

jetspeed wrote:

> For some reason I can't run a select query on the transaction table. Other

> tables work fine

> eg. select * from transaction

> returns

> Incorrect syntax near the keyword 'transaction'

> Any ideas?

> Che