sql语句出错

Question

   vSQL = "SELECT * FROM hq where  price between"
   + upprice
   + " and "
   + lowprice; 

 

1>c:\cprogram\stockactivex\stockactivex\stockactivexctrl.cpp(1156): error C2111: '+' : pointer addition requires integral operand

Answer 1

Between后面再多一个空白试试看

※还有您若是用vb.net的话，后面不用加 ;

 vSQL = "SELECT * FROM hq where price between "
+ upprice
+ " and "
+ lowprice

 

---

• The blog of typewriter職人
• Convert C# to VB.NET
• /*If my concept is wrong ,please correct me.Thanks.*/

Answer 2

Between后面再多一个空白试试看

 vSQL = "SELECT * FROM hq where price between "
+ upprice
+ " and "      //是在这一行出错
+ lowprice;

 

---

• The blog of typewriter職人
• Convert C# to VB.NET
• /*If my concept is wrong ,please correct me.Thanks.*/

知道了

要double to char

Answer 3

 

 vSQL = "SELECT * FROM hq where price between "
+ upprice
+ " and "      //是在这一行出错
+ lowprice;

 

印象中您是使用VB.net吧？

试试这样

 

vSQL = "SELECT * FROM hq where price between " _
                     + upprice _
                     + " and " _
                     + lowprice

---

• The blog of typewriter職人
• Convert C# to VB.NET
• /*If my concept is wrong ,please correct me.Thanks.*/