Normal Topic how do i change information for a field (Read 3972 times)
laurie
Member
*
Offline



Posts: 27
Joined: Feb 18th, 2011
how do i change information for a field
Oct 11th, 2014 at 6:40pm
Print Post Print Post  
not sure what I need to do as its been couple of years since I set up database.  I own vending business and used q&a for many years and it was easy to do this on that.

what I need to do is change the retail amount from .85 to $1.00 so that it figures out the correct profit and shortage when I input data into database.  I know I need to do it in the designer but can't remember where or how.  we just changed our pricing and I need to update this.

in q&a I had it set that when I entered a field such as used it would calculate the retail and wholesale cost then when I entered how much paid it would calculate the over/short field.  I looked in program layout but don't see the old information there to input the new information.
On-Form-Change programming for the form and all elements this is what i am referring to.

I am using versoin 2.5.3.

thank you
« Last Edit: Oct 11th, 2014 at 8:40pm by laurie »  
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: how do i change information for a field
Reply #1 - Oct 13th, 2014 at 1:12pm
Print Post Print Post  
Hello Laurie,

Depending on your programming you may have to change it in several places. What I would recommend doing is in the design of your form, double click Program Layout. Click the Search menu bar at the top and then pick Find off the menu. Enter .85 in the search string field and then click Global Find. Close the search dialog, update that entry(If it pertains to costing and not something else) to 1.00 and then repeat the search. Once you are done, close the program editor, save the layout design, close the layout design, and reconcile your database file.

-Ray
  

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



Posts: 27
Joined: Feb 18th, 2011
Re: how do i change information for a field
Reply #2 - Oct 17th, 2014 at 7:35pm
Print Post Print Post  
Thank you so much Ray.  I was able to find where I needed to change the amount to.  I was going crazy as I had done this before but 3 years ago, and I couldn't remember how to find the information to change it. 

It could also be that the versions changed and it might have changed the way to do it from the way I did the change 3 years ago.
  
Back to top
 
IP Logged
 
laurie
Member
*
Offline



Posts: 27
Joined: Feb 18th, 2011
Re: how do i change information for a field
Reply #3 - Jun 7th, 2022 at 9:27pm
Print Post Print Post  
ok need to change the field again.  do i do it in the designer or the the database?  i tried in designer saved and it does not save in database i tried in database but it does not save either help please
  
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: how do i change information for a field
Reply #4 - Jun 8th, 2022 at 1:07pm
Print Post Print Post  
After making the change in Sesame Designer, you will need to Reconcile the changes back to the DB file.

-Ray
  

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



Posts: 27
Joined: Feb 18th, 2011
Re: how do i change information for a field
Reply #5 - Jun 9th, 2022 at 5:02pm
Print Post Print Post  
thank you that is what i couldnt find i found it under application on the main screen

  
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: how do i change information for a field
Reply #6 - Jun 9th, 2022 at 5:16pm
Print Post Print Post  
Hello,

The steps at https://lantica.com/support/kb/article/207-Reconciling-a-Report include the basic steps for reconciling design changes to the live application.

-Ray
  

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



Posts: 27
Joined: Feb 18th, 2011
Re: how do i change information for a field
Reply #7 - Jun 9th, 2022 at 5:19pm
Print Post Print Post  
thank you very much
]
  
Back to top
 
IP Logged