• Registered: 2015-10-13
  • Posts: 38

Topic: SQL with user input

Hi,

I'm new to MVD but enjoying the learning curve. I'm trying to write a script that generates a report. No problem with a simple SQL statement. But I'm having trouble when I try use data from an input box as part of the search requirements. SELECT * FROM Flights WHERE fltTripID = data from the input box. Can you help please.
Thanks Terry

  • Registered: 2014-06-25
  • Posts: 863

Re: SQL with user input

This might be a good starting point: http://myvisualdatabase.com/forum/viewtopic.php?id=92

  • Registered: 2014-02-14
  • Posts: 10,294

Re: SQL with user input

Terry
Hello,


Here you can find more info:
http://myvisualdatabase.com/help_en/com … n_sql.html

Dmitry.