Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nadia
Starting Member
6 Posts |
 Posted - 2010-05-10 : 06:04:41
|
| • please help me out.I traced it, but I didn't find the character (I didn't write the character '-'). I ran my app on different computers, there's no problem with my app. I reformatted my computer and reinstalled all the programs, it didn't work. It still had that error...Can someone tell me what's wrong with my application (or computer)??Note: I'm using VB6 for the interface and SQLServer 2000 for the database and crystal report for report view. the error occurs when view reports using crystalr report.Diya |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-10 : 06:26:39
|
| There's a syntax error somewhere in the report's query. Post the code please, it's near-impossible to help with a script error without seeing the script.--Gail ShawSQL Server MVP |
 |
|
|
nadia
Starting Member
6 Posts |
Posted - 2010-05-10 : 12:52:05
|
| actually i am running a several software on a network i am having problem when i try to view crystal report which required date. beside all other systems are working well with all type reports only single system is giving repport error |
|
|
|
nadia
Starting Member
6 Posts |
Posted - 2010-05-10 : 12:54:12
|
| please tell me how i can send you the whole code. its not possible. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-10 : 17:05:52
|
| You need to post the SQL query that the failing report runs. Don't need anything else. Post it here, don't try and mail it to me, I'll just delete it if it's mailed.--Gail ShawSQL Server MVP |
|
|
|
nadia
Starting Member
6 Posts |
Posted - 2010-05-11 : 12:47:44
|
| great to find such immediate response from your side, but actually i find the solution. but would like to share my knowledge with you. my specific computer name have a special character - for example it was saniya-desktop. it was conflicting with SQL query.Thanks dear for your responseregards,Nadia Kouser |
|
|
|
|
|
|
line 1: Incorrect syntax near ‘-‘.