Would anyone know how to write a query to pull up the pictures field in the item's descriptions?
A client wants to know which pictures are updated and which ones are not, and they want a report to query that picture field specifically. Is there a way to query this field in SQL or something else?
They do not own Crystal Reports. Please advise.
Thanks!
SQL:
SELECT Description, PictureName FROM Item
Do you have MS access? Even an older copy like XP will work..and you can get those older copies CHEAP on eBay. You may actually have it in your OFFICE suite if you installed the professional version.
You can access all the data thru access after attaching to the SQL database. (it is called a "project" in Access) You can query until the cows come home. I love it!
You won't need Crystal!
"Jdam" wrote:
I have had some success with this when I need to cut and paste and modify large sets of data in RMS tables. In MS Access you can create "Linked Tables" that point to the RMS tables you need to modify. Then you can see and modify data in a spreadsheet-like format.
The only thing I worry about is data integrity. I never do this during the work day, and never without a solid backup first. I'd hate for Access and RMS to fight over a record and crash the whole system.So far - no problems, but I can't say this has been tested with the aim of trying to break it...
On that note, I have actually considered building a completely new front-end using Access and the RMS database structure (just for fun). Wish I had some spare time and a real database expert sitting next to me...
I find it helps to see the relationships and to make queries/reports. I never use access to update the data in the RMS tables.
You can make the query in Access and then run the SQL command (Access will give show you the corresponding SQL) in RMS admin. (with a backup of course!)
mickie
Jas> I have had some success with this when I need to cut and paste and modify
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.