> -----Original Message----- > From: Chase [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 02, 2007 12:39 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] how do i declare and use variables in sqlite? > > > select 542 as x; > > that part works, but then when i try to access it, i get "no column x"... > > select x; > > set x = 542; > var x = 542; > @set x = 542; > @var x = 542; > set @x = 542; > var @x = 542; > $set x = 542; > $var x = 542; > set $x = 542; > var $x = 542; > > > none of these seem to work and i can't find the documentation on this > subject. > > can someone shed some light on this for me?
AFAIK, this isn't something you do with SQLite. You can retrieve values into variables in the host language (C, C++, or some wrapping language), and you can bind their values into SQL statements. -- James ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
