Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL error in C++Builder

Status
Not open for further replies.

LastCyborg

Programmer
Feb 7, 2003
256
MX
If I use the reserved word "OR" in a SQL String and I try to compile the program says that Acces violation at adress "an hex number" in module 'IDSQL32.DLL'.

So I think is a problem with my compiler.
Have you used OR in your SQL strings?

Or what should I do to solve it?
 
May be if you are a little more specific or put the sentence will be easy to help you :)

And i have used OR and AND in my sentences without trouble. Camilo Andrés Sánchez A.
Ingeniería de Sistemas
Pontificia Universidad Javeriana
Bogotá, Colombia
 
I had found the reason of the error
Consist in using "or" with params
like this

select *
from table
where (Field1=:param1) or (Field2=:param2)
try it and tell me what happen
 
I tried in my copiler and it works well. I think you must reinstall C++Builder.
Camilo Andrés Sánchez A.
Ingeniería de Sistemas
Pontificia Universidad Javeriana
Bogotá, Colombia
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top