Sendkeys() and extended characters

Sendkeys() and extended characters

Post by Joseph He » Tue, 24 Feb 1998 04:00:00



I'm entering foreign-language data and would like to use ALT keys to enter
extended characters; for example, ALT-A to enter an "A" with a grave accent.
I'm trapping for the ALT keys with vchar(), but I can't get SendKeys() to
send extended characters.  Ordinary ASCII works fine, and I can manually
type extended characters into the field.  Any ideas?

Joe Herl
--

School of Music                              I am not called to be successful;
University of Illinois                          I am called to be faithful.
Urbana, Illinois 61801 USA                                    -- Mother Teresa

 
 
 

Sendkeys() and extended characters

Post by Joseph He » Thu, 26 Feb 1998 04:00:00



>I'm entering foreign-language data and would like to use ALT keys to enter
>extended characters; for example, ALT-A to enter an "A" with a grave accent.
>I'm trapping for the ALT keys with vchar(), but I can't get SendKeys() to
>send extended characters.  Ordinary ASCII works fine, and I can manually
>type extended characters into the field.  Any ideas?

Okay, I've figured this one out and I thought I'd let anyone else who is
interested know how.  Stephen Knott put me on the right track with an idea
he had, and I've developed it from there.  What I do is put all the ALT
keypresses into the first field of a table and all the extended characters
into the second field (called "Extended character").  Then if the user
enters a character with the ALT key down, a TCursor searches for the key
pressed and copies the extended character in the second field onto the
clipboard, and then the character is pasted into the active field.  This
avoids using sendKeys() altogether and further allows the user to alter
the ALT-key list by editing the table.  Here is the code, placed in the
keyChar() method of the form:

method keyChar(var eventInfo KeyEvent)
   var
      sKeyChar string
      tcExtChar tcursor
   endVar

   if eventInfo.isPreFilter() then
   ;// This code executes for each object on the form
      if eventInfo.isAltKeyDown() then
         disableDefault
         sKeyChar = lower(eventInfo.vChar()) ; char() doesn't work if ALT key is down
         if eventInfo.isShiftKeyDown() then ; if SHIFT key is down, make character upper case
            sKeyChar = upper(sKeyChar)
         endIf
         if tcExtChars.qLocate(sKeyChar) then
            sKeyChar = tcExtChars."Extended character"
            sKeyChar.writeToClipboard()
            active.action(EditPaste)
         endIf
      endIf
   else
   ;// This code executes only for the form
   endIf
endMethod
--

School of Music                              I am not called to be successful;
University of Illinois                          I am called to be faithful.
Urbana, Illinois 61801 USA                                    -- Mother Teresa

 
 
 

1. how pass french characters or extended characters to a stored procedure by odbc

how pass french characters or extended characters to a stored procedure by
odbc

error: ORA-01756: quoted string not properly terminated

une chaine entre apostrophhes ne se termine pas correctement

oracle Retrieving extended characters thru ODBC

PL/SQL procedure parameters

hi, i hope you can help to me.

I have a problem with french and german characters.
i have a little stored procedure than return what i'm passing to him.

see these example: (the second one work fine on plsql)

first exemple:

1) i created a new odbc dsn
2) i'm going into sqlserver migration tab to choose
    Enable Exac Syntax.

3) i'm open Winsql (this is a odbc tools)
                      http://www.indus-soft.com/winsql/
4) i'm write
exec ksp_test 0,'HLLO ORACLE'

i receive this error:

Error: ORA-01756: quoted string not properly terminated
  (State:S1000, Native Code: 6DC)

---------
I trying to changed too the NLS_LANG in the registry
like FRENCH_CANADA.WE8ISO8859P1
     French_France.WE8ISO8859P1

but without any success..
--------
i got the same problem with
oracle 9 database with utf8 characters set.
oracle 8.1.7 with iso8859p1 characters set.

i trying all latest odbc driver from oracle website.

second exemple:

SQL> variable mytest refcursor;
SQL> exec ksp_test (0,'HLLO ORACLE',:MYTEST);

PL/SQL procedure successfully completed.
SQL> PRINT MYTEST;

Your Database Value
--------------------------------
HLLO ORACLE

CREATE OR REPLACE  PACKAGE KSP_PLSQLRSETPKG
      AS
TYPE RCT1 IS REF CURSOR;
END;
;

CREATE OR REPLACE  PROCEDURE KSP_TEST  (
 PATCH INT DEFAULT 0,
 PONC VARCHAR2,
RC1 IN OUT KSP_PLSQLRSETPkg.RCT1
)

AS
BEGIN
OPEN RC1 FOR
SELECT PONC "Your Database Value" FROM DUAL;
FROM DUAL;
RETURN ;
END;

2. backup problem

3. Problem with ADOMD from C#

4. Extended ASCII Characters

5. "at a glance" book

6. extended stored procedures returning more that 255 characters?

7. data type space usage

8. Truncated 255-Character Extended Stored Procedure

9. BCP IN with Extended Characters

10. Problems with extended characters and the Bulk Copy library functions

11. Storing Extended Characters in SQL Database

12. BCP IN with Extended Characters