VB App to Query SQL and output file
- Status: Closed
- Prize: £200
- Entries Received: 24
- Winner: NourElDeen
We have started writing an app in VB Express 2012 which queries a SQL database based on what is entered into a field for use with redeeming voucher codes. This then displays a form based on what is entered. We need the functionality extended to achieve the following:
Load a form depending on what data is return to display the data, this will be a choice of two
Update a field in the SQL when a button is pressed for the record returned above
Create a settings area where we can input the SQL connection details rather than having it hard coded and directory for output text file (below)
Have a site number in the settings area which is commited to a field in the SQL table when a record is updated
Output a text file of the returned data (3 fields max)
A full document spec will be provided along with the source VB files of app so far.
“Great developer really understood what we were after and offered suggestions along the way. Would certainly use again”
leedrew, United Kingdom.