Author | Topic: Problem with Transform() function. | |
---|---|---|
Marcelo | Problem with Transform() function. on Mon, 28 Aug 2006 14:23:36 -0400 Hi there, I'm having a weird problem with the transform function: @20,3 say "Transform 1"+ TRANSFORM(5542.99,"99,999,999.99") //Formats properly. inkey(0) @21,3 say "Transform 2"+ TRANSFORM(NIL,"99,999,999.99") //Will simply close the application (no crash message or anything) inkey(0) The message returned on the second @say is: (from debugger) ? E ? RROR: Loading xpmsmarcelo ? Exception: 0xC00000FD ? Possible DLL version conflict ? ? OK Below is my XPPLOAD report in case anyone needs it. C:\VSS_DOS\XBase\xPMS>xppload Alaska XppLoad Version 1.90.331 Copyright (c) Alaska Software 1997-2006. All rights reserved. ADAC20B.dll, 2006-04-27 12:32:06, 449536, 1.90.331,C:\ALASKA\XPPW32\LIB\,V ADAC20C.dll, 2006-04-27 12:32:06, 69120, 1.90.331,C:\ALASKA\XPPW32\LIB\,V Aimplib.EXE, 2006-04-27 11:42:54, 94720, 1.90.331,C:\ALASKA\XPPW32\BIN\,V Alink.exe, 2006-04-27 11:42:54, 130560, 1.90.331,C:\ALASKA\XPPW32\BIN\,V Arc.exe, 2006-04-27 11:43:12, 139776, 1.90.331,C:\ALASKA\XPPW32\BIN\,V ASCOM10.dll, 2006-05-04 12:56:26, 596480, 1.90.331,C:\ALASKA\XPPW32\LIB\,V ASCOM10c.dll, 2006-05-04 12:56:26, 139264, 1.90.331,C:\ALASKA\XPPW32\LIB\,V ASLogResource.dll, 2006-04-27 11:42:42, 32768, 0.00. 0,C:\ALASKA\XPPW3 \LIB\ ASRDBC10.DLL, 2006-04-27 12:32:06, 132096, 1.90.331,C:\ALASKA\XPPW32\LIB\,V CdxDbe.dll, 2006-05-12 15:29:58, 145408, 1.90.331,C:\ALASKA\XPPW32\LIB\,V DbfDbe.dll, 2006-04-27 12:32:06, 118784, 1.90.331,C:\ALASKA\XPPW32\LIB\,V DelDbe.dll, 2006-04-27 12:32:06, 96768, 1.90.331,C:\ALASKA\XPPW32\LIB\,V DllInfo.exe, 2006-04-27 12:09:36, 87552, 1.90.331,C:\ALASKA\XPPW32\BIN\,V FoxDbe.dll, 2006-04-27 12:03:30, 131072, 1.90.331,C:\ALASKA\XPPW32\LIB\,V NtxDbe.dll, 2006-04-27 12:32:06, 123392, 1.90.331,C:\ALASKA\XPPW32\LIB\,V Pbuild.EXE, 2006-04-27 12:09:30, 317440, 1.90.331,C:\ALASKA\XPPW32\BIN\,V SdfDbe.dll, 2006-04-27 12:32:06, 84992, 1.90.331,C:\ALASKA\XPPW32\LIB\,V SOM.DLL, 1996-02-20 11:42:00, 198144, 0.00. 0,C:\ALASKA\XPPW32\LIB\ Tlb2Ch.exe, 2006-04-27 12:09:44, 75776, 0.00. 0,C:\ALASKA\XPPW32\BIN\ Xpp.exe, 2006-04-27 12:32:12, 79360, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppCbe.dll, 2006-04-27 12:32:12, 156160, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppCfe.dll, 2006-04-27 12:32:12, 250368, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppDApi.dll, 2006-04-27 12:08:46, 547328, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppDbg.exe, 2006-04-27 12:08:50, 742912, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppDbgc.dll, 2006-04-27 12:32:06, 77312, 1.90.331,C:\ALASKA\XPPW32\LIB\,V XppDbgk.dll, 2006-04-27 12:08:34, 190464, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppDmenu.dll, 2006-04-27 12:08:48, 83456, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppErr.dll, 2006-04-27 12:32:12, 67584, 1.90.331,C:\ALASKA\XPPW32\BIN\ XppFD.exe, 2006-04-27 12:10:34, 2388480, 1.90.331,C:\ALASKA\XPPW32\BIN\ XppFilt.EXE, 2006-04-27 11:42:56, 72192, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppGen.dll, 2006-04-27 12:32:12, 179712, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppGraph.dll, 2006-04-27 12:32:12, 74752, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppLoad.exe, 2006-04-27 12:07:28, 111616, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppNat.dll, 2006-04-27 12:32:06, 169472, 1.90.331,C:\ALASKA\XPPW32\LIB\,V XppPp.dll, 2006-04-27 12:07:20, 182272, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppRt1.dll, 2006-04-27 12:32:06, 1802752, 1.90.331,C:\ALASKA\XPPW32\LIB\,V XppRt2.dll, 2006-04-27 12:32:06, 89088, 1.90.331,C:\ALASKA\XPPW32\LIB\,V XppSrtl.dll, 2006-04-27 12:32:12, 287744, 1.90.331,C:\ALASKA\XPPW32\BIN\,V XppUi1.dll, 2006-04-27 12:32:06, 1490432, 1.90.331,C:\ALASKA\XPPW32\LIB\,V XppUi2.dll, 2006-04-27 12:32:06, 1279488, 1.90.331,C:\ALASKA\XPPW32\LIB\,V XppUi3.dll, 2006-04-27 12:09:28, 606208, 1.90.331,C:\ALASKA\XPPW32\LIB\,V 41 file(s) processed. C:\VSS_DOS\XBase\xPMS> Anyone have a clue? Thanks in advance! Marcelo | |
Joe Carrick | Re: Problem with Transform() function. on Mon, 28 Aug 2006 12:43:15 -0700 Hi Marcello, According to the docs: ************************************************************* Transform( <Expression>, <cSayPicture> ) --> cFormattedString Parameters <Expression> <Expression> is an expression whose value can be of data type "character", "numeric", "logical" or "date". ************************************************************* NIL is not a valid data type for <Expression>. If you must allow a NIL value then try this: FUNCTION MyTransform( xValue, cPict) RETURN Transform( iif(valtype(xValue)=="U",0.00,xValue), cPict ) HTH, Joe Marcelo wrote: > Hi there, > > I'm having a weird problem with the transform function: > > @20,3 say "Transform 1"+ TRANSFORM(5542.99,"99,999,999.99") //Formats > properly. > inkey(0) > @21,3 say "Transform 2"+ TRANSFORM(NIL,"99,999,999.99") //Will simply > close the application (no crash message or anything) > inkey(0) > > > The message returned on the second @say is: (from debugger) > > ? E > ? RROR: Loading xpmsmarcelo > ? Exception: 0xC00000FD > ? Possible DLL version conflict > ? > ? OK > > Below is my XPPLOAD report in case anyone needs it. > > C:\VSS_DOS\XBase\xPMS>xppload > Alaska XppLoad Version 1.90.331 > Copyright (c) Alaska Software 1997-2006. All rights reserved. > > ADAC20B.dll, 2006-04-27 12:32:06, 449536, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > ADAC20C.dll, 2006-04-27 12:32:06, 69120, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > Aimplib.EXE, 2006-04-27 11:42:54, 94720, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > Alink.exe, 2006-04-27 11:42:54, 130560, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > Arc.exe, 2006-04-27 11:43:12, 139776, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > ASCOM10.dll, 2006-05-04 12:56:26, 596480, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > ASCOM10c.dll, 2006-05-04 12:56:26, 139264, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > ASLogResource.dll, 2006-04-27 11:42:42, 32768, 0.00. > 0,C:\ALASKA\XPPW3 > \LIB\ > ASRDBC10.DLL, 2006-04-27 12:32:06, 132096, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > CdxDbe.dll, 2006-05-12 15:29:58, 145408, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > DbfDbe.dll, 2006-04-27 12:32:06, 118784, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > DelDbe.dll, 2006-04-27 12:32:06, 96768, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > DllInfo.exe, 2006-04-27 12:09:36, 87552, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > FoxDbe.dll, 2006-04-27 12:03:30, 131072, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > NtxDbe.dll, 2006-04-27 12:32:06, 123392, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > Pbuild.EXE, 2006-04-27 12:09:30, 317440, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > SdfDbe.dll, 2006-04-27 12:32:06, 84992, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > SOM.DLL, 1996-02-20 11:42:00, 198144, 0.00. > 0,C:\ALASKA\XPPW32\LIB\ > Tlb2Ch.exe, 2006-04-27 12:09:44, 75776, 0.00. > 0,C:\ALASKA\XPPW32\BIN\ > Xpp.exe, 2006-04-27 12:32:12, 79360, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppCbe.dll, 2006-04-27 12:32:12, 156160, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppCfe.dll, 2006-04-27 12:32:12, 250368, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppDApi.dll, 2006-04-27 12:08:46, 547328, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppDbg.exe, 2006-04-27 12:08:50, 742912, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppDbgc.dll, 2006-04-27 12:32:06, 77312, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > XppDbgk.dll, 2006-04-27 12:08:34, 190464, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppDmenu.dll, 2006-04-27 12:08:48, 83456, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppErr.dll, 2006-04-27 12:32:12, 67584, > 1.90.331,C:\ALASKA\XPPW32\BIN\ > XppFD.exe, 2006-04-27 12:10:34, 2388480, > 1.90.331,C:\ALASKA\XPPW32\BIN\ > XppFilt.EXE, 2006-04-27 11:42:56, 72192, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppGen.dll, 2006-04-27 12:32:12, 179712, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppGraph.dll, 2006-04-27 12:32:12, 74752, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppLoad.exe, 2006-04-27 12:07:28, 111616, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppNat.dll, 2006-04-27 12:32:06, 169472, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > XppPp.dll, 2006-04-27 12:07:20, 182272, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppRt1.dll, 2006-04-27 12:32:06, 1802752, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > XppRt2.dll, 2006-04-27 12:32:06, 89088, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > XppSrtl.dll, 2006-04-27 12:32:12, 287744, > 1.90.331,C:\ALASKA\XPPW32\BIN\,V > XppUi1.dll, 2006-04-27 12:32:06, 1490432, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > XppUi2.dll, 2006-04-27 12:32:06, 1279488, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > XppUi3.dll, 2006-04-27 12:09:28, 606208, > 1.90.331,C:\ALASKA\XPPW32\LIB\,V > > 41 file(s) processed. > > C:\VSS_DOS\XBase\xPMS> > > > Anyone have a clue? > > Thanks in advance! > Marcelo > > > | |
Marcelo | Re: Problem with Transform() function. on Mon, 28 Aug 2006 16:13:55 -0400 Hi Joe, I noticed that passage on the docs, bu shouldn't it be backward compatible with the clipper function? Just wondering.... Thanks, Marcelo "Joe Carrick" <joe.carrick@dslextreme.com> wrote in message news:b58072d$3b2c3661$18643c@news.alaska-software.com... > Hi Marcello, > > According to the docs: > > ************************************************************* > > Transform( <Expression>, <cSayPicture> ) --> cFormattedString > > Parameters > > <Expression> > > <Expression> is an expression whose value can be of data type "character", > "numeric", "logical" or "date". > > ************************************************************* > > NIL is not a valid data type for <Expression>. If you must allow a NIL > value then try this: > > FUNCTION MyTransform( xValue, cPict) > RETURN Transform( iif(valtype(xValue)=="U",0.00,xValue), cPict ) > > HTH, Joe > > > > Marcelo wrote: >> Hi there, >> >> I'm having a weird problem with the transform function: >> >> @20,3 say "Transform 1"+ TRANSFORM(5542.99,"99,999,999.99") >> //Formats properly. >> inkey(0) >> @21,3 say "Transform 2"+ TRANSFORM(NIL,"99,999,999.99") //Will >> simply close the application (no crash message or anything) >> inkey(0) >> >> >> The message returned on the second @say is: (from debugger) >> >> ? E >> ? RROR: Loading xpmsmarcelo >> ? Exception: 0xC00000FD >> ? Possible DLL version conflict >> ? >> ? OK >> >> Below is my XPPLOAD report in case anyone needs it. >> >> C:\VSS_DOS\XBase\xPMS>xppload >> Alaska XppLoad Version 1.90.331 >> Copyright (c) Alaska Software 1997-2006. All rights reserved. >> >> ADAC20B.dll, 2006-04-27 12:32:06, 449536, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> ADAC20C.dll, 2006-04-27 12:32:06, 69120, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> Aimplib.EXE, 2006-04-27 11:42:54, 94720, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> Alink.exe, 2006-04-27 11:42:54, 130560, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> Arc.exe, 2006-04-27 11:43:12, 139776, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> ASCOM10.dll, 2006-05-04 12:56:26, 596480, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> ASCOM10c.dll, 2006-05-04 12:56:26, 139264, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> ASLogResource.dll, 2006-04-27 11:42:42, 32768, 0.00. >> 0,C:\ALASKA\XPPW3 >> \LIB\ >> ASRDBC10.DLL, 2006-04-27 12:32:06, 132096, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> CdxDbe.dll, 2006-05-12 15:29:58, 145408, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> DbfDbe.dll, 2006-04-27 12:32:06, 118784, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> DelDbe.dll, 2006-04-27 12:32:06, 96768, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> DllInfo.exe, 2006-04-27 12:09:36, 87552, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> FoxDbe.dll, 2006-04-27 12:03:30, 131072, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> NtxDbe.dll, 2006-04-27 12:32:06, 123392, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> Pbuild.EXE, 2006-04-27 12:09:30, 317440, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> SdfDbe.dll, 2006-04-27 12:32:06, 84992, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> SOM.DLL, 1996-02-20 11:42:00, 198144, 0.00. >> 0,C:\ALASKA\XPPW32\LIB\ >> Tlb2Ch.exe, 2006-04-27 12:09:44, 75776, 0.00. >> 0,C:\ALASKA\XPPW32\BIN\ >> Xpp.exe, 2006-04-27 12:32:12, 79360, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppCbe.dll, 2006-04-27 12:32:12, 156160, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppCfe.dll, 2006-04-27 12:32:12, 250368, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppDApi.dll, 2006-04-27 12:08:46, 547328, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppDbg.exe, 2006-04-27 12:08:50, 742912, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppDbgc.dll, 2006-04-27 12:32:06, 77312, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> XppDbgk.dll, 2006-04-27 12:08:34, 190464, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppDmenu.dll, 2006-04-27 12:08:48, 83456, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppErr.dll, 2006-04-27 12:32:12, 67584, >> 1.90.331,C:\ALASKA\XPPW32\BIN\ >> XppFD.exe, 2006-04-27 12:10:34, 2388480, >> 1.90.331,C:\ALASKA\XPPW32\BIN\ >> XppFilt.EXE, 2006-04-27 11:42:56, 72192, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppGen.dll, 2006-04-27 12:32:12, 179712, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppGraph.dll, 2006-04-27 12:32:12, 74752, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppLoad.exe, 2006-04-27 12:07:28, 111616, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppNat.dll, 2006-04-27 12:32:06, 169472, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> XppPp.dll, 2006-04-27 12:07:20, 182272, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppRt1.dll, 2006-04-27 12:32:06, 1802752, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> XppRt2.dll, 2006-04-27 12:32:06, 89088, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> XppSrtl.dll, 2006-04-27 12:32:12, 287744, >> 1.90.331,C:\ALASKA\XPPW32\BIN\,V >> XppUi1.dll, 2006-04-27 12:32:06, 1490432, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> XppUi2.dll, 2006-04-27 12:32:06, 1279488, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> XppUi3.dll, 2006-04-27 12:09:28, 606208, >> 1.90.331,C:\ALASKA\XPPW32\LIB\,V >> >> 41 file(s) processed. >> >> C:\VSS_DOS\XBase\xPMS> >> >> >> Anyone have a clue? >> >> Thanks in advance! >> Marcelo >> >> | |
Joe Carrick | Re: Problem with Transform() function. on Mon, 28 Aug 2006 14:19:56 -0700 It should, but evidently isn't. Report it directly to Support@Alaska-Software.com and maybe they'll fix it. Marcelo wrote: > Hi Joe, > > I noticed that passage on the docs, bu shouldn't it be backward > compatible with the clipper function? > > Just wondering.... > Thanks, > Marcelo > > "Joe Carrick" <joe.carrick@dslextreme.com> wrote in message > news:b58072d$3b2c3661$18643c@news.alaska-software.com... > >>Hi Marcello, >> >>According to the docs: >> >>************************************************************* >> >>Transform( <Expression>, <cSayPicture> ) --> cFormattedString >> >>Parameters >> >><Expression> >> >><Expression> is an expression whose value can be of data type "character", >>"numeric", "logical" or "date". >> >>************************************************************* >> >>NIL is not a valid data type for <Expression>. If you must allow a NIL >>value then try this: >> >>FUNCTION MyTransform( xValue, cPict) >>RETURN Transform( iif(valtype(xValue)=="U",0.00,xValue), cPict ) >> >>HTH, Joe >> >> >> >>Marcelo wrote: >> >>>Hi there, >>> >>> I'm having a weird problem with the transform function: >>> >>> @20,3 say "Transform 1"+ TRANSFORM(5542.99,"99,999,999.99") >>>//Formats properly. >>> inkey(0) >>> @21,3 say "Transform 2"+ TRANSFORM(NIL,"99,999,999.99") //Will >>>simply close the application (no crash message or anything) >>> inkey(0) >>> >>> >>> The message returned on the second @say is: (from debugger) >>> >>>? E >>>? RROR: Loading xpmsmarcelo >>>? Exception: 0xC00000FD >>>? Possible DLL version conflict >>>? >>>? OK >>> >>> Below is my XPPLOAD report in case anyone needs it. >>> >>>C:\VSS_DOS\XBase\xPMS>xppload >>>Alaska XppLoad Version 1.90.331 >>>Copyright (c) Alaska Software 1997-2006. All rights reserved. >>> >>>ADAC20B.dll, 2006-04-27 12:32:06, 449536, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>ADAC20C.dll, 2006-04-27 12:32:06, 69120, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>Aimplib.EXE, 2006-04-27 11:42:54, 94720, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>Alink.exe, 2006-04-27 11:42:54, 130560, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>Arc.exe, 2006-04-27 11:43:12, 139776, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>ASCOM10.dll, 2006-05-04 12:56:26, 596480, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>ASCOM10c.dll, 2006-05-04 12:56:26, 139264, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>ASLogResource.dll, 2006-04-27 11:42:42, 32768, 0.00. >>>0,C:\ALASKA\XPPW3 >>>\LIB\ >>>ASRDBC10.DLL, 2006-04-27 12:32:06, 132096, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>CdxDbe.dll, 2006-05-12 15:29:58, 145408, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>DbfDbe.dll, 2006-04-27 12:32:06, 118784, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>DelDbe.dll, 2006-04-27 12:32:06, 96768, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>DllInfo.exe, 2006-04-27 12:09:36, 87552, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>FoxDbe.dll, 2006-04-27 12:03:30, 131072, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>NtxDbe.dll, 2006-04-27 12:32:06, 123392, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>Pbuild.EXE, 2006-04-27 12:09:30, 317440, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>SdfDbe.dll, 2006-04-27 12:32:06, 84992, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>SOM.DLL, 1996-02-20 11:42:00, 198144, 0.00. >>>0,C:\ALASKA\XPPW32\LIB\ >>>Tlb2Ch.exe, 2006-04-27 12:09:44, 75776, 0.00. >>>0,C:\ALASKA\XPPW32\BIN\ >>>Xpp.exe, 2006-04-27 12:32:12, 79360, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppCbe.dll, 2006-04-27 12:32:12, 156160, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppCfe.dll, 2006-04-27 12:32:12, 250368, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDApi.dll, 2006-04-27 12:08:46, 547328, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDbg.exe, 2006-04-27 12:08:50, 742912, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDbgc.dll, 2006-04-27 12:32:06, 77312, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppDbgk.dll, 2006-04-27 12:08:34, 190464, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDmenu.dll, 2006-04-27 12:08:48, 83456, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppErr.dll, 2006-04-27 12:32:12, 67584, >>>1.90.331,C:\ALASKA\XPPW32\BIN\ >>>XppFD.exe, 2006-04-27 12:10:34, 2388480, >>>1.90.331,C:\ALASKA\XPPW32\BIN\ >>>XppFilt.EXE, 2006-04-27 11:42:56, 72192, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppGen.dll, 2006-04-27 12:32:12, 179712, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppGraph.dll, 2006-04-27 12:32:12, 74752, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppLoad.exe, 2006-04-27 12:07:28, 111616, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppNat.dll, 2006-04-27 12:32:06, 169472, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppPp.dll, 2006-04-27 12:07:20, 182272, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppRt1.dll, 2006-04-27 12:32:06, 1802752, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppRt2.dll, 2006-04-27 12:32:06, 89088, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppSrtl.dll, 2006-04-27 12:32:12, 287744, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppUi1.dll, 2006-04-27 12:32:06, 1490432, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppUi2.dll, 2006-04-27 12:32:06, 1279488, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppUi3.dll, 2006-04-27 12:09:28, 606208, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>> >>>41 file(s) processed. >>> >>>C:\VSS_DOS\XBase\xPMS> >>> >>> >>> Anyone have a clue? >>> >>>Thanks in advance! >>>Marcelo >>> >>> > > | |
Joe Carrick | Re: Problem with Transform() function. on Mon, 28 Aug 2006 14:29:00 -0700 BTW, how do you get a NIL to pass to this function anyway? Since Transform() can accept value types of "C", "N", "L" or "D" you would generally need to know what type of value to convert the NIL into. Generally, I would think that xValue would be one of these unless it happened to be an uninitialized variable. If that's the case, then you really should think about correcting it. At the vary least, you can initialize the variable to "", 0.00, .F. or date(); depending of course on what you need. -Joe Marcelo wrote: > Hi Joe, > > I noticed that passage on the docs, bu shouldn't it be backward > compatible with the clipper function? > > Just wondering.... > Thanks, > Marcelo > > "Joe Carrick" <joe.carrick@dslextreme.com> wrote in message > news:b58072d$3b2c3661$18643c@news.alaska-software.com... > >>Hi Marcello, >> >>According to the docs: >> >>************************************************************* >> >>Transform( <Expression>, <cSayPicture> ) --> cFormattedString >> >>Parameters >> >><Expression> >> >><Expression> is an expression whose value can be of data type "character", >>"numeric", "logical" or "date". >> >>************************************************************* >> >>NIL is not a valid data type for <Expression>. If you must allow a NIL >>value then try this: >> >>FUNCTION MyTransform( xValue, cPict) >>RETURN Transform( iif(valtype(xValue)=="U",0.00,xValue), cPict ) >> >>HTH, Joe >> >> >> >>Marcelo wrote: >> >>>Hi there, >>> >>> I'm having a weird problem with the transform function: >>> >>> @20,3 say "Transform 1"+ TRANSFORM(5542.99,"99,999,999.99") >>>//Formats properly. >>> inkey(0) >>> @21,3 say "Transform 2"+ TRANSFORM(NIL,"99,999,999.99") //Will >>>simply close the application (no crash message or anything) >>> inkey(0) >>> >>> >>> The message returned on the second @say is: (from debugger) >>> >>>? E >>>? RROR: Loading xpmsmarcelo >>>? Exception: 0xC00000FD >>>? Possible DLL version conflict >>>? >>>? OK >>> >>> Below is my XPPLOAD report in case anyone needs it. >>> >>>C:\VSS_DOS\XBase\xPMS>xppload >>>Alaska XppLoad Version 1.90.331 >>>Copyright (c) Alaska Software 1997-2006. All rights reserved. >>> >>>ADAC20B.dll, 2006-04-27 12:32:06, 449536, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>ADAC20C.dll, 2006-04-27 12:32:06, 69120, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>Aimplib.EXE, 2006-04-27 11:42:54, 94720, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>Alink.exe, 2006-04-27 11:42:54, 130560, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>Arc.exe, 2006-04-27 11:43:12, 139776, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>ASCOM10.dll, 2006-05-04 12:56:26, 596480, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>ASCOM10c.dll, 2006-05-04 12:56:26, 139264, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>ASLogResource.dll, 2006-04-27 11:42:42, 32768, 0.00. >>>0,C:\ALASKA\XPPW3 >>>\LIB\ >>>ASRDBC10.DLL, 2006-04-27 12:32:06, 132096, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>CdxDbe.dll, 2006-05-12 15:29:58, 145408, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>DbfDbe.dll, 2006-04-27 12:32:06, 118784, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>DelDbe.dll, 2006-04-27 12:32:06, 96768, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>DllInfo.exe, 2006-04-27 12:09:36, 87552, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>FoxDbe.dll, 2006-04-27 12:03:30, 131072, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>NtxDbe.dll, 2006-04-27 12:32:06, 123392, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>Pbuild.EXE, 2006-04-27 12:09:30, 317440, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>SdfDbe.dll, 2006-04-27 12:32:06, 84992, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>SOM.DLL, 1996-02-20 11:42:00, 198144, 0.00. >>>0,C:\ALASKA\XPPW32\LIB\ >>>Tlb2Ch.exe, 2006-04-27 12:09:44, 75776, 0.00. >>>0,C:\ALASKA\XPPW32\BIN\ >>>Xpp.exe, 2006-04-27 12:32:12, 79360, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppCbe.dll, 2006-04-27 12:32:12, 156160, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppCfe.dll, 2006-04-27 12:32:12, 250368, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDApi.dll, 2006-04-27 12:08:46, 547328, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDbg.exe, 2006-04-27 12:08:50, 742912, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDbgc.dll, 2006-04-27 12:32:06, 77312, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppDbgk.dll, 2006-04-27 12:08:34, 190464, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppDmenu.dll, 2006-04-27 12:08:48, 83456, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppErr.dll, 2006-04-27 12:32:12, 67584, >>>1.90.331,C:\ALASKA\XPPW32\BIN\ >>>XppFD.exe, 2006-04-27 12:10:34, 2388480, >>>1.90.331,C:\ALASKA\XPPW32\BIN\ >>>XppFilt.EXE, 2006-04-27 11:42:56, 72192, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppGen.dll, 2006-04-27 12:32:12, 179712, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppGraph.dll, 2006-04-27 12:32:12, 74752, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppLoad.exe, 2006-04-27 12:07:28, 111616, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppNat.dll, 2006-04-27 12:32:06, 169472, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppPp.dll, 2006-04-27 12:07:20, 182272, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppRt1.dll, 2006-04-27 12:32:06, 1802752, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppRt2.dll, 2006-04-27 12:32:06, 89088, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppSrtl.dll, 2006-04-27 12:32:12, 287744, >>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>XppUi1.dll, 2006-04-27 12:32:06, 1490432, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppUi2.dll, 2006-04-27 12:32:06, 1279488, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>XppUi3.dll, 2006-04-27 12:09:28, 606208, >>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>> >>>41 file(s) processed. >>> >>>C:\VSS_DOS\XBase\xPMS> >>> >>> >>> Anyone have a clue? >>> >>>Thanks in advance! >>>Marcelo >>> >>> > > | |
Marcelo | Re: Problem with Transform() function. on Tue, 29 Aug 2006 09:26:29 -0400 Well Joe I really don't know why the program is like this, i'm just trying to port it to xBase, this application has over 20 years and over a dozen "programmers" played (I wouldn't say worked for most of em) with it... What happens is that an array is loaded and then passed into this transform..and well some of the indexes are not initialized at all....This happens in various portions of the application, and I don't have the time to fix each case (make sure that the value passed is not nil) so instead I will wrap that transform into my own and treat these problems in there. I tried overloading the transform but somehow I dont know how to do so.. :P The solution on PDR 4048 doesn't seem to work for me (yet at least).. Well thank you for the answers! Regards, Marcelo "Joe Carrick" <joe.carrick@dslextreme.com> wrote in message news:2572a8bc$78a3528b$186998@news.alaska-software.com... > BTW, how do you get a NIL to pass to this function anyway? > > Since Transform() can accept value types of "C", "N", "L" or "D" you would > generally need to know what type of value to convert the NIL into. > > Generally, I would think that xValue would be one of these unless it > happened to be an uninitialized variable. If that's the case, then you > really should think about correcting it. At the vary least, you can > initialize the variable to "", 0.00, .F. or date(); depending of course on > what you need. > > -Joe > > > > Marcelo wrote: > >> Hi Joe, >> >> I noticed that passage on the docs, bu shouldn't it be backward >> compatible with the clipper function? >> >> Just wondering.... >> Thanks, >> Marcelo >> >> "Joe Carrick" <joe.carrick@dslextreme.com> wrote in message >> news:b58072d$3b2c3661$18643c@news.alaska-software.com... >> >>>Hi Marcello, >>> >>>According to the docs: >>> >>>************************************************************* >>> >>>Transform( <Expression>, <cSayPicture> ) --> cFormattedString >>> >>>Parameters >>> >>><Expression> >>> >>><Expression> is an expression whose value can be of data type >>>"character", "numeric", "logical" or "date". >>> >>>************************************************************* >>> >>>NIL is not a valid data type for <Expression>. If you must allow a NIL >>>value then try this: >>> >>>FUNCTION MyTransform( xValue, cPict) >>>RETURN Transform( iif(valtype(xValue)=="U",0.00,xValue), cPict ) >>> >>>HTH, Joe >>> >>> >>> >>>Marcelo wrote: >>> >>>>Hi there, >>>> >>>> I'm having a weird problem with the transform function: >>>> >>>> @20,3 say "Transform 1"+ TRANSFORM(5542.99,"99,999,999.99") >>>> //Formats properly. >>>> inkey(0) >>>> @21,3 say "Transform 2"+ TRANSFORM(NIL,"99,999,999.99") //Will >>>> simply close the application (no crash message or anything) >>>> inkey(0) >>>> >>>> >>>> The message returned on the second @say is: (from debugger) >>>> >>>>? E >>>>? RROR: Loading xpmsmarcelo >>>>? Exception: 0xC00000FD >>>>? Possible DLL version conflict >>>>? >>>>? OK >>>> >>>> Below is my XPPLOAD report in case anyone needs it. >>>> >>>>C:\VSS_DOS\XBase\xPMS>xppload >>>>Alaska XppLoad Version 1.90.331 >>>>Copyright (c) Alaska Software 1997-2006. All rights reserved. >>>> >>>>ADAC20B.dll, 2006-04-27 12:32:06, 449536, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>ADAC20C.dll, 2006-04-27 12:32:06, 69120, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>Aimplib.EXE, 2006-04-27 11:42:54, 94720, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>Alink.exe, 2006-04-27 11:42:54, 130560, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>Arc.exe, 2006-04-27 11:43:12, 139776, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>ASCOM10.dll, 2006-05-04 12:56:26, 596480, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>ASCOM10c.dll, 2006-05-04 12:56:26, 139264, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>ASLogResource.dll, 2006-04-27 11:42:42, 32768, 0.00. >>>>0,C:\ALASKA\XPPW3 >>>>\LIB\ >>>>ASRDBC10.DLL, 2006-04-27 12:32:06, 132096, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>CdxDbe.dll, 2006-05-12 15:29:58, 145408, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>DbfDbe.dll, 2006-04-27 12:32:06, 118784, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>DelDbe.dll, 2006-04-27 12:32:06, 96768, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>DllInfo.exe, 2006-04-27 12:09:36, 87552, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>FoxDbe.dll, 2006-04-27 12:03:30, 131072, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>NtxDbe.dll, 2006-04-27 12:32:06, 123392, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>Pbuild.EXE, 2006-04-27 12:09:30, 317440, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>SdfDbe.dll, 2006-04-27 12:32:06, 84992, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>SOM.DLL, 1996-02-20 11:42:00, 198144, 0.00. >>>>0,C:\ALASKA\XPPW32\LIB\ >>>>Tlb2Ch.exe, 2006-04-27 12:09:44, 75776, 0.00. >>>>0,C:\ALASKA\XPPW32\BIN\ >>>>Xpp.exe, 2006-04-27 12:32:12, 79360, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppCbe.dll, 2006-04-27 12:32:12, 156160, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppCfe.dll, 2006-04-27 12:32:12, 250368, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppDApi.dll, 2006-04-27 12:08:46, 547328, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppDbg.exe, 2006-04-27 12:08:50, 742912, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppDbgc.dll, 2006-04-27 12:32:06, 77312, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>XppDbgk.dll, 2006-04-27 12:08:34, 190464, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppDmenu.dll, 2006-04-27 12:08:48, 83456, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppErr.dll, 2006-04-27 12:32:12, 67584, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\ >>>>XppFD.exe, 2006-04-27 12:10:34, 2388480, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\ >>>>XppFilt.EXE, 2006-04-27 11:42:56, 72192, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppGen.dll, 2006-04-27 12:32:12, 179712, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppGraph.dll, 2006-04-27 12:32:12, 74752, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppLoad.exe, 2006-04-27 12:07:28, 111616, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppNat.dll, 2006-04-27 12:32:06, 169472, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>XppPp.dll, 2006-04-27 12:07:20, 182272, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppRt1.dll, 2006-04-27 12:32:06, 1802752, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>XppRt2.dll, 2006-04-27 12:32:06, 89088, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>XppSrtl.dll, 2006-04-27 12:32:12, 287744, >>>>1.90.331,C:\ALASKA\XPPW32\BIN\,V >>>>XppUi1.dll, 2006-04-27 12:32:06, 1490432, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>XppUi2.dll, 2006-04-27 12:32:06, 1279488, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>>XppUi3.dll, 2006-04-27 12:09:28, 606208, >>>>1.90.331,C:\ALASKA\XPPW32\LIB\,V >>>> >>>>41 file(s) processed. >>>> >>>>C:\VSS_DOS\XBase\xPMS> >>>> >>>> >>>> Anyone have a clue? >>>> >>>>Thanks in advance! >>>>Marcelo >>>> >>>> >> |