The template for the ExecuteSQL function is ExecuteSQL ( sqlQuery ; fieldSeparator ; rowSeparator { ; arguments... } ), indicating that the fourth argument is optional. 90% of the time, I pass empty strings as the second and third arguments, generally because the defaults are fine or because I'm performing a query that I know will return a single record.
It's a minor change, I suppose, but making the second and third parameters optional would be nice.
and if you need the optional 4th..N arguments? then you need to add the 3rd & 4th parameters?
beverly
Yes. The template for the function would be ExecuteSQL ( sqlQuery { ; fieldSeparator ; rowSeparator { ; arguments... } } ), or even ExecuteSQL ( sqlQuery { ; fieldSeparator { ; rowSeparator { ; arguments... } } } ). Only the first parameter would be required. If you need to supply later parameters, you have to supply the earlier parameters. Examples:
ExecuteSQL ( $_sql )
ExecuteSQL ( $_sql ; ":" )
ExecuteSQL ( $_sql ; "" ; Char ( 10 ) )
ExecuteSQL ( $_sql ; "" ; "" ; $_argument )
good idea. Tab & Return as defaults do it well for most cases.