How do I optimize the VTS for use with multiple projects?

  • Questions
  • How do I optimize the VTS for use with multiple projects?
Question ID: 105302
2
0

We have five different project that need to use the VTS concurrently. What can I do to optimize efficiency and handle multiple projects?

Marked as spam
Posted by (Questions: 23, Answers: 4)
Asked on February 7, 2014 6:41 pm
3 views
Answers (1)
2
Private answer

This is the way that I have handled this in the past. I assign a Column name in the VTS to each project. Then I create a composite record that contains multiple data elements separated by a delimiter (For example a '':'').

Example Composite data:

234398:Smith:John:11987 Cathy Rd:Lithia:FL:33547:813 555-5555:221-89-9999:

Once this is done, you make a single retrieve from the VTS on the project column. Within your script, use strtok to separate the data elements and place those in parameters using lr_save_string.

As far as I know there is no limited on the number of characters stored within a single VTS data field.

Marked as spam
Posted by (Questions: 4, Answers: 41)
Answered on February 7, 2014 6:47 pm