We're trying to receive data from an AS/400, and all the fields from the AS/400 database are being passed back through and ICF file as one long string. Rather than hard coding the positions of the variables, like "DepartmentText.Text = Mid$(sData, 7, 30)", what is the best way of extracting the individual variables from the incoming string? Surely there must be a more professional way of doing this, like calling a function that strips out the values, without you having to specify the position of each field?
We have considered passing the incomming string into the VB application, with the values separated by commas, and in VB, calling a generic function that scans through this string, and pulls out the varaibles.
The problem with this is we don't know how to call this generic application, because the number of variables could vary from application to application