DbExpress and Table primary key fields

Janne Hamalainen

Delphi Developer

Sat, 18 Dec 2004 22:29:11 GMT

DbExpress and Table primary key fields

How I can figure table primary key (fields) with delphi 6, interbase 6 and
dbExpress ?
Is there good dbExpress support for Sybase ASE 12.0 ? And does that primary
key 'query' work there too ?

Thanks

Janne

Visoco support tea

Delphi Developer

Sat, 18 Dec 2004 22:45:38 GMT

Re:DbExpress and Table primary key fields

Hello, Janne.

Quote

> Is there good dbExpress support for Sybase ASE 12.0 ?

Support is on the way.

You can find dbExpress driver for Sybase ASE here
http://www.visoco.com.

Quote

> And does that primary key 'query' work there too ?

Simply execute 'alter table <table_name> add constraint <constraint_name>
primary key (<fields>)'

Best regards,
VISOCO Support team
supp...@visoco.com
http://www.visoco.com

Bill Tod

Delphi Developer

Sun, 19 Dec 2004 06:59:39 GMT

Re:DbExpress and Table primary key fields

Are you asking how to create a primary key on an existing InterBase
table? If so, use the SQL ALTER TABLE command to add a primary key
constraint.

On Tue, 2 Jul 2002 17:29:11 +0300, "Janne Hamalainen"

Quote

<hamalainenNoS...@luukku.com> wrote:
>Hi

>How I can figure table primary key (fields) with delphi 6, interbase 6 and
>dbExpress ?
>Is there good dbExpress support for Sybase ASE 12.0 ? And does that primary
>key 'query' work there too ?

>Thanks

>Janne

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Janne Hamalaine

Delphi Developer

Sun, 19 Dec 2004 13:19:42 GMT

Re:DbExpress and Table primary key fields

No. I try to get primary fields from existing Interbase/Sybase-table.

Quote

"Bill Todd" <b...@notthis.dbginc.com> wrote in message

news:o0c4iu072e8v9a7hj1g43oneuinn2dt97m@4ax.com...

Quote

> Are you asking how to create a primary key on an existing InterBase
> table? If so, use the SQL ALTER TABLE command to add a primary key
> constraint.

> On Tue, 2 Jul 2002 17:29:11 +0300, "Janne Hamalainen"
> <hamalainenNoS...@luukku.com> wrote:

> >Hi

> >How I can figure table primary key (fields) with delphi 6, interbase 6
and
> >dbExpress ?
> >Is there good dbExpress support for Sybase ASE 12.0 ? And does that
primary
> >key 'query' work there too ?

> >Thanks

> >Janne

> --
> Bill (TeamB)
> (TeamB cannot respond to questions received via email)

Bill Tod

Delphi Developer

Mon, 20 Dec 2004 01:53:51 GMT

Re:DbExpress and Table primary key fields

For InterBase you need to query the system tables. See chapter 7 of
the Language Reference and look at RDB$RELATION_CONSTRAINTS and
RDB$INDEX_SEGMENTS. I do not know about Sybase.

On Wed, 3 Jul 2002 08:19:42 +0300, "Janne Hamalainen"

Quote

<hamalainenNoS...@luukku.com> wrote:
>No. I try to get primary fields from existing Interbase/Sybase-table.
>"Bill Todd" <b...@notthis.dbginc.com> wrote in message
>news:o0c4iu072e8v9a7hj1g43oneuinn2dt97m@4ax.com...
>> Are you asking how to create a primary key on an existing InterBase
>> table? If so, use the SQL ALTER TABLE command to add a primary key
>> constraint.

>> On Tue, 2 Jul 2002 17:29:11 +0300, "Janne Hamalainen"
>> <hamalainenNoS...@luukku.com> wrote:

>> >Hi

>> >How I can figure table primary key (fields) with delphi 6, interbase 6
>and
>> >dbExpress ?
>> >Is there good dbExpress support for Sybase ASE 12.0 ? And does that
>primary
>> >key 'query' work there too ?

>> >Thanks

>> >Janne

>> --
>> Bill (TeamB)
>> (TeamB cannot respond to questions received via email)

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Other Threads

1. Sorting Paradox Tables With Indexed Primary Key Fields

2. Primary key fields of a Paradox Table

3. Primary key or not primary key.........

4. dbExpress does not supprot mySQL AUTO_INCREMENT primary key ???

5. Is there a problem using Autoincrement fields as a primary key

6. Determining Paradox Primary Index's Key Field(s)

7. Primary key and AutoInc field

8. how to get primary key field name use ADO

9. Primary Key Field Attribute

10. Returning primary key fields