Tantastic
Member
Registered: 23rd Jan 07
User status: Offline
|
im stuck on 1 aspect of an assignment and wondered if anyone could help.
im creating a table using oracles sql+. for 1 of the sections i have to include the users date of birth, but need to ensure that theyre over the age of 18.
what is the best method to go about doing this, would it be to add the validation in the sql when i create the table or to add it in when im using the forms builder.
|
Cybermonkey
Member
Registered: 22nd Sep 02
Location: Sydney, Australia
User status: Offline
|
personally i would use the greatest/least functions. this provides the biggest scope for customising tables like this
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
Depends if you actually want to store records for people who are not old enough or discard the record.
We still keep member records for declined memberships and banned people just for historical interest for example.
|
AndyKent
Member
Registered: 3rd Sep 05
User status: Offline
|
I think I'm correct in saying that you should check the data twice - once with Javascript for example and again before inserting the data. That why the data is at least checked once, but its easier to tell the user while they are filling the form in.
|
Tantastic
Member
Registered: 23rd Jan 07
User status: Offline
|
thanks for your helps guys ive managed to sort it out now :-)
another quick small favour though... I have my canvas open at the moment in forms builder. I am wanting to insert an image onto the canvas, does anyone know the correct way to do this?
thanks
|
AndyKent
Member
Registered: 3rd Sep 05
User status: Offline
|
canvas???
|
Tantastic
Member
Registered: 23rd Jan 07
User status: Offline
|
in oracle forms builder, i have a blank canvas (viewed using layout editor?) work area, design view whatever you wanna call it :-)
|
