Hi,
I have three sets of data: testing, training, and live, so I created three connections (Testing, Training, and Live) in my project.
What is the best way to organize remote views to have ability to switch between data sources?
1. For each table on backend create three remote views in the project. For example: v_test_reasons, v_train_reasons, v_live_reasons and choose one of them like this
cSource = "test"
Use ("v_"+cSource+"_reasons")
2. ???
Igor Gelin
Database Developer