[AccessD] Dynamic SQL statement

[Susan Harkins]

Stuart -- I considered something similar, but because it was a one-time
deal, I didn't go to the trouble -- but it's definitely a good idea. Thank
you!

Susan H.

On Mon, Dec 7, 2015 at 4:35 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Where some fields may not be required (Null), I  use one Insert statement
> which inserts
> every column every time but wrap every insert parameter in a function
> appropriate to the
> datatype which handles empty fields and escapes strings.
>
>
>