Hello Everyone, I was wondering if there was a list of all the tables in RMS somewhere. All tables including any temp tables that are used. I am using a custom dll and have my hooks in place, but I noticed in POS screen it seems the whole time you are building a pos ticket with customer information and inventory information nothing is really being saved to the database yet. Or not that I can see any of the tables I have tried. So you have your screen full and just before you hit tenderbegin it seems none of the work you have done so far on the screen like customer information, inventory information has been saved anywhere. Is this true?
You're right, nothing is written to the database until you tender the sale.
As for a list of tables, just look at all the tables in the database. Unforunately there's no map or anything which gives you the relationships. There is an Excel spreadsheet on PartnerSource, but it is just a list of tables and columns.
You can always use the SQL Profiler to figure out how the tables are used.
What do you mean 'with no timebomb'? I have have several of there software installed on my computer and I have never had any probelms with any of them. This company has been around for quite a while and has some pretty great tools, maybe you should check them out before bashing.
I am stating that a person, as another option, could download Microsoft SQL Server 2000 TRIAL and only install the Enterprise Manager part of it. Microsoft SQL Server 2000 TRIAL software has a "timebomb" (timed expriation date when the software will quit working - hence the term TRIAL). If you only install the Enterprise Manager part it will not be succeptable to the "timebomb" (or timed expiration or TRIAL) and you will still be able to use the GUI as you would be able to if you installed the full version of Microsoft SQL Server 2000.
Many people think TRIAL software is not worth the time to download when it is a package that large and they suspect they will not be throwing down the $1500 in the end, but there is a benefit in this case.
By the way, I have checked out the software you have suggested as well as about 6+ other MSDE Manager applications. Many of these other applications are nice, including the one you had suggested, but I figure why pay $300 plus for a pro version or use a free watered down version with no basic backup/restore/job features that are inherent in the MSDE architecture when you can use the FREE MS Enterprise Manager that utilizes ALL of the inherent MSDE features.
If you use Microsoft Access to link to the database using Get External Data and ODBC, you have a choice of Link or Import the tables. If you Link, it'll ask you which tables and you select all. Then it asks for the primary key for some of the tables it can't discern. Select ID as the primary key except Transaction table - select Transaction Number. There are a few others with no ID field like Movement tables which I don't choose a PK for.
When you're done, you have an access database live-linked to your SQL server database tables and you can see all tables fields and attributes. You can use Access Queries to manipulate data. It looks and works just like an access database. One of my grocery clients is moving to a new building and wanted to put all items on 20% sale excluding certain depts and items containing certain criteria in SubDescr1, and the departments excluded in the 20%sale to be set up for 30% sale. They want to sell as opposed to move as much stock as possible. I used Access's visual, intuitive Query screen to construct, test and update the sale prices, and date range, and check the This Item on Sale box of 35,000 items from home over remote desktop last night. I always attach Access to my installs and use it to analyze and manipulate data.
I'm not that adept at SQL, so sometimes when I'm customizing an Active Report for a client, I'll use Access's Query to visually construct the logic, then click on View SQL to see the SQL code for what I just did and paste it into the Active Report to modify it further there, but it gives me the construct.
Is anyone else using Access with RMS? I don't think I've ever seen anyone mention it. Especially if you're a database person come from a DOS database, paradox, foxpro or access, you'd appreciate the simplicity of using Access to manipulate and analyze RMS data.
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.