Subject | Re: [firebird-support] Re: Tables of a database and columns of a table |
---|---|
Author | W O |
Post date | 2011-04-01T03:57:55Z |
Hello Jonathan
Thank you for your answer.
Yes, I did, but it doesnt work. SQLTABLES() show me the system tables but
not my own tables.
And SQLCOLUMNS() works when using the parameter FOXPRO, but not when using
NATIVE and I need, native :-(
Greetings.
Walter.
On Thu, Mar 31, 2011 at 11:12 PM, realoldgeek2008 <
jonathan.finch@...> wrote:
Thank you for your answer.
Yes, I did, but it doesnt work. SQLTABLES() show me the system tables but
not my own tables.
And SQLCOLUMNS() works when using the parameter FOXPRO, but not when using
NATIVE and I need, native :-(
Greetings.
Walter.
On Thu, Mar 31, 2011 at 11:12 PM, realoldgeek2008 <
jonathan.finch@...> wrote:
>[Non-text portions of this message have been removed]
>
> I recall you're using Visual Foxpro. Have you tried its SQLTABLES() and
> SQLCOLUMNS() functions?
>
> Jonathan
>
>
> --- In firebird-support@yahoogroups.com, W O <sistemas2000profesional@...>
> wrote:
> >
> > Hello everybody
> >
> > Is it possible for an external program know which are the tables of a
> > Database?
> >
> > And which are the columns of a table?
> >
> > In ISQL I can write:
> > SHOW TABLES;
> >
> > SHOW TABLE MyTable;
> >
> > And it works, but if I want to get that data from my program, what can I
> do?
> >
> > Thanks in advance.
> >
> > Walter.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>