View Single Post
  #21  
Old October 4th, 2008, 05:24 PM posted to microsoft.public.access
PACALA_BA[_2_]
external usenet poster
 
Posts: 85
Default COMPILER WRONG !!!

Hi, WHAT is not clear, i am ready to EXPLAIN it.....
--------
cSQL = cSQL & ",I0." & gkII_cKRA_SKR..this CODE-LINE is in MODULE
--------
cSQL = cSQL & ",I0.".....when running CODE, the compiler DO-NOT see
the value of public constant gkII_cKRA_SKR = "LAB"...!!!!! WHY ????
-------------------------------------------------------------------------------
BIG-PROBLEM is this wrong-compiler-example
http://i34.tinypic.com/71sdq8.jpg ;

Here is the String cSQL not correctly created !!!!
The Compiler DO NOT SEE the value of gkII_cKRA_SKR !!!!!!!!!

public const gkII_cKRA_SKR = "LAB"
' cSQL = "SOME-STRING" ....the actual vlue
If (LN_FLD_SEL_CNT 255) Then
cSQL = cSQL & ",I0." & gkII_cKRA_SKR ' --- SEE NOTICE DOWN
LN_FLD_SEL_CNT = LN_FLD_SEL_CNT + 1
endif
NOTICE:
In the watches window, the line with RED arrows
cSQL = "SOME-STRING,I0." ..the WRONG-current value of cSQL
- WITHOUT public const gkII_cKRA_SKR ("LAB") ,WHY ?????
Question:
In the watches window, the line with GREEN arrows
cSQL = cSQL & ",I0." & gkII_cKRA_SKR ..the current value of CODE-LINE is
"SOME-STRING,I0.,I0.LAB"...
Here is added "LAB", that is OK...!!!!!!!!!!, but only in WATCH-WINDOW

Resume:
Why is there DIFFERENCE between Compiler and DEBUG ???
*******************************************
than the string is used for an connection
Connection.Execute cSQL
and because the string cSQL is Wrong , execution failes.....


"David W. Fenton" wrote:

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

BIG-PROBLEM is this wrong-compiler-example
http://i34.tinypic.com/71sdq8.jpg ;


We have not idea what that screenshot means. If you want help,
you're going to have to explain it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/