Sql Statements?

Question

Why isnt there a place on this board for a list of SQL statements? For instance.

To change items department from one to another you put in this statement. Then list the statement here. I think a list like that would really help the newbies to RMS out.

convoluted · Accepted Answer

Hi DougI became involved with RMS a few months ago and have also been intrigued with SQL queries and commands; I guess the reason there's no list of statements or queries is because there are a lot of different fields and tables that can be updated, deleted or modified; in addition, it's a dangerous thing as you're directly editing all your records in one fell swoop (hence the "backup first!" disclaimers) The internet is a good place to go for SQL tutorials, do a google search or try this site  or 'd recommend you create a "training" or "testing" database to play around with SQL until you're ready and comfortable to do this on your production databaseHope this helps...."Doug Pic-N-Pac" wrote:

Jason · Answer

I think the problem would be that there are too many variations and specific issues. It would be nice to have an example database, but they would need to be adapted to each user's situation. The disclaimer would need to be in

144pt font. :)

I would actually be willing to supply a web server for a library of reports, html, sql scripts, and other RMS related stuff. I think there is a big community out there to supply examples, but nowhere to upload them.

I just don't have the time to develop the interface. Anyone know of an off-the-shelf free solution that I can install on my hosted web server to accomplish this? I know there are hundreds of user forums, but they are not exactly what we are looking for here. We could do FTP, but that does nothing to provide explanations of each file. I'd prefer a web-based interface.

Jason

P.S. My web host has all the popular stuff - PHP, MySQL, CGI, etc.

Doug Pic-N-Pac · Answer

I agree and i have been doing that (test database internet tutorials) but when doing the tutorials dont ahve the same tables and so on as what rms has. So i would live to see some SQL statments that have some examples in it so I can learn on a test datebase with rms.  But i do understand about the "test Datebase" "c

convoluted · Answer

To test on a database with tables as the ones you're using in your current store database, create a testing database in SO administrator- backup your current database- from that backup, in SO administrator, create a new 'test' database- use SO administrator configuration to toggle back and forth between your test database and your actual store database, or better yet..- install RMS on a separate, independent computer, where you will only use manager and administrator, and create the "testing" database there from your store database backup.....that way you're not toggling back and forth between your test db and actual store db....if you need more info or a step by step on how to do this pls advisehope this helps....."Doug Pic-N-Pac" wrote:

LakeGator · Answer

The suggestions that convoluted are excellent and the reference to the SQL on-line course is a good one. I highly recommend that any use of SQL commands to change the database be done with great care. You could do some serious damage to your system.

Using a second system should help reduce the chance for damage as convoluted suggested. Another approach would be to install the Microsoft SQL Server Management Studio Express tool which is a free download from:

formatting link

This would allow you to create a local copy of the database and do your science experiments on the copy locally. This tool allows you to do backups and restores of your database along with all manner of SQL commands. This includes creating SQL statements from the tables which reduces the time required and typographical errors.

The tool is aimed at technical folks but is pretty easy to use.

Regardless of how you manipulate the database you should be SURE you have a good backup and KNOW you can restore it. Work> Hi Doug

site

formatting link

I'd recommend you create a "training" or "testing" database to play around> with SQL until you're ready and comfortable to do this on your production > database> Hope this helps....>

Sql Statements?

Join the Discussion

Didn't find your answer?