Search found 5 matches

by m.mcmullin
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...
by m.mcmullin
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 ...
by m.mcmullin
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,...
by m.mcmullin
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...
by m.mcmullin
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