| Need help...really easy [message #120294] |
Wed, 18 May 2005 18:09  |
elMiMi
Messages: 5
Registered: May 2005
Location: QTR
|
Junior Member |
|
|
Hey, i'm totally clueless with the whole pl/sql stuff and i need to hand in an application by monday
my questions are really simple
if i have a form to enter information into multiple tables
for instance enter:
ID into table Student
SID into table supervisor
what should the code be?
and if i want to delete a row by the id number, what should the code be as well?
Thanx
ElMiMi
|
|
|
|
| Re: Need help...really easy [message #120295 is a reply to message #120294] |
Wed, 18 May 2005 18:26  |
danosw
Messages: 20
Registered: May 2005
Location: California
|
Junior Member |
|
|
Forms will do it all for you... These isn't any code (PL/SQL) to write.
It's all done in the block properties:
Query Allowed, Insert Allowed, Update Allowed, Delete Allowed...
So to delete, you first query by the User ID, then delete.
|
|
|
|
|
|
|
|
| Re: Need help...really easy [message #120435 is a reply to message #120294] |
Thu, 19 May 2005 13:55 |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
i think the solution is to build master/details form
which handel the relation between more than one table
when u want to delete master record it will delete detail record if the relation property "delete record behavior set to cascading"
best regards
hany
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
