OraFAQ Forum: Forms » Validation

Home » Developer & Programmer » Forms » Validation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Validation [message #226888]

Mon, 26 March 2007 18:31

sara666
Messages: 7
Registered: March 2007
Location: Wales

Junior Member

Hi

am i very new to this SQL and need alot of help (sorry if this is in the wrong section)

just wondering if anyone could tell me how in oracle form builder i can scroll through all the entites i have added in SQL. when i press the next button it does nothing - is this because i need to code it to do so?

if so please can you let me know and show me how it is done as i have no idea being very new to it all

also validating items on the form only allowing up to a certian number

Thanks

[Updated on: Mon, 26 March 2007 18:32]

Report message to a moderator

Re: Validation [message #227071 is a reply to message #226888]

Tue, 27 March 2007 04:36

bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore

Member

Hi

Do the following:
1) Put thr cursor on first record.
2) Write code on the button (WHEN-BUTTON-PRESSED)
NEXT_RECORD;
3) Click the button

It will proceed to next record one by one.

Bhupinder Singh

Report message to a moderator

Re: Validation [message #227078 is a reply to message #227071]

Tue, 27 March 2007 05:00

sara666
Messages: 7
Registered: March 2007
Location: Wales

Junior Member

Hi

thanks for the reply

i know i need to add a button but its the coding i dont have a clue about - is there any chance of an example to help me get started?

I think i may have got somewhere but it keeps telling me when i press a button that a record must be entered or deleted first even tho i have a table created in SQL - do you think there is an error with the table for it not to find the records?

[Updated on: Tue, 27 March 2007 05:05]

Report message to a moderator

Re: Validation [message #227265 is a reply to message #227078]

Tue, 27 March 2007 14:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you, perhaps, trying to scroll through empty lines? If so, you can't do that. But, if you execute a query and fetch several records into a block, you'll be able to go "down" until you reach the last record. Next line is a new record, and - before moving "down" again, you'll have to enter data into current one.

Report message to a moderator

Previous Topic:	timer not work
Next Topic:	window problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 13:48:22 CDT 2025