I'm using SOCI to access a PostgreSQL database. One particular table that I
have has 72 columns. My question is how does one best deal with so many
columns?
I've determined that for selecting, using the SOCI dynamic result set is
probably best. In this way I can loop over the columns.
However, for inserting I'm having difficulty. What I want to achieve is
something as follows:
int vals[NUM_VALS];
statement st = s.prepare << "INSERT INTO table (c0, c1, c2, ...) VALUES (";
for(int i = 0; i < NUM_VALS; ++i)
st << vals[i];
st << ")";
st.execute();
Is anything like this possible? I've had no luck finding any way of dealing
with large numbers of columns in an easy way.
Jordan
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
