Hi Everyone...

Okay, I have a macros with two process' to accomplish:

1: TransferText Transfer Type: Import Delimited
Specificatoin Name: TRN Import Spec
Table Name: Transaction
File Name: q:\other\sws\data\020305.trn
Has Field Names: No
HTML Table Name:
Code Page:

2: RunSQL SQL Statement:

UPDATE transaction SET particulars=changeover() WHERE LEN(particulars>0

Use Transaction: Yes


Right, is there an error here I don't see?

TIA

Ric