Robert, I am sorry. You could use:

TEXT TO sqlCommand TEXTMERGE NOSHOW PRETEXT 7
    ...
ENDTEXT

Here what Intellisense made of us :-) I just write TXT and it expand whole command :-)





>grrr, lol here is my code
>
>SET TEXTMERGE DELIMITERS TO <<>>
>
> TEXT TO SQLCOMMAND NOSHOW PRETEXT 7
> INSERT INTO TB_ARINV (TR_ACC_PERIOD,TR_ACC_YEAR,TR_ACTIVITY,TR_CLAIM,TR_CLAIM_DET,TR_CLAIM_OK,
> TR_CLAIM_OK_DET,TR_COD,TR_CONSOLID,TR_CONSOLNO,TR_CR_BY,TR_CR_DATETIME,
> TR_CURR,TR_CUR_RATE,TR_CUSTID,TR_CUSTLVSPO)
> VALUES (
> <>,<>,'<>',<>,
> '<>',<>,
> '<>',<>,<>,<>,
> '<>',<<{ARINV.CR_DATETIME}>>,
> '<>',<>,<>,'<>')
> ENDTEXT
>
>
> STORE SQLEXEC(hConn ,SQLCOMMAND,'CUR_SEARCH') TO L_N
>
> IF L_N = 1 THEN
> MESSAGEBOX("AAAA")
> &&IF RecCount([CUR_SEARCH]) = 0 THEN
>
> ENDIF
>
>in the SQLCOMMAND i still get
>INSERT INTO TB_ARINV (TR_ACC_PERIOD,TR_ACC_YEAR,TR_ACTIVITY,TR_CLAIM,TR_CLAIM_DET,TR_CLAIM_OK,
> TR_CLAIM_OK_DET,TR_COD,TR_CONSOLID,TR_CONSOLNO,TR_CR_BY,TR_CR_DATETIME,
> TR_CURR,TR_CUR_RATE,TR_CUSTID,TR_CUSTLVSPO)
> VALUES (
> <>,<>,'<>',<>,
> '<>',<>,
> '<>',<>,<>,<>,
> '<>',<<{ARINV.CR_DATETIME}>>,
> '<>',<>,<>,'<>')

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.