------------------------------------------------------------------------------------
                      [ENHANCED] VFP 9.0 FIX - THE MAXIMUM NUMBER OF CHARACTERS PER COMMAND LINE
                                 January 2024
                 ------------------------------------------------------------------------------------
                                    CCB



1. BUG:

     In vfp9 (and vfp6, vfp7, vfp8), the maximum number of characters per command line is 8192,
     now the maximum number of characters per command line is 16384.


2. CAUSE:

     There are some BUGs in the following code.


3. RESOLUTION:

     We can write some code to fix the BUG.

     Fun406405 :: ; proc near
             push esi                                                        ;0x00406405 :        56
             mov esi , 0684Fh                                                ;0x00406406 :        be4f680000
             push esi                                                        ;0x0040640b :        56
             mov eax , 03000h                                                ;0x0040640c :        b800300000
             call Fun42bf2a                                                  ;0x00406411 :        e8145b0200
             mov dword ptr [ Data93a890 ] ,  eax                             ;0x00406416 :        a390a89300
             push esi                                                        ;0x0040641b :        56


     ;
     ;                 -------------------------------------------------------------------------
     ;                      VFP 9.0 FIX - THE MAXIMUM NUMBER OF CHARACTERS PER COMMAND LINE
     ;                                 October 2019
     ;                 -------------------------------------------------------------------------
     ;                                     CCB
     ;
     ; In vfp9, the maximum number of characters per command line is 8192,
     ; now the maximum number of characters per command line is 16384.
     ;
     ; 2019/10/21, by ccb
     ;

     ;         mov eax , 02001h                                                ;0x0040641c :        b801200000
             mov eax , 04001h                                                ;0x0040641c :        b801200000


             call Fun42bf2a                                                  ;0x00406421 :        e8045b0200
             mov  ecx , dword ptr [ Data93a890 ]                             ;0x00406426 :        8b0d90a89300
             test ecx , ecx                                                  ;0x0040642c :        85c9
             mov dword ptr [ Data93a894 ] ,  eax                             ;0x0040642e :        a394a89300
             pop esi                                                         ;0x00406433 :        5e
             je Label577f13                                                  ;0x00406434 :        0f84d91a1700
             test eax , eax                                                  ;0x0040643a :        85c0
             je Label577f13                                                  ;0x0040643c :        0f84d11a1700
             mov  ecx , dword ptr [ecx]                                      ;0x00406442 :        8b09
             mov  eax , dword ptr [eax]                                      ;0x00406444 :        8b00
             mov  dword ptr [ Data937f94 ] , ecx                             ;0x00406446 :        890d947f9300
             mov dword ptr [ Data93a81c ] ,  eax                             ;0x0040644c :        a31ca89300
             ret                                                             ;0x00406451 :        c3


4. APPLIES TO:

     VFP 6.0.8167.0
     VFP 6.0.8961.0 (SP5)

     VFP 7.0.0.9262
     VFP 7.0.0.9465 (SP1)

     VFP 8.0.0.2521
     VFP 8.0.0.3117 (SP1)

     VFP 9.0.0.2412
     VFP 9.0.0.3504 (SP1)
     VFP 9.0.0.4611 (SP2)
     VFP 9.0.0.5015 (SP2)
     VFP 9.0.0.5411 (SP2)
     VFP 9.0.0.5721 (SP2)
     VFP 9.0.0.5815 (SP2)
     VFP 9.0.0.6303 (SP2)
     VFP 9.0.0.6602 (SP2)
     VFP 9.0.0.7423 (SP2)

     The bug has been fixed in VFP Advanced.

     IMPORTANT NOTE:
     The following commands and functions have been fixed to support the maximum number of characters per command line is 16384:
     COMPILE command
     MACRO substitution
     STORE command
     EXECSCRIPT() function
     EVALUATE() function
     TYPE() function
     VARTYPE() function
     IIF() function
     ICASE() function
     SQLEXEC() function
     SQLPREPARE() function
     SELECT - SQL command
     UPDATE - SQL command
     DELETE - SQL command
     INSERT - SQL command
     CREATE VIEW - SQL command
     MODIFY VIEW - SQL command
     MODIFY QUERY - SQL command
     LOCATE command
     BROWSE command
     EDIT command
     REPLACE command
     DELETE command
     APPEND command
     CALCULATE command


5. REFERENCE WEBSITES:

     1, baiyujia.com:
     http://www.baiyujia.com
     http://www.baiyujia.com/vfpdocuments/f_vfp9fix96.asp
     http://www.baiyujia.com/vfpdocuments/f_vfp9fix199.asp
     http://www.baiyujia.com/vfpdocuments/f_vfp9fix200.asp

     2, foxite.com:
     https://www.foxite.com/archives/line-is-too-long-0000276506.htm
     https://www.foxite.com/archives/line-is-too-long-0000084952.htm
     https://www.foxite.com/archives/select-sql-statement-is-too-long-0000091699.htm

     3, microsoft.com:
     https://social.msdn.microsoft.com/Forums/en-US/9527d9c6-59b0-48e7-bb8f-147e65802eab/the-code-is-too-long-to-fit-vfp
     https://social.msdn.microsoft.com/Forums/en-US/b467c87b-8298-42eb-a909-46d72b5c391c/regarding-error-quotsql-statement-too-long

     4, tek-tips.com:
     https://www.tek-tips.com/viewthread.cfm?qid=1355032
     https://www.tek-tips.com/viewthread.cfm?qid=1245991

     5, computer-programming-forum.com:
     http://computer-programming-forum.com/2-vfp/adce0c902cafeb70.htm
     http://computer-programming-forum.com/2-vfp/113d95d6dcaebe63.htm

     6, github.io:
     https://jeffpar.github.io/kbarchive/kb/111/Q111991/


6. OTHER:

     For reference only, there is no guarantees.

     Any questions or suggestions, please send me an email at ccb2000@163.com.