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

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

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

Setting Upper Case in a search field

Setting Upper Case in a search field in Paradox Forms topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Setting   Setting Upper   Setting Upper Case   search field  
PS_3060
Altro Transformers
-- USA

I have a search firld on a form which works fine except I need to change all characters to upper case.

This is the code. It used to work but something has changed.

var
pn string
endvar

doDefault

pn = self.value
pn = pn.upper()

PTMPTNO.setRange( pn, pn+"z" )

Cheers

 Posted 55 days ago (Thread Starter)
Comment Quote
About PS_3060 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18190, 10 replies
Thread Started 10/4/2020 10:46:10 PM
View Counter=65
Last Reply Posted 10/9/2020 6:42:28 AM)
Location=-- USA 
Joined=72 days ago   MB Posts=12  
Moderator
Steven.G
Myrtle Beach, SC USA

looks like a small z, otherwise not clear on what your question is

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 54 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #18192 (Level 2) and Parent is 18190
Reply Posted 10/5/2020 7:54:21 AM
Location=Myrtle Beach, SC USA 
Joined=50 months ago   MB Posts=412  
PS_3060
Altro Transformers
-- USA

The field is used to find a part number on a tableframe as a string and to catch the key strokes entered and convert to uppercase. 

This worked before and I'm lost to why it does not now.

 Posted 54 days ago (Thread Starter)
Comment Quote
About PS_3060 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18193 (Level 3) and Parent is 18190
Reply Posted 10/5/2020 2:56:34 PM
Location=-- USA 
Joined=72 days ago   MB Posts=12  
Moderator
Steven.G
Myrtle Beach, SC USA

is there an error? no results? wrong results?

what event calls this?

pn.view() to see the results

and setrange(pn,pn) is the same as "pn..", even tho the help files don't say that

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 53 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #18194 (Level 4) and Parent is 18190
Reply Posted 10/6/2020 7:29:14 AM
Location=Myrtle Beach, SC USA 
Joined=50 months ago   MB Posts=412  
PS_3060
Altro Transformers
-- USA

Hi Steven

This is on the KeyPhysical event on the field

method keyPhysical(var eventInfo KeyEvent)
var
pn string
endvar

doDefault

pn = self.value
pn = pn.upper()

PTMPTNO.setRange( pn, pn+"z" )

endmethod

What I'm trying to achieve is as the field is populatedall lowercase characters are converted to uppercase.

 Posted 52 days ago (Thread Starter)
Comment Quote
About PS_3060 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18195 (Level 5) and Parent is 18190
Reply Posted 10/7/2020 6:33:15 PM
Location=-- USA 
Joined=72 days ago   MB Posts=12  
PS_3060
Altro Transformers
-- USA

Hi Steven

This is on the KeyPhysical event on the field

method keyPhysical(var eventInfo KeyEvent)
var
pn string
endvar

doDefault

pn = self.value
pn = pn.upper()

PTMPTNO.setRange( pn, pn+"z" )

endmethod

What I‘m trying to achieve is, as the field is populated all lowercase characters are converted to uppercase.

 Posted 52 days ago (Thread Starter)
Comment Quote
About PS_3060 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18196 (Level 6) and Parent is 18190
Reply Posted 10/7/2020 6:33:15 PM
Location=-- USA 
Joined=72 days ago   MB Posts=12  
Moderator
Steven.G
Myrtle Beach, SC USA

why not just do the "all caps" picture on the field, and be done with it? no code

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 51 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #18197 (Level 7) and Parent is 18190
Reply Posted 10/8/2020 6:18:43 AM
Location=Myrtle Beach, SC USA 
Joined=50 months ago   MB Posts=412  
PS_3060
Altro Transformers
-- USA

Hi Steven,

The field is not attached to a table but is used to filter a table frame. That is why I was trying to set all characters in uppercase as it is then used for another search with another button.

 Posted 51 days ago (Thread Starter)
Comment Quote
About PS_3060 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18198 (Level 8) and Parent is 18190
Reply Posted 10/8/2020 10:13:57 PM
Location=-- USA 
Joined=72 days ago   MB Posts=12  
PS_3060
Altro Transformers
-- USA

Hi Steven,

The field is not attached to a table but is used to filter a table frame. That is why I was trying to set all characters in uppercase as it is then used for another search with another button.

 Posted 51 days ago (Thread Starter)
Comment Quote
About PS_3060 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18199 (Level 9) and Parent is 18190
Reply Posted 10/8/2020 10:13:57 PM
Location=-- USA 
Joined=72 days ago   MB Posts=12  
PS_3060
Altro Transformers
-- USA

Hi Steven,

The field is not attached to a table but is used to filter a table frame. That is why I was trying to set all characters in uppercase as it is then used for another search with another button.

 Posted 51 days ago (Thread Starter)
Comment Quote
About PS_3060 -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 #18200 (Level 10) and Parent is 18190
Reply Posted 10/8/2020 10:13:57 PM
Location=-- USA 
Joined=72 days ago   MB Posts=12  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

ok, an undefined field.. first, that little bit of code should work.. but second, you can still use real fields from dummy tables, in situations liek this, if pictures, lookup tables, etc. can help

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 50 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #18201 (Level 11) and Parent is 18190
Reply Posted 10/9/2020 6:29:20 AM
Location=Myrtle Beach, SC USA 
Joined=50 months ago   MB Posts=412  
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 = P1287A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #18190 Counter
65
Since 10/4/2020

Follow PrestwoodBoards on: 


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