IT SOLUTIONS
Your full service technology partner! 
-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     

QUERY FORM

QUERY FORM in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: QUERY FORM  
Greg MacKenzie
SEATTLE WA USA

Trying create push button form for query. coding below:

I get an error. Highlighting the line:

sStock = Enter_UNIT.value

Any assistance as to where my error is would be appreciated.

method pushButton(var eventInfo Event)
 var
  sStock  String
  qryFhistory Query
  tvAnswer  TableView
 endVar

 sStock = Enter_UNIT.value

 qryFhistory = Query

       ANSWER: :PRIV:ANSWER.DB

   FLEET.UTILIZATION.db | MODEL  | UNIT        | SERIAL NUMBER   |
          | Check  | ..~sStock.. | Check       |

 EndQuery

 executeQBE(qryFhistory)
 tvAnswer.open(":priv:answer.db")
endmethod

 Posted 59 months ago (Thread Starter)
Comment Quote
About Greg MacKenzie -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14775, 5 replies
Thread Started 1/25/2012 1:10:12 PM
View Counter=2229
Last Reply Posted 5/18/2012 4:51:03 PM)
Location=SEATTLE WA USA  
Joined=16 years ago   MB Posts=17  
Moderator
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

Give a clue as to what the error message was please.  I would expect that the Enter_Unit object is not visible to the code, but that is only a guess. 

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

 Posted 59 months 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 #14777 (Level 2) and Parent is 14775
Reply Posted 1/26/2012 2:54:31 PM
Location=Home office in Fresno, CA. 
Joined=14 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Greg MacKenzie
SEATTLE WA USA

Can you clarify what you mean by Enter_UNIT is not visible to the code? That may be the key to solving the issue.

 Posted 58 months ago (Thread Starter)
Comment Quote
About Greg MacKenzie -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14787 (Level 1.1)  Reply to 14777 and Parent is 14775
Thread Started 2/2/2012 8:23:51 AM
Location=SEATTLE WA USA  
Joined=16 years ago   MB Posts=17  
Greg MacKenzie
SEATTLE WA USA

When I try to run the form it opens in edit mode and the line below is highlighted

sStock = Enter_UNIT.value

Nothing other than that.

 Posted 59 months ago (Thread Starter)
Comment Quote
About Greg MacKenzie -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14778 (Level 3) and Parent is 14775
Reply Posted 1/26/2012 3:05:55 PM
Location=SEATTLE WA USA  
Joined=16 years ago   MB Posts=17  
Moderator
Daniel Fought
Prestwood IT
Home office in Fresno, CA.

In the status bar you should see an explaination of what compile error occured.  Probably something related to the object Enter_Unit not being visible since you are using the .value property I am assuming that this is an object on the form.  If the object is not within the visible containership tree you can't reference it directly.  Probably the object Enter_Unit is contained within a tableframe or other object not directly visible to the pushbutton.  You will probably will need to add to the containership path to address this field.  Look in the paradox help concerning containership and watch the status bar.

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

 Posted 58 months 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 #14788 (Level 4) and Parent is 14775
Reply Posted 2/2/2012 9:38:25 AM
Location=Home office in Fresno, CA. 
Joined=14 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
Most Recent Post
Greg MacKenzie
SEATTLE WA USA

I finally got back to working on this again. in the status bar the error is Unknown Identifier. Is this related to the containership? I looked at help and it indicates I need to enable the contain objects check box, however the check box is greyed out and not accessable.

 Posted 55 months ago (Thread Starter)
Comment Quote
About Greg MacKenzie -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14855 (Level 5) and Parent is 14775
Reply Posted 5/18/2012 4:44:47 PM
Location=SEATTLE WA USA  
Joined=16 years ago   MB Posts=17  

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 = P137A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14775 Counter
2229
Since 1/25/2012
-
   Share This Page!
 
Share on...

-
   Contact Us!
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


-
   Follow Us!
 
Connect With Us...
Facebook
Like our page!!!
Twitter
Follow us!
LinkedIn
Join Group
YouTube
View channel.
Go ahead!   Use Us! Call: 916-726-5675 


©1995-2016 Prestwood IT Solutions.   [Security & Privacy]