>INSERT INTO qcombined1 (name,amt,dedcode,nat.....
>append blank
>replace all fields with space""
>or replace record with space"" 
>

* INSERT INTO example
* This will create a new record and assign values in a single step.
insert into MyTable (Field1, Field2) values (Value1, Value2)

* APPEND BLANK example
* APPEND BLANK will only add a blank record; you then need a REPLACE to assign values
select MyTable
append blank
replace;
  Field1 with Value1,;
  Field2 with Value2