I trying add a number based on Code field entry on the form. It’s not working.
lu:=@Text(@Elements(@DbColumn(“Notes”:“NoCache”;“”:“”;“GetAlphaSeq”;Code)));
numb:=@TextToNumber(lu)+1;
@If(Code!=“” & lu=“”;“1”;@SetField(“SeqAlpha”;@Text(numb)))
Subject: DBColumn is missing a view name
I trying add a number based on Code field entry on the form. It’s not working.
lu:=@Text(@Elements(@DbColumn(“Notes”:“NoCache”;“”:“Not tested but the view Name should be here”;“GetAlphaSeq”;Code)));
numb:=@TextToNumber(lu)+1;
@If(Code!=“” & lu=“”;“1”;@SetField(“SeqAlpha”;@Text(numb)))
Tip, something like this might have given you a hint:
A := @DbColumn(“Notes”:“NoCache”;“”:“Not tested but the view Name should be here”;“GetAlphaSeq”;Code);
@Prompt([OKCANCELLIST]:[NoSort] ; “Display _A” ; “”; “”; @Text(A));
“”
Instead of counting the docs it might be better to use @Subset to get the first (or last) value in the list - This way you are running less likely in trouble if some documents would be missing.