[sqlite] List of columns of a table

[jose isaias cabrera]

Greetings.
I have been playing with

PRAGMA index_list(tablename)

but I am not getting it to work.  I am using D, a new language comparable to 
c.  Anyway, the libraries available are lacking and so I must use queries to 
get the values that I want.  But I am trying to get the list of the columns 
of a table, but I am failing.  The call I am doing is,

Rows = db.query("PRAGMA index_list(LSOpenJobs);");

But Rows has nothing.  Is there any other way that I could get a list of the 
columns of a table?

thanks,

josé 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------