Database Vendor code 102

[olrac]

Hi,

I am trying to pass a string parameter 15 characters long:

RCC.RGCC_Code = {?Cost_centre}.

The string I type in is 91.71.11520000 but I keep getting the error message database vendor code 102.
Any ideas?

I use Crystal Version 11.0
Thanks

 

[Turkbear]

Which database?

How is RCC.RGCC_Code defined in the table?



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[olrac]

Hi Turkbear,

The data is from our scheduling application (kronos ) and data is in our data warehouse (MS SQL server).

The field is defined as char(24), not null.


I wrote the query in SQL (MS 2005 Management server) and placed it in Crystal.

I use other parameters (date, employee numbers...) and they have worked so far.

Thanks

 

[Turkbear]

Hi,
This site:

http://www.sql-server-helper.com/error-messages/msg-1-500.aspx

sems to indicate a syntax error - try this in your SQL command:

RCC.RGCC_Code = "{?Cost_centre}"


Possibly the data is not being quoted as a string by Crystal when used in a command (your self-written SQL Query)



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

If this is in a command, it should be single quotes (as Turkbear will remember when I say this, but good catch, Turkbear...):

RCC.RGCC_Code = '{?Cost_centre}'

-LB

 

[Turkbear]

Thanks LB, you are right as usual!!








To Paraphrase:"The Help you get is proportional to the Help you give.."