Paradox Community

Items in pnews.paradox-programming

Subject:Re: New fields to existing table
Date:4 Apr 2018 06:50:50 -0400
From:"Thies Grimm" <thies.grimm@t-online.de>
Newsgroups:pnews.paradox-programming

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
>


Copyright © 2004 thedbcommunity.com