This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to use the precreate statement as part of a app. That means if a user selects ID '12345' from an interface tool, I would like to delete recs in SQL server with that same ID through the pre create statement, then afterwards I would append new records with the same ID. What I really miss is having the ability to send one Name & Value to an interface tool like label or readonly textbox.Then I could use Label/Textbox->Action->Output and change the precreate statement that way. I tried the formula way but SQL think I am running a stored procedure. It looks like I need to use a listbox or dropdown tool and do it that way but that means I am cluttering my app with unnecessary tools. Could you give interface tools a 'hide' property or allow a field to be passed to the pre-Create SQL statement? Unless there's another way to do all this?