On Wed, Jun 24, 2009 at 12:18 PM, Shaun Seckman (Firaxis)<shaun.seck...@firaxis.com> wrote: > Just two quick and simple questions :) > > > > In a prepared statement, is there a quick way to > determine what the index of a column with a specific name is or must I > just iterate through all columns and perform a string comparison? > > > > How can I go by determining the default value of a > column? > >
these are strange questions... if you are preparing statements, that implies you are inserting values in the db, and if you are doing so, you are supposed to know what its structure is... you can't just arbitrarily try to insert stuff in someone else's db. To find out the default value of a specific column, I guess you could try inserting a row, but leave the desired column entry blank so you are insert nothing in that col, and then select your inserted row and see what got inserted into the column. If it has a value, then that would be the default value. > > -Shaun > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Carbon Model http://carbonmodel.org/ Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/ Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor/ Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ ----------------------------------------------------------------------- collaborate, communicate, compete ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
