Thanks Dan. For what it is worth, I am also going to stick with access for a while, however, it looks like sql2k enterprise manager functions in a very similar manner to the access ide. The table design view is the same and it looks like other areas are very similar too. There is just a whole lot of other stuff there.
I have spent alot of time today just getting homesite set up with the extensions for cfmx7. Macromedia definitely does not support homesite like they do dreamweaver. To install the extensions for dreamweaver was an easy exe. file. No such file for homesite...you have to extract the folder into the root and copy and paste the new help files. But if I want to do the plum tutorials, and I do, I have to use homesite. This is actually getting a little expensive too. I have bought plum (make ads go away) and developers edition of sql2k and now homesite. oh well, its only money and it looks like plum will be well worth the effort once I get my head wrapped around it. Thanks, Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nall Daniel A GS-09 336 TRSS/TSUD Sent: Thursday, February 10, 2005 4:07 PM To: Nall Daniel A GS-09 336 TRSS/TSUD; [email protected] Subject: RE: [plum] sql views and plum Oh, and before I forget, "views" in MS SQL are the equivalent of "queries" in MS Access -----Original Message----- From: Nall Daniel A GS-09 336 TRSS/TSUD Sent: Thursday, February 10, 2005 1:03 PM To: '[email protected]' Subject: RE: [plum] sql views and plum Hi Mark, I am in exactly the same situation as you. Like you I am more familiar with Access so I do my database design work there and use the Upsizing Wizard in Access (Tools-Database Utilities-Upsizing Wizard) to convert the database to SQL. It's not elegant but works well and will do until I know SQL better. The conversion handles primary keys with an AutoNumber datatype just fine. For example: It converted a primary key autonumber (with a Field Size of Long Integer and a New Value of Increment) to an int, length 4, Identity =Yes, Identity Seed=1, Identity Increment =1. Hope this helps. Respectfully, Dan Nall -----Original Message----- From: Mark Fuqua [mailto:[EMAIL PROTECTED] Sent: Thursday, February 10, 2005 10:19 AM To: [email protected] Subject: [plum] sql views and plum I just purchased and installed sql 2000 so I could do the Plum tutorials. I have been using ms access for quite some time and I am comfortable with it and the IDE. However, sql 2000 looks like a beast. I have managed to figure out how to use the enterprise manager (sort of) and have imported a previously completed database from access. I have some real newbie questions for anyone out there who feels so inclined: 1. What do I use in place of autoNumber for primary key values? Is there a way to preserve the primary key on import and change the field type automatically? It seems like all my tables have varchar30 values and no primary key where the autoNumber fields were. 2. Can Plum use a view just like it does a table? I think I read that somewhere in the help but a search today did not prove fruitful. Access does not support views and that is the primary reason I wanted to start with sql 2k (and the tutorials of course). The project I want to do with Plum has alot of joined tables and without views, it does not seem like the framework would provide me with much (I mean no disrespect). All of my add/edit/delete actions involve multiple tables. 3. Aside from the tutorials, plum supports access. If access does not support views and Plum does, how does plum work that out? 4. If I want to develope in ms access and then import into sql2k, are there things other than autoNumber I should avoid? Forright now, I really do feel alot more comfortable with access. Thanks alot, Mark ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
