Re: [sqlite] Possible to use field names instead of index offsets in queries?

Thank you for your help- I understand it better and can work it out now. -- View this message in context: http://www.nabble.com/Possible-to-use-field-names-instead-of-index-offsets-in-queries--tp17461475p17511500.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] Possible to use field names instead of index offsets in queries?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 danjenkins wrote: > Hi, > Without using a wrapper, is there a simple way of accessing a query's > results using field/column names instead of index offsets? You are already using a wrapper - sqlite3_get_table. To solve this problem you will need to

[sqlite] Possible to use field names instead of index offsets in queries?

Hi, Without using a wrapper, is there a simple way of accessing a query's results using field/column names instead of index offsets? For example, instead of: strcpy(DeptCodeStructure[i-1].DeptName, result[i*ncols+1]); Something more like: strcpy(DeptCodeStructure[i-1].DeptName,