View source for RDO FIELD TABLE()

==Purpose==
Return the name of the table where a specified field is located


==Syntax==
RDO_FIELD_TABLE(<object>,<expN>)

MYSQL_FIELD_TABLE(<object>,<expN>)


==See Also==
[[RDO_AFFECTED_ROWS()]], [[RDO_CLOSE()]], [[RDO_CONNECT()]], [[RDO_DATA_SEEK()]], [[RDO_ERRNO()]], [[RDO_ERROR()]], [[RDO_EXEC()]], [[RDO_FETCH_ARRAY()]], [[RDO_FETCH_ASSOC()]], [[RDO_FETCH_FIELD()]], [[RDO_FETCH_LENGTHS()]], [[RDO_FETCH_OBJECT()]], [[RDO_FETCH_ROW()]], [[RDO_FIELD_FLAGS()]], [[RDO_FIELD_LEN()]], [[RDO_FIELD_NAME()]], [[RDO_FIELD_SEEK()]], [[RDO_FIELD_TYPE()]], [[RDO_FREE_OBJECT()]], [[RDO_FREE_RESULT()]], [[RDO_GET_CLIENT_INFO()]], [[RDO_GET_HOST_INFO()]], [[RDO_INFO()]], [[RDO_LIST_DBS()]], [[RDO_NUM_FIELDS()]], [[RDO_NUM_ROWS()]], [[RDO_PING()]], [[RDO_QUERY()]], [[RDO_REAL_ESCAPE_STRING()]], [[RDO_RESULT()]], [[RDO_SELECT_DB()]], [[RDO_STAT()]], [[RDO_THREAD_ID()]], [[RDO_UNBUFFERED_QUERY()]]


==Description==
The RDO_FIELD_TABLE() function is used to return the name of the table where a specified field is located.


{| class="wikitable"
!Keywords||Description
|-
|<object>||Result set
|-
|<expN>||Column number
|-
|}


==Example==
<code lang="recital">
conn = rdo_connect("recital", "localhost", "?", "?","southwind")
if conn > -1
    res = rdo_query("select * from shippers", conn)
    for i = 0 to rdo_num_fields(res)-1
        echo "table = ", rdo_field_table(res,i), "\n"
        echo "type = ", rdo_field_type(res,i), "\n"
        echo "name = ", rdo_field_name(res,i), "\n"
        echo "len = ", rdo_field_len(res,i), "\n"
        echo "flags = ", rdo_field_flags(res,i), "\n"
    next
    rdo_close(conn)
endif
</code>


==Products==
Recital, Recital Server
[[Category:Documentation]]
[[Category:Functions]]
[[Category:SQL]]
[[Category:Remote Data Connectivity Functions]]