Yeah I can get the names, but I need to put them in an array, and to put
them in an array I need to know the size of the array to store them in, so I
need to get a count first, then store this number as the size of the array
before I store the values into the array.
Many thanks
John
On 13/07/06, Christian Smith <[EMAIL PROTECTED]> wrote:
John Newby uttered:
> Hi, how can I find out the names of the fields within a given table?
>
> I've tried "pragma table_info(test);"
>
> but this brings back too much info, I just require the names as I'll be
> storing them in an array within my application.
Then just cherry pick the information you require. You get a result set
from the pragma, and the column name is the second field. Not difficult.
>
> Many thanks
>
> John
>
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
