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

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

Keyphysical not working

Keyphysical not working in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Keyphysical   working   Keyphysical not   Keyphysical not working  
Most Recent Post
Shawn.R
FL USA
Rank: Ensign

PdoxRT10 - WinXP sp3 - Excel 2003 or 2010

Hello - I'm trying to block the use of the ctrl key to prevent the user from copying/pasting data into a field in Paradox.

The problem is when they copy/paste (from EXCEL) into the Pdox field, you do not "see" what was just pasted unless you click into the field and "arrow" to the left OR click on a different field on that form (then the text appears).

This is causing the user to paste into the field twice, then they can see the text. They move on with their working like normal, but the data posted into the table is not right. In the table, I see the orginal pasted data, then a couple of "squares" (returns characters or seomthing?) and then I see the data again, which should only be in the field one time, without any weird symbols in the mix.

To compound the problem, we have a routine that exports data from a table into Excel. When the data that I spoke of above is exported, it exports nothing, or "blank" data into Excel. Other fields on the same record export fine. The only data not exported in this process is the data that has been pasted twice, and with the funky square characters.

To correct this, I am trying to block access to the ctrl key on the form that is being used when the user copies/pastes, but I cannot seem to get it to work. Here is what I've tried on the form level/keyPhysical event:

 method keyPhysical(var eventInfo KeyEvent)

 if eventInfo.isPreFilter() then
  ;// This code executes for each object on the form
  switch
         case eventInfo.vCharCode() = VK_F1   : disableDefault
         case eventInfo.vCharCode() = VK_F9   : disableDefault
         case eventInfo.vCharCode() = VK_HOME    : disableDefault
         case eventInfo.vCharCode() = VK_END     : disableDefault
         case eventInfo.vCharCode() = VK_INSERT  : disableDefault
         case eventInfo.vCharCode() = VK_ESCAPE  : disableDefault
         case eventInfo.vCharCode() = VK_NEXT    : disableDefault
         case eventInfo.vCharCode() = VK_PRIOR   : disableDefault
         case eventInfo.vCharCode() = VK_PAUSE   : disableDefault
         case eventInfo.vCharCode() = VK_RBUTTON : disableDefault
         case eventInfo.vCharCode() = VK_CONTROL : disableDefault
    endswitch  
 else
  ;// This code executes only for the form
  
 endIf

endMethod

I've also tried this on the fields themselves, but I am STILL able to do CTRL V and paste data into the fields.

Thanks in advance!

-Shawn

 Posted 8 years ago (Thread Starter)
Comment Quote
About Shawn.R -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14426, No Replies Be the first!
Thread Started 1/10/2011 6:38:39 AM
View Counter=2107
Location=FL USA 
Joined=12 years ago   MB Posts=23  

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 = P1237A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14426 Counter
2107
Since 1/10/2011
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,308 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


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