So I'm currently working on this dynamic forms project for my company to help with form flow. I've begun to get quite comfortable with designer and how to use it. I was able to create a 'forms assistant' if you may the dynamically changes to assist the user in filling out company policy forms. The most recent addition that I have been trying to encorporate is using SQL or data connections to improve the functionality. I'm having some trouble getting what I need accomplished using this type of setup. Basically what I need to do is get the user to fill in a company ID that would then use the value from that field and generate a select with a where clause to populate the rest (or most) of the form for them. I have successfully been able to setup a connection and have fields from an SQL database, but I can't manipulate the data the way I need. This is the basic code or flow that I need to
xfa.sourceSet.HEAT.#command.query.select = "SELECT * FROM Profile WHERE CustID = " + this.rawvalue + ";";
I've been sticking to Java script, and would like to keep it that way. I have been using source material from Stefan Cameron on forms. So the last two commands work fine, and I am able to navigate through records just fine. The first 2 command aren't the right syntax for Java, which I would like to know how to use. But I also tried it as formCalc following the "Selecting Specific Database Records" from Stefan's tutorial. I get the security error that is spoken of at the end of the tutorial. I tried to follow his process for cloning, but his case is a little different from mine. I don't know how it should look or where to create the clone. All I need is a working select statement that I can change the where clause for.