I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

December Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Forms Topic   Print This     

Change Value

Change Value in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Change Value  
William.M2
Nampa, -- --

Hi All, I was able to finally figure out my last question but I really do need Help on the one small part of it to work like I need ti to.

Sympnosis:

All new equipment donated to us goes into the inventory.  And In Stock field here defaults to T for True.  On our order form, should really call it loan form but anyway, our order form you first select the customer information which you have previously entered into the customer db so it is a lookup table.  Then you go to the order delati table and scan the medical equip lets say a cane, and it comes up and fills in the info.  Here they are to change in the order delatl table InStock to False before they add the checkout date.  When they change this to False, I need it to go to the equip table and change the In Stock there to False as well.  Of Course, when it is brought back to us, and they return iut, the order detail will then be brought back in and they will change it to T for ture In stock and it will need to be changed again to true in the equip inventory table.

I believe this could happen using change value event but need help with the rest.

Please assist.

As I go through Mikes Book Paradox 9 power programming I am learning a lot but still know I am nowhere I should be in learning.

Thank you and Sincerely

William

-----------------------------------------------

http://www.josephstory.org Learn about one of the greatest life challenges of our newborns..

 Posted 6 years ago (Thread Starter)
Comment Quote
About William.M2 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Web Presence
Website, Follow our Son and learn about CHD (http://www.josephstory.org)
Website, http://joseph.heavenboundministry.com/joseph%20matthew%20journey%201/HTML/ (Joseph's CHD Story)
Website, Joseph's Facebook Page for CHD (https://www.facebook.com/JosephCHDStory?ref=hl)

Post ID #15062, 5 replies
Thread Started 9/7/2013 11:04:09 AM
View Counter=2158
Last Reply Posted 1/15/2014 8:42:32 PM)
Location=Nampa, -- -- 
Joined=6 years ago   MB Posts=6  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

I think you have the basic idea and the correct place to implement the solution.  Assuming that the Orderdetail table has the and Item key then in the changeValue event for the Instock field in the OrderDetail table you will need to open a tcursor to the inventory table locate the Item ID in that table and modify the instock field to true.

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 5 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #15091 (Level 2) and Parent is 15062
Reply Posted 1/15/2014 7:13:47 AM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
William.M2
Nampa, -- --

Dan, Thank you so much for your time.  I am hoping you could assist me--for some reason the theory behind it all and getting it done are 2 different things for me.  Just completely blocked at how to write the code for it.  I emailed last night mike with the small project all zipped up.  May I ask you to help me and then teach me where you made the change and how?  This will go a far far way for me and will master this idea with this single item at least for tcursor and actually writing code for the files.  Please.  Thank you so very much.  And since I am a total novice, if looking through ( the project) and you see I am making terrible errors please let me know.  Thanks again for your valuable time and Thank you Mike as well.

William

-----------------------------------------------

http://www.josephstory.org Learn about one of the greatest life challenges of our newborns..

 Posted 5 years ago (Thread Starter)
Comment Quote
About William.M2 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Web Presence
Website, Follow our Son and learn about CHD (http://www.josephstory.org)
Website, http://joseph.heavenboundministry.com/joseph%20matthew%20journey%201/HTML/ (Joseph's CHD Story)
Website, Joseph's Facebook Page for CHD (https://www.facebook.com/JosephCHDStory?ref=hl)

Post ID #15092 (Level 1.1)  Reply to 15091 and Parent is 15062
Thread Started 1/15/2014 9:38:32 AM
Location=Nampa, -- -- 
Joined=6 years ago   MB Posts=6  
William.M2
Nampa, -- --

Dan, Thank you so much for your time.  I am hoping you could assist me--for some reason the theory behind it all and getting it done are 2 different things for me.  Just completely blocked at how to write the code for it.  I emailed last night mike with the small project all zipped up.  May I ask you to help me and then teach me where you made the change and how?  This will go a far far way for me and will master this idea with this single item at least for tcursor and actually writing code for the files.  Please.  Thank you so very much.  And since I am a total novice, if looking through ( the project) and you see I am making terrible errors please let me know.  Thanks again for your valuable time and Thank you Mike as well.

William

-----------------------------------------------

http://www.josephstory.org Learn about one of the greatest life challenges of our newborns..

 Posted 5 years ago (Thread Starter)
Comment Quote
About William.M2 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Web Presence
Website, Follow our Son and learn about CHD (http://www.josephstory.org)
Website, http://joseph.heavenboundministry.com/joseph%20matthew%20journey%201/HTML/ (Joseph's CHD Story)
Website, Joseph's Facebook Page for CHD (https://www.facebook.com/JosephCHDStory?ref=hl)

Post ID #15093 (Level 1.2)  Reply to 15091 and Parent is 15062
Reply Posted 1/15/2014 9:38:32 AM
Location=Nampa, -- -- 
Joined=6 years ago   MB Posts=6  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

I have the zip file you sent to Mike.  Unfortunately, I haven't found the inventory table.  Also I don't see either an order or orderdetail table.  Probably you can straighten me out. 

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions
http://www.prestwood.com

 Posted 5 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #15094 (Level 3) and Parent is 15062
Reply Posted 1/15/2014 2:53:35 PM
Location=Home office in Fresno, CA. 
Joined=17 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Most Recent Post
William.M2
Nampa, -- --

Hello Dan,

So sorry I did not explain the table naming convention.  The equipment inventory table is simply called equipment.db.  Then we have rentals.db and the customer is customer.db.

Thank you once again and ever indebted to you for your help!  A true blessing thankyou!

William

-----------------------------------------------

http://www.josephstory.org Learn about one of the greatest life challenges of our newborns..

 Posted 5 years ago (Thread Starter)
Comment Quote
About William.M2 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Web Presence
Website, Follow our Son and learn about CHD (http://www.josephstory.org)
Website, http://joseph.heavenboundministry.com/joseph%20matthew%20journey%201/HTML/ (Joseph's CHD Story)
Website, Joseph's Facebook Page for CHD (https://www.facebook.com/JosephCHDStory?ref=hl)

Post ID #15095 (Level 1.1)  Reply to 15094 and Parent is 15062
Thread Started 1/15/2014 8:40:05 PM
Location=Nampa, -- -- 
Joined=6 years ago   MB Posts=6  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1162A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15062 Counter
2158
Since 9/7/2013

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech