BorlandTalk.com

Cenk · Guest

Hi,

I m using BDS 2006, MS SQL Server 2000. I was using TQuery to do DB
operations like select, insert..etc. I decided to call stored procedures
instead of using TQuery directly from BDS2006. Before , when i was writing
statements like below;
....
String table = "MONTH1(EUR/USD)";
CountQuery->SQL->Add("select column1 from ["+table+"]");
CountQuery->Open();
....
Its OK. There is no table name error, but when i call a Stored procedure
instead of using the code segment above, it gives error, because of the "/".
How can i fix this? I wanna use those characters (/,-).

thanks

MarkR · Guest

I trust you will be the only person maintaining the code you are producing?
If some else picked up your code, they would probably look at the table name
and think EUR divided by USD (especially c++ programmers)

I don't know what to suggest, other than finding an entirely different
mechanism for querying the database. If the compiler tells you have an error
because you are using an invalid character, then you must either use a
different compiler, or the easy option, stick to the normal standards when
naming things, alphanumeric and underscore characters only.

No help, but just you are asking the same question again.

Cenk · Guest

I just wanted to know, why it gave error when i used STORED PROCEDURE?