Re: [sqlite] : about add sqlite database cloumn

2011-12-23 Thread Kit
2011/12/23 YAN HONG YE : > I have a question about C binding for sqlite, I have a table like this: > > Name    Price1  Price2  Sum > A1      23      231 > A2      22      12 > A3      21      223 > > how to use functin >  int  myfunc() { > int tt=0; > if (price1>2) tt++; > if

Re: [sqlite] : about add sqlite database cloumn

2011-12-23 Thread Kees Nuyt
On Fri, 23 Dec 2011 04:40:53 +, YAN HONG YE wrote: >I have a question about C binding for sqlite, I have a table like this: > >Name Price1 Price2 Sum >A1 23 231 >A2 22 12 >A3 21 223 > >how to use functin > int myfunc()

Re: [sqlite] : about add sqlite database cloumn

2011-12-22 Thread YAN HONG YE
I have a question about C binding for sqlite, I have a table like this: NamePrice1 Price2 Sum A1 23 231 A2 22 12 A3 21 223 how to use functin int myfunc() { int tt=0; if (price1 >2) tt++; if (price2>1) tt++; if (price2>12) tt++; ...

Re: [sqlite] about add sqlite database cloumn

2011-12-21 Thread Simon Slavin
On 22 Dec 2011, at 2:52am, YAN HONG YE wrote: > I have a question about C binding for sqlite, I have a table like this: > > Name Price1 Price2 Sum > A123 231 > A222 12 > A321 223 > > how to use functin int sum(price1+price2) > result to put

Re: [sqlite] about add sqlite database cloumn

2011-12-21 Thread YAN HONG YE
> I have a question about C binding for sqlite. I have seen those for > integer, float... but I was wondering how to deal with a NUMERIC (x, y) > type ? > We can't use float or double, we could loose precision, so maybe with a > string ? I have a question about C binding for sqlite, I have a