Home » Developer & Programmer » Forms » Can I Do this
icon2.gif  Can I Do this [message #195667] Sat, 30 September 2006 14:31 Go to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
Can i pass parameter value to scroll up and down with cursor keys as we can
pass various parameters
thanx
Re: Can I Do this [message #197086 is a reply to message #195667] Mon, 09 October 2006 22:48 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Can I Do this [message #197226 is a reply to message #197086] Tue, 10 October 2006 10:38 Go to previous messageGo to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
No i hav'nt yet solve my problem do you know any procedure,


is anyone know how to create resource file where i can put that command to controll the scrolling by cursor keys, or anyone know how can we change resource file of report as we can change form resource file.
Re: Can I Do this [message #197319 is a reply to message #197226] Tue, 10 October 2006 23:54 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
To change the resource file you could use either 'd2kwutil' or 'web_util' (Forms 6i versus Forms 9i/10g) to permit the user to select a directory on the PC.
You say:

to controll the scrolling by cursor keys

Do you want to open the resource file and have the cursor resting at a certain line or something else? If something else, please elaborate.

David
icon2.gif  Re: Can I Do this [message #197508 is a reply to message #197319] Wed, 11 October 2006 09:09 Go to previous messageGo to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
hi david,
Yes I want to open the resource file and have the cursor resting at a certain line.
Re: Can I Do this [message #197623 is a reply to message #197508] Thu, 12 October 2006 01:41 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Either pass the number of the line as a parameter and after executing your query go to that line, or pass the wanted line's key value(s) as a parameter(s) and after executing the query, in a loop, test the current record's key value(s) against the passed value(s) and if not the wanted line then do a 'down' and repeat the testing on the next line. When you find the line you want, then exit the loop. This would be done in the When-New-Form-Instance trigger.

David
icon2.gif  Re: Can I Do this [message #197761 is a reply to message #197623] Thu, 12 October 2006 10:17 Go to previous messageGo to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
Sorry Dear David,
i didnt understand wat u have said plz tell me with some example. thanx alot
Re: Can I Do this [message #197841 is a reply to message #197761] Thu, 12 October 2006 20:14 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Either

pass the number of the line as a parameter and after executing your query go to that line
this means that if the records retrieved by 'form1' and 'form2' are same set and in the same order, if you are on line '5' in 'form1' then pass '5' to 'form2' and do the query and then use the 'down' command to go to line '5'.
or

pass the wanted line's key value(s) as a parameter(s) and after executing the query, in a loop, test the current record's key value(s) against the passed value(s) and if not the wanted line then do a 'down' and repeat the testing on the next line. When you find the line you want, then exit the loop.
this means that if the records retrieved by 'form1' are slightly different to those retrieved by 'form2' then pass the desired keyword as a parameter (eg 'dog') to 'form2', do the query in 'form2', then, starting at the first row test if that row's key field equals the passed parameter. If it is the same value, then exit the loop and go to the block. If it is a different value , then test for 'system.last_record' and do a 'down'.

David
icon2.gif  Re: Can I Do this [message #198561 is a reply to message #197841] Tue, 17 October 2006 12:10 Go to previous messageGo to next message
chmlaeeque
Messages: 59
Registered: September 2006
Member
thanx for replying and briefing David but sorry i didnt understand wat u r saying and wat r u telling to do if u dont mind then can u plz tell me the procedure and queries and where i should apply it
Re: Can I Do this [message #198607 is a reply to message #198561] Tue, 17 October 2006 23:27 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please print of this thread and have a friend or colleague work through it with you.

I have reread my last post and other than for the concept of a 'set', I don't feel that I can be any more explicit.

David
Previous Topic: can anyone tell me
Next Topic: Omniportlet
Goto Forum:
  


Current Time: Fri Sep 20 13:38:09 CDT 2024