Correct SQL string based on one source table

Need in VB a function that takes a SQL string and an array of fields and takes out of the SQL string those bits that deal with fields that are not in the supplied array of fields. So, it will check both the SELECT and the WHERE fields

and takes out the bits that would cause an error due to the fields not being present in the FROM table. It doesn't have to deal with joins nor sub-selects.

## Deliverables

This is a small project and should take a few hours at most.

Coder will need to know VB and SQL, but nil else.

I know both myself, but just want to save some time.

Διαχείριση Βάσεων Δεδομένων Μηχανολογία MySQL PHP Αρχιτεκτονική Λογισμικού Δοκιμή Λογισμικού SQL

Ταυτότητα Εργασίας: #2913468

Σχετικά με την εργασία