I'm new to the world of Plum, I actually just signed up for the mailing
list today...so I can't answer the Plum questions..sorry!
I do know that instead of AutoNumber you use identity seed and seed
increments to auto populate fields in sql2k. You will see these in
design view of the enterprise manager. I think you have to set identity
seed = yes and then set the increment.
Good Luck,
Brian
Mark Fuqua wrote:
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
**********************************************************************
