Sql Statements?

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

  1. 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.
Reply to
Doug Pic-N-Pac
Loading thread data ...

Reply to
convoluted

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.

Reply to
Jason

Reply to
Doug Pic-N-Pac

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..

- > I agree and i have been doing that (test database internet tutorials) but

Reply to
convoluted

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.