Normal Topic Table View Subform entries (Read 843 times)
flobo
Member
*
Offline



Posts: 16
Location: Germany
Joined: Feb 20th, 2014
Table View Subform entries
Apr 14th, 2014 at 12:16pm
Print Post Print Post  
Hello everyone,

I've found a quite strange behavior.

I have a subform in tableview in my database.
It's like the sample with the line-items.

My Problem is, when I fill in the records in my subform table view, the cursor jumps back to my no. 1 Record in the subform.

This is happening every time the records (in table view) come to the end of the subform height.

In the last element of my record, I added some Code to create a new record and then go over throwfocus to the first element in the new record.

It all looks ok, until the height of the subform is hit.

Code
Select All
var n as int

n = @SelectTreeItem("Add Data Menu!Navigation!Advance Record (F10)")

throwfocus(number)
 



Is there anything I can do about it ?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Table View Subform entries
Reply #1 - Apr 15th, 2014 at 1:25pm
Print Post Print Post  
Hello,

Is that code in a text box underneath the subform or is it the last column in your table view subform?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
flobo
Member
*
Offline



Posts: 16
Location: Germany
Joined: Feb 20th, 2014
Re: Table View Subform entries
Reply #2 - Apr 15th, 2014 at 5:46pm
Print Post Print Post  
Hi,

thanks for your reply.

The code is in the last Element in my subform.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Table View Subform entries
Reply #3 - Apr 16th, 2014 at 7:35pm
Print Post Print Post  
Hello,

I was able to replicate the issue that you are seeing on a sample file here and have passed it on to development for them to take a look at and fix.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1350
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Table View Subform entries
Reply #4 - Apr 17th, 2014 at 9:56pm
Print Post Print Post  
For now, you can add a simple workaround that will force it to stay on the correct row in the subform.

You just need to add one line of code, like so:

Code
Select All
var n as int

n = @SelectTreeItem("Add Data Menu!Navigation!Advance Record (F10)")

ResultSetCurrentPosition(@ResultSetTotal())

throwfocus(number) 

  


Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
IP Logged
 
flobo
Member
*
Offline



Posts: 16
Location: Germany
Joined: Feb 20th, 2014
Re: Table View Subform entries
Reply #5 - Apr 23rd, 2014 at 7:11am
Print Post Print Post  
Hi,

thank you.
It works great  Smiley
  
Back to top
 
IP Logged