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

November 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

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 34 months ago (Thread Starter)
Comment Quote
Location=SEATTLE WA USA ,  Joined=14 years ago   MB Posts=17  
More... -Collapse +Expand
Greg MacKenzie
SEATTLE WA USA
Rank: Cadet 2nd Year
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=1736
Last Reply Posted 5/18/2012 4:51:03 PM)

Daniel Fought

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 34 months ago
Comment Quote
Location=Home office in Fresno, CA.,  Joined=12 years ago   MB Posts=401   KB Posts=11  
More... -Collapse +Expand
Moderator
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
Rank: Captain
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

Greg MacKenzie

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 33 months ago (Thread Starter)
Comment Quote
Location=SEATTLE WA USA ,  Joined=14 years ago   MB Posts=17  
More... -Collapse +Expand
Greg MacKenzie
SEATTLE WA USA
Rank: Cadet 2nd Year
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

Greg MacKenzie

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 34 months ago (Thread Starter)
Comment Quote
Location=SEATTLE WA USA ,  Joined=14 years ago   MB Posts=17  
More... -Collapse +Expand
Greg MacKenzie
SEATTLE WA USA
Rank: Cadet 2nd Year
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

Daniel Fought

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 33 months ago
Comment Quote
Location=Home office in Fresno, CA.,  Joined=12 years ago   MB Posts=401   KB Posts=11  
More... -Collapse +Expand
Moderator
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
Rank: Captain
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
Most Recent Post

Greg MacKenzie

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 30 months ago (Thread Starter)
Comment Quote
Location=SEATTLE WA USA ,  Joined=14 years ago   MB Posts=17  
More... -Collapse +Expand
Greg MacKenzie
SEATTLE WA USA
Rank: Cadet 2nd Year
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

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


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


©1995-2014 Prestwood IT Solutions.   [Security & Privacy]   Made in the U.S.A..   No H1-B.   No offshoring.