Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

olrac (MIS) (OP)
6 Mar 12 19:03
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 (TechnicalUser)
7 Mar 12 0:16
Which database?

How is RCC.RGCC_Code defined in the table?

profile

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

olrac (MIS) (OP)
7 Mar 12 11:51
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 (TechnicalUser)
8 Mar 12 0:29
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)

profile

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

lbass (TechnicalUser)
8 Mar 12 16:54
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 (TechnicalUser)
10 Mar 12 18:15
Thanks LB, you are right as usual!!2thumbsup




 

profile

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close