Re: Updating a table in other MS Sql 7 DB

[Franck Masson <franck.masson@BRIO.COM>]

doug,

try something like this

Begin-Procedure Main
Begin-Select -DB'DSN=Sales;UID=scott;PWD=tiger'
Ename, Job, Hiredate, Sal, Commission
  Do Insert
>From Emp
End-Select
End-procedure ! Main

Begin-procedure Insert
Begin-SQL -DB'DSN=Archive'
  insert into EmpArch (ename, job, hiredate, sal,
  commission) values (&Ename, &Job, &Hiredate, &Sal,
  &Commission)
End-SQL
End-Procedure ! Insert

it must work in version 4.3 of sqr

franck,



Doug Nichols wrote:
>
>         I'm using the version of SQR that comes with Peoplesoft 7.5, it's 
>4.3.2. I
> can read the table fine, it won't do the update to the table that is on
> another server(both NT and SQL). The server is on another physical machine.
> I'm not using an odbc string inside my sqr, i have created a linked server
> using enterprise manager in sql 7. I have all the appropriate permissions,
> because i can run the same update using the sql server query tool. But that
> doesn't use ODBC, whereas SQR does when it runs.
>
> -----Original Message-----
> From: Discussion of SQR, Brio Technology's database reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of Franck Masson
> Sent: Tuesday, January 02, 2001 3:36 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: Updating a table in other MS Sql 7 DB
>
> Doug,
>
> What version of SQR are you using ?
> in the samplew directory you have a sqr sample LoadAll.sqr that create
> table.
> Have you tested it ?
>
> Can you read and update using the same DSN ?
>
> Franck,
>
> Doug Nichols wrote:
> >
> >         Hi,
> >
> >         I am running an sqr against one database and want to select data
> from and
> > update a table in another
> >         database on a different sql server. I am runnin Sql server 7.0. I
> have set
> > up a link between both database
> >         servers and can select data fine. It's the update that fails. If I
> use
> > isql/w, the update query works fine, it just
> >         doesn't work when I run it in my sqr program.
> >         Does anybody have any tips?
> >
> >         thanks a lot,
> >         Doug
begin:          vcard
fn:             Franck Masson
n:              ;Franck Masson
org:            Brio Technology EMEA
adr;dom:        Le capitol;;55 av. des champs Pierreux;Nanterre;92000;;
email;internet: franck.masson@brio.com
title:          Sales Manager Northern Europe
tel;work:       33 1 55 69 36 00
tel;fax:        33 1 47 25 02 59
tel;home:       Mobile : 33 6 84 80 17 05
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard