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

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 07:06:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.