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
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
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 C> For some reason I can't run a select query on the transaction table. Other
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.