Search found 5 matches
- Mon Oct 12, 2015 1:17 pm
- Forum: Scripting
- Topic: SwitchClient, ODBC and Parent Value
- Replies: 11
- Views: 7114
Re: SwitchClient, ODBC and Parent Value
Good to know it's not possible, I'll put my efforts into workarounds instead! :D Many thanks to everyone who responded, I'm going to send this as a feature request to Enfocus. Not sure how much demand there is for such a feature, although I'd imagine it would open up a lot more possibilities for Swi...
- Wed Oct 07, 2015 11:47 am
- Forum: Scripting
- Topic: SwitchClient, ODBC and Parent Value
- Replies: 11
- Views: 7114
Re: SwitchClient, ODBC and Parent Value
Using checkpoints is interesting -- unlike the submit point, there's a lot more information readily available. It would definitely be a workable solution for us, although it would be great to avoid the extra step. Here's what we're trying to create. In SwitchClient, we currently have a submit point ...
- Tue Oct 06, 2015 6:09 pm
- Forum: Scripting
- Topic: SwitchClient, ODBC and Parent Value
- Replies: 11
- Views: 7114
Re: SwitchClient, ODBC and Parent Value
In our case, we're just setting the Data values field of a Dropdown list to 'Define values from ODBC data source' , and querying our MIS for whatever information we need. It works well for us, but it would work a lot better if we could make our SQL statements aware of other selected values! However,...
- Tue Oct 06, 2015 5:07 pm
- Forum: Scripting
- Topic: SwitchClient, ODBC and Parent Value
- Replies: 11
- Views: 7114
Re: SwitchClient, ODBC and Parent Value
Thanks for the reply. Just to explain the problem a little more, I'm defining some metadata fields in a Submit Point, and depending on the value selected from a dropdown list, I need my SQL query to change. For example, if I have a 'Job Type' dropdown with the values 'A', 'B' and 'C', and a user sel...
- Tue Oct 06, 2015 4:35 pm
- Forum: Scripting
- Topic: SwitchClient, ODBC and Parent Value
- Replies: 11
- Views: 7114
SwitchClient, ODBC and Parent Value
I'm defining some metadata fields, and have a drop down list that's populated from an ODBC data source.
Is it possible to access the selected parent value so I can use it as a variable inside my SQL statement?
Thanks,
Michael
Is it possible to access the selected parent value so I can use it as a variable inside my SQL statement?
Thanks,
Michael