Table Question

[Richard]

I have a table on our sql server "dbo_tblWarehouse" that is linked to my
form. My question is I want to add a new field called comments and make it a
memo field. Is it possible to do it through a query or do I need to have the
IT guys open it in design view and add it from the server end?

Thanks
Richard

 

[Philip Herlihy]

I have a table on our sql server "dbo_tblWarehouse" that is linked to my
form. My question is I want to add a new field called comments and make it a
memo field. Is it possible to do it through a query or do I need to have the
IT guys open it in design view and add it from the server end?

Thanks
Richard

If you're going to store an additional item then there has to be a field
in a table somewhere, and it seems likely that this should be in the
same place as the existing fields - although it doesn't have to be: you
could have a local table storing comments if you can link it to the SQL
Server data (using a "key" field). Something I'd avoid unless there's a
really good reason not to.

Deciding where a field should be stored, and how fields are grouped into
tables is a key art of database design - it's called "normalisation".
Probably best left to the server guys to help you with this one. If you
want to know more about the issues, try this video:

http://www.lynda.com/home/Player.aspx?lpk4=31001

... or this, from Microsoft:

http://tinyurl.com/ms-table-design-tutorial

Phil, London

 

[Richard]

Philip,

I think you totally missed my point I built this over a year ago, it is
normalized and is in full production b/f with 10 users. I just wanted to
know if its "possibile" to use a query to add a field into a linked
table....... Probably yes or no would be the answer I am looking for. I am
leaning towards no...but you never know.

If you're going to store an additional item then there has to be a field
in a table somewhere, and it seems likely that this should be in the
same place as the existing fields -

DUH!


this doesnt address the question either

Deciding where a field should be stored, and how fields are grouped into
tables is a key art of database design - it's called "normalisation".

Probably best left to the server guys to help you with this one. If you
want to know more about the issues, try this video:

http://www.lynda.com/home/Player.aspx?lpk4=31001

and I have seen your videos ty

 

[Douglas J. Steele]

Depends on your definition of "query".

If you have the necessary permissions in SQL Server, you can run DDL (Data
Definition Language) as a pass-through query. Look up "Alter Table" in SQL
Server's BOL (Books On Line)

 

[John W. Vinson]

Depends on your definition of "query".

If you have the necessary permissions in SQL Server, you can run DDL (Data
Definition Language) as a pass-through query. Look up "Alter Table" in SQL
Server's BOL (Books On Line)

.... and be prepared to get into a big hairy argument with your SQL DBA.

 

[Richard]

Thanks for your reply, it sounds like a e-mail request to the IT department
to make the change for me is the simple soution.


Richard

 

[Philip Herlihy]

Richard wrote:
"I have a table on our sql server "dbo_tblWarehouse" that is linked to my
form. My question is I want to add a new field called comments and make
it a
memo field. Is it possible to do it through a query or do I need to
have the
IT guys open it in design view and add it from the server end?"

Philip,

I think you totally missed my point I built this over a year ago, it is
normalized and is in full production b/f with 10 users. I just wanted to
know if its "possibile" to use a query to add a field into a linked
table....... Probably yes or no would be the answer I am looking for. I am
leaning towards no...but you never know.




DUH!


this doesnt address the question either



and I have seen your videos ty


Richard

What an extraordinarily graceless response. You're posting a question
in a "getting started" newsgroup (of volunteers). Nothing about your
question suggests you you'd have a grasp of data definition language and
your mention of "the IT guys" corroborated the sense that you were
likely to be an absolute beginner. I pitched my response in what seemed
the most helpful way, while including pointers to more information if it
was of interest. There are many such questions posted, and no-one here
resents a naive question.

So you're not an absolute beginner. What are you then? You clearly
don't know enough about SQL Server to fix this up yourself, and you
don't know enough about a SQL Server installation in practice to know
that very few systems are so unguarded that they'd let end-users change
a table design. Nevertheless, you wouldn't expect the experts here to
treat your question with contempt ("DUH!") so why do you think it's
appropriate to respond this way to someone trying to help you because
they have misconstrued from your question your level of understanding?

Phil

 

[Richard]

Philip,

Your right I an not a compete beginner, sometimes I will post in general
questions so I will give you that. In any case I chose to post here. My
problem with your answers are..

1. You didn't read the question.
2. Use of techo jibberish.
3. Non Sequiturs
4. And this quote "it's called "normalization". Ouch!
5. The advertisements
http://www.lynda.com/home/Player.aspx?lpk4=31001
http://tinyurl.com/ms-table-design-tutorial

Sorry if it sounds like "extraordinarily graceless response"
other then that I like your response

Richard

 

[cem]

I have a table on our sql server "dbo_tblWarehouse" that is linked to my
form. My question is I want to add a new field called comments and make it
a
memo field. Is it possible to do it through a query or do I need to have
the
IT guys open it in design view and add it from the server end?

Thanks
Richardytytujtyjtjuhjhjkhukykkgykyukyu