Re: [sqr-users] Using SQR version 8 and receiving the following message

["Edwin Hommes" <hommes@bluewin.ch>]

Michael

You may want to check your configuration file on the server side. It may
tell SQR it is running on a Sybase DB. (rdbms.sqc)
Should be set correctly when installing PS though.
Since underscores are in the database world considered wildcards, you can
not translate spaces with underscores. You could use any other character,
with the exception of *. (also a wildcard)
In SQR you can deal with (trailing) spaces by using the command
let new_var = rtrim(old_var, ' ')
thus cutting of any spaces from the right to the left. This will leave you
will a NULL (empty) variable if the source variable contained spaces only.
Peoplesoft (most systems) do not like tables with spaces in their names. I'd
say that SQR, Peoplesoft as well as Ms SQL Server 2000 will have problems at
querying that table

Hope this helps,
Edwin


----- Original Message -----
From: "Horn, Michael (CXO Colorado Springs)" <Mike.Horn@hp.com>
To: <sqr-users@sqrug.org>
Sent: Friday, April 11, 2003 2:41 PM
Subject: [sqr-users] Using SQR version 8 and receiving the following message


Hello all,

I am currently a new user to SQR and we are using version 8.  I am using a
Microsoft SQL 2000 Database and I receive the following error when trying to
use SQR:

[MERANT] [ODBC MS SQL Server 6 driver][Microsoft SQL Server] Could not find
stored procedure 'sp_start_xact!'


Looking up the sp_start_xact procedure, I cannot find anything for it in MS
SQL, but it shows up as a SYBASE procedure when looking under search engines
on the web.  Could the problem be that the drivers that were provided are
for version 6 and not version 8?

Also, we have some tables that have field names with spaces.  Does anyone
know how to get past this problem in SQR?  I have asked our SQL gurus if
there is anything could be done to translate a space to and underscore and
they have said no.  Barring going into the database and updating every field
name to include an underscore.  One of the tables has a space in it also.
Can this be parsed too?

Thanks for your help in advance.


Michael Horn
HP Services
CCHS Division
(719) 592 - 5043

 <<Horn, Michael.vcf>>



----------------------------------------------------------------------------
----


> Here was a non admissible message part of 'text/x-vcard' MIME type. It
> has been automatically discarded before sending the message to the
> list.
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.467 / Virus Database: 266 - Release Date: 01/04/2003

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users