Home » Developer & Programmer » Forms » Validation
Validation [message #226888] Mon, 26 March 2007 18:31 Go to next message
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 Go to previous messageGo to next message
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
Re: Validation [message #227078 is a reply to message #227071] Tue, 27 March 2007 05:00 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 20900
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.
Previous Topic: timer not work
Next Topic: window problem
Goto Forum:
  


Current Time: Thu Dec 08 04:08:06 CST 2016

Total time taken to generate the page: 0.06379 seconds