Data Management SQL script using a variable
Content
We have ~10 scripts for conversion from VB (FDM classic) that use a temp variable based on a target custom member. In this case the second segment of the target entity is stored in a variable and appended to the location which is based on the source account. In some scripts there are thousands of combinations so multi-dim maps aren't feasible. How can we define a variable in the mapping script?
Version
21.08.93Code Snippet
strSrcPlatform = varValues(16) 'get the entity strSrcAcct = varValues(13) 'get the source account strTarPlatform = """" 'set the initial platform to blank strSrcC1 = varValues(19) strTarAcct = varValues(14) If InstrRev(strSrcPlatform, ""_"") >0 Then ' check to make sure the entity has a platform at the end strTarPlatform = Mid(strSrcPlatform,InstrRev (strSrcPlatform, ""_"")) 'if the entity has a platform at the end, grab it and store this value End If Select Case strSrcAcct 'take the account and based on the value, choose which entity is the ICP Case ""04006000"",""04006323"", ""04006339"", ""04007000"",""04007323"" ,""04007339"",""05016000"",""05016323"" ,""05016339"" ,""05017000"",""05017339"" ,""07076000"" ,""07076323"" ,""07076339"" ,""07077000"" ,""07077323"" ,""07077339"" strTarICP
Tagged:
0