ohh, I see now. Thanks!


>If you want to build SQL command as string, use TEXTMERGE (see below). It makes code readable. The string values have to be enclosed in single quotes. You may consider using SPT parameters ('?') instead.
>
>>Ok, I have another problem with this code.
>>
>>SWL is reporting "The name 'JVILLAGOMEZ' is not permitted in this context. Only constants, expressions,
>>or variables allowed here. Column names are not permitted."
>>
>>It must be referencing the 'user_name' column, but I don't see why.
>>
>>Here's the CREATE TABLE code again:
>>
><snip>
>
>

>TEXT TO lcSql TEXTMERGE NOSHOW
>create table Recon_Info (
>id int IDENTITY NOT NULL,
>media_order_detail_id int NOT NULL,
>user_name CHAR(40) NOT NULL,
>invoice_no CHAR(40) NOT NULL,
>batch_no CHAR(8) NOT NULL,
>status CHAR(1) NOT NULL,
>done_date_time datetime NOT NULL,
>invoice_date datetime NOT NULL,
>due_date datetime NOT NULL,
>from_date datetime NOT NULL,
>to_date datetime NOT NULL,
>invoice_notes char(128),
>adjustment_amt float(8)
>)
>ENDTEXT
>
>TEXT TO lcSql TEXTMERGE NOSHOW
>insert into Recon_Info (" +;
>	media_order_detail_id,
>	user_name,
>	invoice_no,
>	batch_no,
>	status,
>	done_date_time,
>	invoice_date,
>	due_date,
>	from_date,
>	to_date ,
>	invoice_notes,
>	adjustment_amt
>	) values (
>	<<TRANSFORM(Commits.DtId)>>,	
>	<<Commits.UserId>>,	
>	<<Commits.InvoiceId>>,	
>	<<Commits.BatchId>>,	
>	'<<IIF(Commits.Scanned, 'P', Commits.Status)>>',	
>	'<<cDoneDate>>',	
>	'<<cInvDate>>',	
>	'<<cDueDate>>',	
>	'<<cFromDate>>',	
>	'<<cToDate>>',	
>	'<<Commits.Notes>>',	
>	<<TRANSFORM(Commits.AdjAmt)>>
>	)
>ENDTEXT
>
>