Hi Hoping someone can help. I want to populate a form from a SQL table. The idea I have is to enter a membership number into a text field and then the matching details are pulled from a SQL table & populate the form i.e. name, DOB, address. There are about 10000 records in the SQL table. Any ideas or help appricated. There is an example provided in the HELP section (see below) but it does not work
//Change the commandType from TABLE to TEXT. TEXT //is the equivalent of SQL Property $sourceSet.DataConnection.#command.query.commandType = "text" //Set the Select Node. Select in this case will be //whatever SQL Property you want $sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat("Select*from OfficeSupplies Where ID = ", DataListBox1.rawValue,"") //Reopen the Data connection $sourceSet.DataConnection.open()