I want to pass along something that is probably obvious to most but caught me blind-sided. Hope it helps some newbies like me
For my setup I have been developing on one computer and serving from another which is the recommended practice.
To transfer a new revision to the server computer, I would export my solution, transfer the resulting file, import new solution, and fire up server again. Kind of clunky but not clunky enough for me to waste limited brain power to figure out a better way.
Well, now I have users putting in significant time on my little app. I put a new version in recently and it immediately threw a whole bunch of duplicate ID errors as users were trying to enter records. Went to check my auto-enter options for my key fields and they were completely off. Reason: importing a new version over-wrote the auto-increment keyfield settings on the repository for the server with the repository data from my development computer. Since people are using my app now, the next increment number on my computer is much lower than what is stored on the server.
Here's the hint part: change the repository settings on your development machine to point to the repository on your server machine (replace "localhost" with IP or domain name of your server). Not only will it keep your key fields square but you don't have to go through the export/import routine - just restart the server.
Obviously still learning some of the ropes over here
- david