Re: Local variables

2004-09-10 Thread Michael Stassen
Carlos Savoretti wrote: Hello all: I need to make certain operations like this: select tbl_no as 'Number' , @sal1 := tbl_db - tbl_hb + @sal1 as 'Total' I'm using the C API; so I make it through mysql_query() Problem is than having `tbl_db' and 'tbl_hb' with certain values no operation is carried

Re: Local variables

2004-09-10 Thread gerald_clark
Carlos Savoretti wrote: Hello all: I need to make certain operations like this: select tbl_no as 'Number' , @sal1 := tbl_db - tbl_hb + @sal1 as 'Total' I'm using the C API; so I make it through mysql_query() Problem is than having `tbl_db' and 'tbl_hb' with certain values no operation is carried

Local variables

2004-09-10 Thread Carlos Savoretti
Hello all: I need to make certain operations like this: select tbl_no as 'Number' , @sal1 := tbl_db - tbl_hb + @sal1 as 'Total' I'm using the C API; so I make it through mysql_query() Problem is than having `tbl_db' and 'tbl_hb' with certain values no operation is carried out, and `Total' is