OK What am I doing wrong? I have two unrelated tables. One is for the data the other internal settings the the Application. The top of my Import Photos script looks as follows:
|Set Error Capture [ On ]|
|Go to Layout [ “EmployeeID” (EmployeeID) ]|
|Set Variable [ $$iNoOfRecords; Value:Get(TotalRecordCount) ]|
|Set Variable [ $$iRecCnt; Value:0 ]|
|Set Variable [ $$iPhotoImportCnt; Value:0 ]|
|Set Variable [ $$iPhotoMissingCnt; Value:0 ]|
|Set Variable [ $$iPhotoExistsCnt; Value:0 ]|
|Set Variable [ $$sStaffPhotoPath; Value:InternalSettings::StaffPhotoPath ]|
|Go to Record/Request/Page [ First ]|
|Set Variable [ $$EmpNoFormat; Value:Right ( _Append ( "0" ; InternalSettings::EmpNoLength ; ""); InternalSettings::EmpNoLength) ]|
|Set Variable [ $sEmpNoFile; Value:Right ($$sEmpNoFormat & EmployeeID::EmpNo; InternalSettings::EmpNoLength ) & InternalSettings::ImageExtention ]|
|Set Variable [ $sPathAndFile; Value:$sStaffPhotoPath & $sEmpNoFile ]|
Ofcourse the script continues. The two yellow rows have InternalSetting::EmpNoLenth which both return results however the red row which has InternalSettings::StaffPhotoPath gives me unrelated table and it creates a blank for $$sStaffPhotoPath. It should be returning "imagewin:/D:/.../.../.../.../.../" which is all my nested folders to where the photo are. I don't want to relate the table to the other table. It is just a table I setup to contain App Settings.
Anyone know what I am doing wrong?