Edgar,

You never said if this is to a SQL backend or VFP. Different backends have different quotes requirements especially with date constants. You don't have to allt() the dtoc() and you do need a + before that last string constant.

>yea I thought of doing that now
>l_cSQL = l_cSQL + ",'" + ALLT(DTOC(DATETIME()))"'"
>
>l_cSQL is part of the clause. Now I wonder if I have the quotes right as it is