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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardQBE & SQL Topic   Print This     

Use a variable in QBE as a resulting value

Use a variable in QBE as a resulting value in QBE & SQL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: variable   resulting   Use variable   Use variable QBE   resulting value  
GaryG
Arrow Box Company
-- USA

Is it possible to use a variable as a resulting value? Or is it only possible to use a variable as filter. 

I would like the value in a variable to be put in the resulting column "DATETIMECHANGED".

Thanks in advance,

Gary

var
todaysdatetime DateTime
custnbr String
qq Query
endVar

custnbr = "1234"
todaysdatetime = dateTime()

qq = Query

ANSWER: :PRIV:CHNGED.DB

OPTIONS: NO AUXILIARY TABLES
:DATA:Items.db | FILENO | CUSTNO |
| Check _join1 | ~custnbr |

:DATA:PRICING.db | FILENO | QUANTITY | PRICE | DATECHANGED | REASON | INITIALS | PREVIOUSPRICE | PERCENTCHANGE | PRINTSELECT | LASTREFNO | SETUP |
| _join1 | Check | Check | Check calc ~todaysdatetime AS "DATETIMECHANGED" | Check | Check | Check | Check | Check | Check | Check |
EndQuery

if NOT qq.executeQBE() then
errorShow()
else
endIf

 Posted 4 months ago (Thread Starter)
Comment Quote
About GaryG -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
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 #17658, 4 reply
Thread Started 9/19/2019 1:45:52 PM
View Counter=98
Last Reply Posted 9/20/2019 8:25:56 AM)
Location=-- USA 
Joined=17 months ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA

genenric answer, yes.. but specific answer, in this example, no.. because the field type isn't the same.. you can "calc something as" to the same field type only

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 4 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #17659 (Level 2) and Parent is 17658
Reply Posted 9/19/2019 4:03:48 PM
Location=Myrtle Beach, SC USA 
Joined=40 months ago   MB Posts=338  
GaryG
Arrow Box Company
-- USA

Thanks

 Posted 4 months ago (Thread Starter)
Comment Quote
About GaryG -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
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 #17661 (Level 1.1)  Reply to 17659 and Parent is 17658
Thread Started 9/20/2019 8:24:35 AM
Location=-- USA 
Joined=17 months ago   MB Posts=6  
GaryG
Arrow Box Company
-- USA

Thanks

 Posted 4 months ago (Thread Starter)
Comment Quote
About GaryG -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
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 #17662 (Level 1.2)  Reply to 17659 and Parent is 17658
Reply Posted 9/20/2019 8:24:35 AM
Location=-- USA 
Joined=17 months ago   MB Posts=6  
Most Recent Post
GaryG
Arrow Box Company
-- USA

Thanks

 Posted 4 months ago (Thread Starter)
Comment Quote
About GaryG -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
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 #17663 (Level 1.3)  Reply to 17659 and Parent is 17658
Reply Posted 9/20/2019 8:24:35 AM
Location=-- USA 
Joined=17 months 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 = P1261A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #17658 Counter
98
Since 9/19/2019

Follow PrestwoodBoards on: 


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