>>>I want to make a copy of a record in a table and add it to the same table. I know that I can set carry on and just use the append command to do this but it opens the edit window. The only way to append without opening the edit window that I know of is to use append blank but then I have to use replace commands to fill the blank fields. How can I append without opening the edit window?
>>>
>>>Thanks in advance,
>>>Justin
>>
>>select mytable
>>scatter memvar memo
>>insert into myTable from memvar
>>
>>Beware with PKs.
>>Cetin
>
>Better yet, use the NAME clause. Adapting the example above:
>
>
>select mytable
>scatter memvar memo name loRecord
>loRecord.MyField1 = <some specific value>
>...
>append blank
>* if a PK is assigned automatically (default value) when inserting a record:
>loRecord.MyPK = MyPk
>*
>gather name loRecord
>
Hilmar,
While there are numerous ways to do this I simply couldn't get why this is 'better'. Translating yours :
select mytable
scatter memvar memo
m.MyField1 =
...
* if a PK is assigned automatically (default value) when inserting a record:
m.MyPK = MyPk
insert into myTable from memvar
Now why using name is better ? Just it's more OOP or anything else ?
Cetin
