You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Management SQL script using a variable

Question
10
Views
0
Comments

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.93

Code 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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!