how to get specific record from table based on user input

[Former Community Member]

I have used MS Access database.



How to get specific record from table based on user input.



If you have any script.Please help me.

[Former Community Member]

Hi,<br /><br />I have almost the problem, but based on the user input repeatable texfields should occur...<br /><br />Solution für one field. Use the custom dropdown box and replace <value> in the code...<br /><br />Put the following code into the change event of the listbox:<br />Modify SQL and Sourcenames<br />//<br />// Modify the SQL Statement on the MoviesInCat data connection such that it filters the records on the selected category.<br />//

[Former Community Member]

var sCategoryName = xfa.event.newText

var sCategoryId = $.boundItem(sCategoryName)

var oDataConn = Ref(xfa.sourceSet.ProgramData) oDataConn.#command.query.commandType = "text"



oDataConn.#command.query.select =

concat("SELECT * FROM tbl_ProgramData WHERE Program_ID= ", sCategoryId , ";")



oDataConn.open()



oDataConn.first()

oDataConn.close()