INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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!

*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

Database Vendor code 102

Database Vendor code 102

(OP)
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
 

RE: Database Vendor code 102

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.."

RE: Database Vendor code 102

(OP)
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
 

RE: Database Vendor code 102

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.."

RE: Database Vendor code 102

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

RE: Database Vendor code 102

Thanks LB, you are right as usual!!2thumbsup




 

profile

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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!

Resources

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