>Howdy,
>Scanning a table and as I go through the records, want to insert records into another table. One field can be valid in the source table, so I want to update the destination record/field with "No Listing provided", else inset the data with the source field/data.
>
>Here's is the code:
> *Scan Sourcetable
> * insert into NewTable (field A, Field B, Field C) values (SourceTable.FieldA, SourceTable.FieldB, iif empty(allt(sourceTable.fieldC)), "No LIsting Provided", allt(sourceTable.fieldC))
>
>Receiving a syntax error.

>Howdy,
>Scanning a TABLE AND AS I GO through the RECORDS, want TO INSERT RECORDS INTO another TABLE. One FIELD can be VALID IN the SOURCE TABLE, so I want TO UPDATE the destination RECORD/FIELD WITH "No Listing provided", ELSE inset the DATA WITH the SOURCE FIELD/DATA.
>
>Here's is the code:
> *SCAN Sourcetable
> * INSERT INTO NewTable (FIELD a, FIELD B, FIELD C) VALUES (Sourcetable.FieldA, Sourcetable.FieldB, IIF EMPTY(ALLT(Sourcetable.fieldC)), "No LIsting Provided", ALLT(Sourcetable.fieldC))
>
>Receiving a syntax ERROR.

Or, maybe without DBX, just SQL ....

INSERT INTO NewTable (;
 field_A, Field_B, Field_C);
 SELECT;
  Sourcetable.FieldA,;
  Sourcetable.FieldB,;
  IIF(EMPTY(ALLT(Sourcetable.fieldC)), "No LIsting Provided", ALLT(Sourcetable.fieldC));
 FROM Sourcetable

;)