Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread to change the attribute of a field of a table for primary Index = No?
Tue, Sep 25 2007 2:07 PMPermanent Link

"EGEletronic"
He is possivel through programming to change the attribute of a field of a
table for primary Index = In?
EG®

Regards


Tue, Sep 25 2007 3:31 PMPermanent Link

"Donat Hebert \(Worldsoft\)"
If I understand your question, you have to change the entire primary key
with alter which can include one or more segments. (fieldnames)

ALTER table table_reference
Redefine Primary Key(IndexFieldnames) Compress CompressType etc..;

Donat.

"EGEletronic" <eletronica EG@hotmail.com> wrote in message
news:4103302C-8583-4CB2-BDEC-DBC6C7C68687@news.elevatesoft.com...
> He is possivel through programming to change the attribute of a field of a
> table for primary Index = In?
> EG®
>
> Regards
>
>
>

Tue, Sep 25 2007 5:24 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

EG,

<< He is possivel through programming to change the attribute of a field of
a table for primary Index = In? >>

Yes, just use this:

with MyDBISAMTable do
  begin
  FieldDefs.Update;
  IndexDefs.Update;
  IndexDefs.Find('MyIndex').Options:=<NewIndexOptions>;
  AlterTable(<AlterTable Parameters>);
  end;

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Sep 26 2007 7:41 AMPermanent Link

"EGEletronic"
Thanks a lot the Donat and Tim, I obtained to solve the problem.
EG®

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> escreveu na
mensagem news:2089BE87-EF48-45CF-A6C3-8F831C0CD4A9@news.elevatesoft.com...
> EG,
>
> << He is possivel through programming to change the attribute of a field
> of a table for primary Index = In? >>
>
> Yes, just use this:
>
> with MyDBISAMTable do
>   begin
>   FieldDefs.Update;
>   IndexDefs.Update;
>   IndexDefs.Find('MyIndex').Options:=<NewIndexOptions>;
>   AlterTable(<AlterTable Parameters>);
>   end;
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>


Image