Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to retrieve the table information ?

3 posts in Objects Last posting was on 2002-06-24 19:16:36.0Z
steven Posted on 2002-06-14 03:14:08.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "steven" <stvhui@yahoo.com>
Subject: How to retrieve the table information ?
Date: Thu, 13 Jun 2002 20:14:08 -0700
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000
NNTP-Posting-Host: 61.5.20.209
Message-ID: <364_gbbrKRuECHA.200@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1192
Article PK: 713751

Hello to you,
I'm uisng pb8

How to retrieve the table information ? (I'm using ms-access 2000, tables)
FieldName, FieldType, etc

steven


S.V. Software Posted on 2002-06-24 19:16:36.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "S.V. Software" <NOsvsoftwareSPAM@yahoo.com>
Subject: Re: How to retrieve the table information ?
Date: Mon, 24 Jun 2002 13:16:36 -0600
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 200.41.54.125
Message-ID: <364_bZvK4V7GCHA.196@forums.sybase.com>
References: <364_gbbrKRuECHA.200@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1158
Article PK: 713720

This has been implemented for odbc, Microsoft SQL Server, Oracle and Sybase
Adaptive Server Enterprise in our product:
SQL Builder Professional.
Check it out at http://www.svsoftware.da.ru

"steven" <stvhui@yahoo.com> wrote in message
news:gbbrKRuECHA.200@forums.sybase.com...
> Hello to you,
> I'm uisng pb8
>
> How to retrieve the table information ? (I'm using ms-access 2000, tables)
> FieldName, FieldType, etc
>
> steven
>
>


Terry Dykstra Posted on 2002-06-13 16:23:48.0Z
Newsgroups: sybase.public.powerbuilder.objects
From: "Terry Dykstra" <dontreply_tddykstra@forestoil.ca>
Subject: Re: How to retrieve the table information ?
Date: Thu, 13 Jun 2002 10:23:48 -0600
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: gw.cfol.ab.ca 209.115.237.14
Message-ID: <364_RXo8ogvECHA.195@forums.sybase.com>
References: <364_gbbrKRuECHA.200@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.objects:1191
Article PK: 713753

msysobjects where type = 1 gives you a list of tables in the database. I
have no idea where to find column info.

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
MySybase http://my.sybase.com/mysybase
Search Google: http://groups.google.com

"steven" <stvhui@yahoo.com> wrote in message
news:gbbrKRuECHA.200@forums.sybase.com...
> Hello to you,
> I'm uisng pb8
>
> How to retrieve the table information ? (I'm using ms-access 2000, tables)
> FieldName, FieldType, etc
>
> steven
>
>