Re: Update across 2 databases

While this syntax is definitely valid for PSQLv9, I'm not sure if this
is valid syntax for the PSQL2000 engine or not.
BB

Darren Woodbrey wrote:

> I am trying to run this staement from pervasive control center on
> Pervasive.SQL 2000i:
>
> UPDATE HPFYE.RM00103
> SET HPFYE.RM00103.TTLSLLYR = HPFSAMPLE.RM00103.TTLSLYTD
> WHERE HPFYE.RM00103.CUSTNMBR = HPFSAMPLE.RM00103.CUSTNMBR
>
>
> I am getting the following error:
>
> ODBC Error: SQLSTATE = 37000, Native error code = 0
> Syntax Error: UPDATE HPFYE.RM00103
>
> SET HPFYE.RM00103.<< ??? >>TTLSLLYR = HPFSAMPLE.RM00103.TTLSLYTD
>
> WHERE HPFYE.RM00103.CUSTNMBR = HPFSAMPLE.RM00103.CUSTNMBR
>
> Can someone help? Thanks!

.

Relevant Pages

  • Re: Need help with Field Codes
    ... All of the braces, including the internal ones, need to be inserted by Word, ... I was able to get past the Syntax Error problem I reported ... I want the field code to be replaced by the current year plus 1. ...
    (microsoft.public.word.newusers)
  • Re: Need help with Field Codes
    ... specifically in the top left hand label. ... I was able to get past the Syntax Error problem I reported ... I want the field code to be replaced by the current year plus 1. ...
    (microsoft.public.word.newusers)
  • Re: Need help with Field Codes
    ... Word MVP FAQ site: http://word.mvps.org ... I was able to get past the Syntax Error problem I reported ... I want the field code to be replaced by the current year plus 1. ...
    (microsoft.public.word.newusers)
  • Re: Syntax checker wtf?
    ... Ruby would give you a syntax error on a multiline ... SyntaxError: compile error ...
    (comp.lang.ruby)
  • Re: Syntax (was: Perfrom Thru
    ... "This statement has violated the limits of this compiler" ... these are syntax violations in the Standard's definition of them. ... > whether the problem is a compiler limitation or it is a syntax error, ... >> Then not "source violates the SYNTAX rules of the Standard" ...
    (comp.lang.cobol)