IT SOLUTIONS
Your TECHNOLOGY partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox Group Home
-Collapse +Expand Message Board
-Collapse +Expand Paradox KB
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Study Test
PRESTWOODCERTIFIED
-Collapse +Expand Paradox Store
PRESTWOODSTORE
-Collapse +Expand Members Only

Prestwood eMagazine

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

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

Please help an amateur with paradox 5.0

Please help an amateur with paradox 5.0 in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: amateur   paradox   amateur   amateur paradox   5 0  

drnakah
I have been raking my brain with this. And I would like any help I can get. Thank You!

The best way I can explane this is by using an example...

I highlight the buiness "paper works"

Then I click on the button 'info'

A window pops up with the info on paper works.

Then I highlight the buisness "Computer Cont."

After I click on the button 'info' a window pops
up with the info in Computer cont.

Now that is what I want to have happen, but it is not.

When I click on the button, 'info' the window pops up but it always gives me the same company info. the first one in the list.

How do I do it so that when I click on the button, 'info' that the info about the buisness that is highlighted will popup in a seperate window?

Thank You! Banging Head On Wall
 Posted 7 years ago (Thread Starter)
Comment Quote
Location=Canada ,  Joined=7 years ago   MB Posts=2  
More... -Collapse +Expand
drnakah
 (Inactive)
Canada
Rank: Cadet 1st Year
Email Inactive E USA
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
Post ID #11427, 3 replies
Thread Started 3/4/2006 9:18:00 AM
View Counter=1446
Last Reply Posted 3/5/2006 11:43:00 PM)

Steve Caple
You need to do two things for us:

1) show us the table structure
(see example below)

2) show us the code on your pushButton

3) describe the form the button is on

I am guessing that the form has a tableFrame on it, and the table has a business name field, and that the information on the business is either in a memo field in this table or in another table linked by the key field of the main table.

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 7 years ago
Comment Quote
Location=Sacramento, CA ,  Joined=9 years ago   MB Posts=66   KB Posts=2  
More... -Collapse +Expand
Steve Caple
Prestwood IT Solutions
Sacramento, CA
Rank: Lieutenant-Commander
Email A E CA USA
Approved member.
Member subscribes to this thread with a verified email.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #11428 (Level 1.1)  Reply to 11427
Thread Started 3/4/2006 3:07:00 PM
View Counter=2
Most Recent Post

Steve Caple
The code needs to open the form; the example below first checks to see if it IS open already by trying to attach() to it; attach() requires the form title that you set in the Window Style dialog when you created the form.

Once the form is open, you have to locate the appropriate record. The example below assumes that the MRO on the info form is called CUSTINFO, and that its table is either keyed on CustID or has a secondary index on CustID that was set by a switchIndex() in the MRO open() event. The code then tries to locate the customer using the CustID value from the ORDERS form record on the calling form, and if that is successful it waits for the return from the form. This would usually be dome with a button labeled OK on the info form that does a formReturn(TRUE). When the formReturn happens, the code on the calling form button closes the form.

If the locate function is sloww, you can open the form hidden (add a WinStyleHidden argument to the f.open() and after the locate do f.bringToTop() before the f.wait().

If the info form is set (again, in the Window Style dialog) to be a modal dialog with no control menu, minimize or maximize on its title bar, nothing will go forward until it is returned from by pressing the OK button. With no control menu it can't be closed, so the f.close() on the calling form won't have problems.

  
var
f form
endvar

if not f.attach("CUSTOMER INFO") then
if not f.open("Cust2") then
msgStop("PROBLEM","Unable to open CUSTOMER INFO form.")
return
endif
endif

if not f.CUSTINFO.locate("CustID",ORDERS."CUstID") then
msgInfo("UNABLE TO LOCATE CUSTOMER",
"Attempt to locate Customer ID "+string(ORDERS."CUstID")+"\n" +
"was unsuccessful.")
f.close()
return
else
f.bringToTop()
f.wait()
f.close()
endif

Steve Caple
Programmer Analyst
Prestwood Software
http://www.prestwood.com

 Posted 7 years ago
Comment Quote
Location=Sacramento, CA ,  Joined=9 years ago   MB Posts=66   KB Posts=2  
More... -Collapse +Expand
Steve Caple
Prestwood IT Solutions
Sacramento, CA
Rank: Lieutenant-Commander
Email A E CA USA
Approved member.
Member subscribes to this thread with a verified email.
About Steve Caple

Steve Caple I first saw Paradox in 1985 when a guy named Rick Albers came to demo Ansa's new 1.1 release to the Sacramento PC Users Group. The feeling was like going from WordStar to WordPerfect 3.0, a sense of freedom and power.

A long time dBase user had an evaluation copy he let me use for a few weeks.  Going from dBase to Paradox was like finding yourself walking WITHOUT your shoe laces tied together.  I was hooked; within a week I wrote my first useful Paradox DOS program.  It took a few evenings to put together a script to  generate a Basic Bulk Mail sort,  using a series of Paradox queries against a bicycle club Century ride mailing list.  It then used PAL to send text to the printer, printing it out in 5 digit Zip, three digit Zip, and miscellaneous by state groups, including group header labels and spacers on one-across stock  -  just tear it apart at the headers and give it to the mailing volunteers, and a job that used to take 20 people 4 or 5 hours could be done by 5 or 6 in a single hour.  

Later, Paradox for Windows version 5 added many needed structural and indexing and linking features, and as hardware caught up with the needs of a GUI environment it became a powerful database for small companies and divisions or branches within large corporations.  Despite some years of no real changes it remains one of the best products for that purpose.


Post ID #11430 (Level 1.2)  Reply to 11427
Reply Posted 3/5/2006 11:43:00 PM

drnakah
Thank you for your responce. I will try to answer your questions...

1.) Yes it is in a tableFrame, and the buisness info. is in another form that is to pop up as I click the button. Sorry I don't know all the 'lingo' or talk but I'll explane the best I can.

2.) the buttun has the following stuff in it...

method pushButton(var eventInfo Event)
var
ordersTbl Table
newCustDlg Form
dlgVal String
endVar

newCustDlg.open("Cust2")

endmethod

3.)The button is right under the frame

Now I highlight, lets say the name 'John', click on the button "info" and up pops "Cust2" with the information on John.

Thank You for Your help.
 Posted 7 years ago (Thread Starter)
Comment Quote
Location=Canada ,  Joined=7 years ago   MB Posts=2  
More... -Collapse +Expand
drnakah
 (Inactive)
Canada
Rank: Cadet 1st Year
Email Inactive E USA
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.
Post ID #11429 (Level 1.3)  Reply to 11427
Reply Posted 3/5/2006 10:44:00 AM

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:

Enter your name and security key.

Your Name:
Today's security key = P187A
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #11427 Counter
1446
Since 4/2/2008
-
  Load Time=1 seconds.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


1,055 People Online Now!!  
Online Now: Sign In to see who's online now!  Not a member? Join now. It's free!
Show More...


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