Please can anyone help me with my problem.I am trying to edit details

directly from my database dictionary, how can this be done , please my jo

b

is on the line on this one.

"Database dictionary"? What's one of those? You job is no nearer safety 

while you phrase your questions so vaguely. Give us some code, to show what 

you're trying to do.



On 06/22/00, "henry adedayo" wrote:

> Please can anyone help me with my problem.I am trying to edit details

directly from my database dictionary, how can this be done , please my jo

b

is on the line on this one.

can U be more explicit in what you want to do and how, so that we can try to

help. 

YOur question is very vague...



Just relax and type the whole problem!!!!



-krish





> -----Original Message-----

> From:	henry adedayo 

> Sent:	Thursday, June 22, 2000 9:01 AM

> To:	ASP Databases

> Subject:	[asp_databases] AW: Re: insert " into a database Howto??

> 

> Please can anyone help me with my problem.I am trying to edit details

> directly from my database dictionary, how can this be done , please my job

> is on the line on this one.

> 

A data dictionary is a list of columns, datatypes, lengths and attributes (NOT

NULL, AUTOINCREMENT, etc).  Access uses the term "Design View" to provide a

graphical interface to the data dictionary.



Henry,



     What DB engine are you using?  What part of the data dictionary do you want

to change?



KD

Sorry it is long message.Hope it does not disturb

other guy



Hi henry:



I am not sure I can help you a lot. Data dictinary is

a document to describe Table and Field in the

database.



I can give you an expample. It is a project I have

done before.



***********************************

Abbreviations:

M = mandatory

O = optional

PK = primary key (or Unique key for entities), this is

entered as the first "unique key" for the entity

PK+ = this field is part of the primary key (or Unique

key for entities)

UK # = a secondary unique key that makes the data

unique (in addition to the PK)

Char N = Character datatype, for length of N

Varchar N = Varchar datatype, for length of N

Int = Integer datatype

Max Qty  = Entity's maximum records

Short = Entity's short name

Plural = entity's plural name (also becomes the table

name)

Description = The entities Description, this is

entered in the Description (or maybe notes) tab on the

entity

Note = The attribute's note or comment.  This

eventually becomes the column's description.



Customer Type 

Description: Customer classification code (Chain

Store, Franchise, Retailer, ...)

(Max Qty = 20,  short = CSTT, Plural = Customer Types)

 Code (Char 7, M, PK, note = "Short abbreviation for

customer classification type")

 Name (M, Char 30, UK2,  note = "Customer type name")



Customer Industry 

Description: Classification of the industry the

customer is in

(Max Qty = 50,  short = CIND, Plural = Customer

Industries)

 Code (Char 7, M, PK, note = "Short abbreviation for

customer industry")

 Name (M, Char 30, UK2,  note = "Customer industry

name")



Return Code

Description: Product return policy classification. 

(Full, Covers, Affidavit, Masthead, Non-Returnable)

(Max Qty = 10,  short = RETC, Plural = Return Codes)

 Code (Char 7, M, PK, note = "short abbreviation for

return code")

 Name (M, Char 30, UK2,  note = "return code full

name")



Market Code

Description: The customer authorizations/restrictions

on the item that indicates which customers or types of

customers an item can be sold to.  (e.g. Barnes &

Noble, Wholesale, Computer Stores, Bookstores, ...)

(Max Qty = 12, short = MKTC, Plural = Market Codes)

 Code (Char 7, M, PK, note = "Short abbreviation for

market code")

 Name (M, Char 30, UK2,  note = "Market code name")



Product Line

Description: The type of product (e.g. book, compact

disk, magazine, ...)

(Max Qty = 20,  short = PRDL,  Plural = Product Lines)

 Code (Char 7, M, PK, note = "short abbreviation for

product code")

 Name (M, Char 30, UK2, note = "product line name")



********************************



It is preety long . but is just pice of dictionary.



Hope it is useful for you. and not disturb other guy





--- henry adedayo wrote:

> Please can anyone help me with my problem.I am

> trying to edit details

> directly from my database dictionary, how can this

> be done , please my job

> is on the line on this one.

>