Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) xpost question (Read 3742 times)
FlipGilbert
Full Member
***
Offline


Running Ver 2.6.4

Posts: 236
Location: Sandy Eggo
Joined: Mar 8th, 2005
Re: xpost question
Reply #15 - May 28th, 2013 at 7:17pm
Print Post Print Post  
Okay, the "field name" it talks about in the book is the "Bound To" name in the Property Viewer. I understand now.
@XResultSetTotal() is 1 now that it has the proper field name, and is in and all the XResultSetValue 's are functioning properly.
My @XResultSetLocked() on the other hand is returning 0 even though its open when executed.

And Ray, I can not thank you enough for walking me through this. Thank you!
  

It's not what a man says that matters or how he says it, but what he does and how he does it.
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: xpost question
Reply #16 - May 28th, 2013 at 7:52pm
Print Post Print Post  
FlipGilbert wrote on May 28th, 2013 at 7:17pm:
My @XResultSetLocked() on the other hand is returning 0 even though its open when executed.


Are the records open by the same client or by a different client?

FlipGilbert wrote on May 28th, 2013 at 7:17pm:
And Ray, I can not thank you enough for walking me through this. Thank you!


You are welcome  Smiley

-Ray
  

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


Running Ver 2.6.4

Posts: 236
Location: Sandy Eggo
Joined: Mar 8th, 2005
Re: xpost question
Reply #17 - May 28th, 2013 at 8:07pm
Print Post Print Post  
....!?  from the same client.
  

It's not what a man says that matters or how he says it, but what he does and how he does it.
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: xpost question
Reply #18 - May 29th, 2013 at 3:35pm
Print Post Print Post  
That is why they are not showing as locked. Records will only be locked if they are open on a different client than the one trying to access them.

-Ray
  

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


Running Ver 2.6.4

Posts: 236
Location: Sandy Eggo
Joined: Mar 8th, 2005
Re: xpost question
Reply #19 - May 29th, 2013 at 4:35pm
Print Post Print Post  
Aaaaaaw. Now ya know what the next question is going to be.....
Is there an argument if the form is open by the same client?



Very happy at the moment! Thinking I have a grasp on the obvious
  

It's not what a man says that matters or how he says it, but what he does and how he does it.
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: xpost question
Reply #20 - May 30th, 2013 at 2:51pm
Print Post Print Post  
Hello Flip,

No there is not but you can check to see if that form is open before running this routine and prompt the user to close that form. FormResultSetTotal() will return -1 if the form is not open. So you'd need something like:

Code
Select All
If @FormResultSetTotal("Inventory:(Update)") = -1 Then
{
	//Do stuff
}
Else
{
	@MsgBox("Inventory Form is open in Update Mode. Please close and try again", "", "")
} 



-Ray
  

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


Running Ver 2.6.4

Posts: 236
Location: Sandy Eggo
Joined: Mar 8th, 2005
Re: xpost question
Reply #21 - May 30th, 2013 at 6:59pm
Print Post Print Post  
All Hail Master Ray!!!!

Thank you for all your help, now I'm going to go all "Viking" and reek havoc on a database!
  

It's not what a man says that matters or how he says it, but what he does and how he does it.
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: xpost question
Reply #22 - May 30th, 2013 at 7:12pm
Print Post Print Post  
FlipGilbert wrote on May 30th, 2013 at 6:59pm:
All Hail Master Ray!!!!


Grin

Quote:
Thank you for all your help, now I'm going to go all "Viking" and reek havoc on a database!


While we at Lantica Support do not recommend Data entry with an axe and are not liable for any damage that may be caused to your keyboard, monitor, mouse, desk, wall, tower, hands or co-workers, I would love to see a video of that.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print