Normal Topic Retrieve Spec Programming (Read 690 times)
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Retrieve Spec Programming
Feb 4th, 2004 at 10:22pm
Print Post Print Post  
Quote:
The following are valid in Sesame:
Rating: ={Key - 14}
Any Field: {Rating = Key - 14}


The way it is now in Sesame,  Rating: ={Key - 14} will work but the the other way, i.e.  Any Field: {Rating = Key - 14},  it would not.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Retrieve Spec Programming
Reply #1 - Feb 4th, 2004 at 10:46pm
Print Post Print Post  
I just tried:

{Key = @toNumber(zip) - 76507}

in the Add2 field of Customers.db and got back the record where key is 937 and zip is 77444 (77444 - 937 = 76507). Is there a field type issue with Rating or Key in your .db?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Retrieve Spec Programming
Reply #2 - Feb 4th, 2004 at 10:54pm
Print Post Print Post  
I believe, it is problem at my end. Please forgive me.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Retrieve Spec Programming
Reply #3 - Feb 4th, 2004 at 11:14pm
Print Post Print Post  
Bharat,

Given how helpful you have been to the other users on this forum, I spend a lot more time needing to thank you, than needing to forgive you.

Thank you.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Retrieve Spec Programming
Reply #4 - Feb 5th, 2004 at 1:03pm
Print Post Print Post  
Thanks.  It is my experience that when one tries to help someone, he himself ( or she herself) benefits a lot more than the person he or she is is trying to help. In the process of responding, the concepts get clear. Sometimes you have to refer to reference materials that further reinforces the understanding and enhances the learning. Before posting, you test the code or procedure first that in turn help your own learning curve.

However, sometimes I fear that out of my limited understanding and lack of solid experience, I might end up misguide and confuse someone,  but then lanticans and other learned members are always there in the background to correct me and guide me.  Thanks for providing us with such a great forum for our learning and communication.
  
Back to top
 
IP Logged