I have a PB app that was written long ago, and one thing it does is build its (MySQL) database as needed. To do this, all of the scripts needed to build the database were added to function objects, one per database object. i.e., there's an "fn_create_mytable" that builds a table, "fn_create_myproc" that creates a procedure, etc.
Because these are functions, they are really ungainly because the create statement must be pasted into the function, and then every line wrapped like:
ls_sql = "select this,"~r~n" +&
etc., until the whole script is there. Then it executes the statement at the end. So when it needs maintenance, you have to copy the script out, strip out the junk, paste it into a SQL editor, and then reverse the process to put it back.
In a C# application you can store text files in a class as embedded resources and they're not visible to the user, but can be referenced by the code. I would love to be able to do that somehow in that PB application. Is it possible?
I apologize if this is an obvious question. I can certainly deploy all the scripts as text files, but then it's all editable and visible to the user. I want it hidden in a class/NVO, or something without all the string manipulation.
Any ideas would be much appreciated.