Error in Query execution

[Nibu babu thomas]

tejaswini.g wrote:

CStirng Str="tejaswini"; SQLCHAR SQL[] = "SELECT EmployeeID,Salary FROM EMPLOYEE WHERE EmpName=Str";

CString Str;
Str.Format( _T( "SELECT EmployeeID,Salary FROM EMPLOYEE WHERE EmpName=%s" ), _T( "tejaswini" ));

SQLCHAR SQL[] = Str; // Maybe you will have to convert this Str to SQLCHAR type.

---

Nibu thomas A Developer Programming tips[^]  My site[^]

[toxcct]

tejaswini.g wrote:

What is the wrong with my code?

tejaswini.g wrote:

"SELECT EmployeeID,Salary FROM EMPLOYEE WHERE EmpName=Str";

because the SQL engine is executing such query, as is. it is then searching Str as the Employee name...

---

TOXCCT >>> GEII power

[VisualCalc 3.0  updated ][Flags Beginner's Guide  new! ]

[pelaez]

Si Str va en el texto entrecomillado el ordenador lo interpreta como texto y no como tu variable. Desconozco como funciona un SQLCHAR, si el texto fuera un CString deberías ponerlo así... "SELECT EmployeeID, Salary FROM EMPLOYEE WHERE EmpName='" + Str + "´"; En este caso si cambiará Str por el valor de tu variable, además recuerda que en la sentencia Where EmpName= algo, ese algo tiene que ir entre comillas simples. Espero haberte ayudado.

[toxcct]

Hablamos inglés aquì señor... :(

---

TOXCCT >>> GEII power

[VisualCalc 3.0  updated ][Flags Beginner's Guide  new! ]

[Naveen]

:confused:

nave

[toxcct]

i told him that we were speaking english here !

---

TOXCCT >>> GEII power

[VisualCalc 3.0  updated ][Flags Beginner's Guide  new! ]

[Nibu babu thomas]

toxcct wrote:

i told him that we were speaking english here !

Quite obviously.:)

---

Nibu thomas A Developer Programming tips[^]  My site[^]

[Naveen]

but which language was that?

nave

[vc _fragrance]

Thank you. I tried it and am getting error Cannot convert from class CString to unsigned char[]; I tried to convert 'Str' to char variable as shown below; CString csStr(Str); char* pbuff = csStr.GetBuffer(csStr.GetLength()); SQLCHAR SQL[] = "SELECT EmpID,Salary FROM Employee WHERE EmpName='"+pbuff +"'"; Now i am getting the error as "Can not add two pointers" Plz help me to solve the problem. Thanks in advance.

[toxcct]

spanish buddy :cool:

---

TOXCCT >>> GEII power

[VisualCalc 3.0  updated ][Flags Beginner's Guide  new! ]

[Naveen]

gracias:)

nave

[toxcct]

tejaswini.g wrote:

SQLCHAR SQL[] = "SELECT EmpID,Salary FROM Employee WHERE EmpName='"+pbuff +"'";

change into this : SQLCHAR SQL[] = CString("SELECT EmpID,Salary FROM Employee WHERE EmpName='") + csStr + "'";

---

TOXCCT >>> GEII power

[VisualCalc 3.0  updated ][Flags Beginner's Guide  new! ]