Nando, thanks,

This did not work, it must be something that Fishbowl does with the db,
I get
the following error when I try to query this from PHP
Dynamic SQL Error SQL error code = -204 Table unknown RDB unknown
ISC error 336397208 in
*/opt/apache-2.0.59/htdocs/egroupware/test.php* on line *9*

$stmt = "SELECT RDB$FIELD_NAME from RDB$RELATION_FIELDS where
RDB$RELATION_NAME = 'SO' order by RDB$FIELD_POSITION";
$prep = ibase_prepare ($dbh, $stmt);
$res = ibase_execute($prep);
while ($x = ibase_fetch_row($res)) {
print_r($x);
}

I'm guessing that they may have changed the structure?


Nando Dessena wrote:

> Joe,
>
> c> I need to find out how to get the column header names
>
> select trim(RDB$FIELD_NAME)
> from RDB$RELATION_FIELDS
> where RDB$RELATION_NAME = 'YOUR_TABLE'
> order by RDB$FIELD_POSITION
>
> Ciao
>

--
Joseph Oaks
Systems Admin
Propeller Inc.
801-607-3264