I'm working on an application using FTView Studio SE, FT Trans. Mgr., and a SQL database with custom tables/stored procedures. I need to provide the customer with a controlled way to maintain the database (add, delete, modify table content). I know that I can use VBA in SE, but we moved away from that scheme for this project for a number of reasons. Hence I'm hesitant to use it for this feature/functionality.
Is there any other methods in FTView SE to allow for this ability?
I had considered using the PLC as a "middle-man" in this process but that in itself is problematic as memory in the PLC would need to be allocated for the max size of queries need to fulfill this function. Not knowing how this db may grow with time that is troublesome, not to mention the amount of memory utilized that would be very sparsely used.
Any help or ideas would be appreciated!
Mike
Is there any other methods in FTView SE to allow for this ability?
I had considered using the PLC as a "middle-man" in this process but that in itself is problematic as memory in the PLC would need to be allocated for the max size of queries need to fulfill this function. Not knowing how this db may grow with time that is troublesome, not to mention the amount of memory utilized that would be very sparsely used.
Any help or ideas would be appreciated!
Mike