Execute SQL: define target / Insert from xDBC

Idea created by Fabrice Nordmann Expert on Sep 9, 2018
    Active
    Score7
    • jrenfrew
    • cval
    • lem_alpha
    • Fabrice Nordmann
    • Johan Hedman
    • BeatriceBeaubien
    • beverly

    One of the best (and unnoticed) improvments in server side scripting happened in FMS 15 when Execute SQL script step became server compatible. One can now use it without installing a DSN on each client. Still, it’s odd that the only way to get values from a sql source (apart from ESS of course) is to import records.

    What if Execute SQL could select and return its result to a target (field or variable)? I think it would make integration with other databases more seamless.