Paradox Community

Items in pnews.paradox-programming

Subject:Re: New fields to existing table
Date:Wed, 4 Apr 2018 21:52:23 +0100
From:Roger Phil <roger@agent2000.co.uk>
Newsgroups:pnews.paradox-programming
Hello Thies, and Mark, Thank you.

In the 25 years  since I developed my P7 "App" I have never even looked 
at SQL, perhaps I've wasted a lot of time.
Situation now is since Creators broke P7 & I've moved to P10 I've 
changed quite a few features which means clients data needs to be 
changed with added fields but some don't need all as with past updates 
some have been changed.

Question can I use SQL to check the field structure and write needed 
fields if they don't exist
e.g. if not TcFlds.locate("Field Name", "Recon") then ....
      if not TcFlds.locate("Field Name", "Exempt") then......
  ....etc.

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
>>
>


-- 
RogerD


Copyright © 2004 thedbcommunity.com