I would use sql as well.  Restructure has some very big quirks.

On 4/4/2018 5:50 AM, Thies Grimm wrote:
> hello Roger,
> 
> just use SQL
> 
> something like
> 
> db.open(AliasName)
> 
> itemSQL =
>   SQL
>    alter Table 'myTable'
>      add myNewFieldName CHAR(20)
>    endSQL
> if not itemSQL.executeSQL(db) then
>    errorShow()
> endIf
> 
> Thies
> 
> 
> Roger Phil <roger@agent2000.co.uk> wrote:
>> Would anyone know if it's possible in opal to add extra fields to an
>> existing table without using enumfieldstruct to create a new table and
>> then adding records ?
>>
>>
>> -- 
>> RogerD
>>
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>>
>