topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Fri, 18 May 2007 09:25:38 GMT

i have created two tables zstudent and zstudent1.i have the following fields in both tables.

1.sno(char).

2.sname(char).

3.joining date(date).

i have checked the initial checkbox for sname,joining date in zstudent .i tried to find diff between two tables.i didnt find.is their any diff between two tables if so what is the difference.plz explain me clearly.

Thanks in advance.

points will be rewarded.

Re: tables

Former Member — Fri, 18 May 2007 09:29:31 GMT

there is no diff btw 2 tables....

if initial check box is selected...it takes the initial values of those fields if no value is entered for them...depending on the data types...

hold the checkbox with cursor and press f1..u have more clear idea...

Message was edited by:

Premalatha G

Re: tables

Former Member — Fri, 18 May 2007 09:31:05 GMT

Has these 3 fields are key fields in both the tables

Checking that Checkbox INITIAL means,

when you declare a field as key field(first checkbox checked) then that field should be NOT NULL (so that's why we also check that INITIAL checkbox for those key fields).

Means All the key fields in any Table should be NOT NULL.

Now leave that checkbox blank (for a key field) and enter the values in to the table , and don't enter a value for sno field, it will give error.

Reward points if useful

Regards

Anji