dear expert

i am using MS SQL2000 as my database, i design my database and its particular tables by using the SQL Enterprise manager.
then i set up each attirbute by declaring its data type, not null.....

ok, now the problem is i do this database design in advanced ways before the real coding step into. so, if i already establish
their relationship and constraints, what should i do in the coding side? is it need to do it in promgrammatic way to specify
the PK and FK constraint (refrential integrity) one by one or everything is being settle by establishing their relationship on
the database diagram?

futhermore, there's something call SQL script, what's the main deffirent between triggers, stored procedure when in what kind
of situation should calling the apporpriate events between SQL scrip[t, triggers and stored proceudre?

Hey,

You can reestablish the constraint by creating a DataRelation. You can find this in the MSDN and on the web.

Triggers execute when data is inserted, updated, and deleted only. They can do whatever you want, but only on these events. Stored procedures you have to call (in your code). You can't call triggers in your code; they are only available on the database side.

Brian

well, i just review it at MSDN and gain some understanding on DB structure.

I would like to use Treeview (namespace microsoft.web.UI.webcontrols)
as my interface. let say there are treenode A,B and C. If i check on treenode A, then this will perform an action on the related table
resides on the MSSQL 2000 (let say the table name is Alpha, and its field's (Treenode A,B,C)attribute is boolean type (check for true;uncheck for false, default is set to false).

i know it is something dealing with DML side. how do i doing this by using "Update...Set..." this query statemnt? how to define thier relation......and what should i do if i checked on particular check box for the treenode??

for this treeview is actually using by the admin site for granting the privilege to the user purpose.

thank you for reply on previous question.

Hey,

You can create a relationship sure, for update statement, say you got t1, t2, t3, t3 contains a fk to t2, t2 contains a fk to t1.

Use three updates to update t1, t2, then t3. Depending on what you want triggers for, you may be able to do that too.

What do you want to do with the treeview, to then update the field? Most likely, if you are at the second-node level (data in t2), whatever changes you make don't typically involve the primary key, and won't be affected by t1 or t3. If there is a PK change, then you could use cascading which automatically changes the values in the FK tables.

Not sure what you mean about the checkbox thing?

Brian

Brian

dear brian

one very important thing to ask, there's no boolean datatpye in MS sql server 2000. what should i do with if i checked on the checkbox, it will change the column value from false ino true.

any web page or KB regrading this topic? should be something related with forrm+treeview+class checkboxex

thank you

For some reason they changed bool to bit...

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

yeah...but how to set the column data type with bit? what's the default value for it?

Uh.. Bit is always either 1 or 0.. I believe you can use true/false also.

Hal Levy
I am here to help you, not do it for you.

so, set the default value=0 as false, after check it the value will be +1; then become true...

but this condition where should i put, is it stored procedure, triggers or inside the query builder pane?

sorry- I don't understand the question.

Hal Levy
I am here to help you, not do it for you.