Hi all,
I am trying to deal with issues that have come up since converting a few users to R6. Everyone still on 5.0.11 are fine but those on R6 are running into some issues. We have a time entry form in a database. There is a Request sheet that gets assigned a project number. In the Time Entry form the proj num field is a combobox field that is a DBLOOKUP of proj nums. I display the entered time in a view that combines the proj num and proj desc. The R6 records show a blank space after the project number.
Ex:
1460Link to AS400 - R5
1460 Link to AS400 - R6.
I took all the spaces out to show this and yet this one still remains. I am including the lookup and view column selection. I can list the proj num assignment but I debugged and the character doesn’t appear, also if you don’t select the proj number from the combobox but type it in yourself - it works fine. I am at a total loss so any help would be greatly appreciated.
Combobox lookup:
NoCache := “NoCache”;
database := @Subset(@DbName; -1);
View := “KAG”;
server := @Subset(@DbName;1);
Key := @Name([CN];@UserName);
Column := 2;
@Unique(“Admin”:“Help Ops”: “Help User”:“Misc”:“Time Off”:@DbLookup(“”:NoCache;server:database;View;Key;Column))
View Column:
TimeProj + TimeDesc
When I change the view column to below the proj num disappears all together.
@Left(TimeProj;" ") + TimeDesc
Thank You.