Hello,
I have this formula. My problem is when I try executing this formula the pAppMth temp var does not get filled in;
field App = AB
field picMth1 = Jan
field picday = 8
field picYear = 2003
pAppMth should like something like this ABJAN 8, 2003" ;
Formula in the field:
pAppMth := @UpperCase( App + picMth1 + " " + picDay + ", " + picYear )
fApp := @UpperCase( @DbColumn(“” : “NoCache” ; “” : “” ; “JanComp” ; 1 ) ) ;
fDte := @UpperCase( @DbColumn(“” : “NoCache” ; “” : “” ; “JanComp” ; 6 ) ) ;
list := fApp + fDte ;
antiList := @ReplaceSubstring( list ; pAppMth ; " ");
wantedList :=@Trim( @ReplaceSubstring( list ; antiList ; " " ) );
@Elements( wantedList )
Subject: Are you actually…
assigning the fields as you have shown in your post?
field App = AB
field picMth1 = Jan
field picday = 8
field picYear = 2003
If so, you forgot the colons before the equal sign:
field App := AB
field picMth1 := Jan
field picday := 8
field picYear := 2003
Rocky Oliver
Sapphire Oak Technologies
EML: rock@sapphireoak.com
**The brain that doesn’t feed itself, eats itself.~Gore Vidal
<<< Rocky is speaking at these upcoming events… >>>
IBM DeveloperWorks Live!
New Orleans, LA – April 9 - 12, 2003
http://www.ibm.com/events/developerworkslive
DNUG Developer Conference
(German Notes User Group)
Hamburg, Germany – May 20 - 21, 2003
http://www.dnug.de/DNUG/DNUGCMS.nsf/id/18Konf.htm