Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Incorrect syntax near 'VERSION'

2 posts in PB Infomaker Report Writer Last posting was on 1999-06-08 01:54:11.0Z
Connie Felt Posted on 1999-06-07 20:46:56.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 07 Jun 1999 13:46:56 -0700
From: Connie Felt <cfelt@ga.wa.gov>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
Subject: Incorrect syntax near 'VERSION'
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 6
Message-ID: <348_375C2FC0.CD99029B@ga.wa.gov>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6239
Article PK: 240176

We are getting the following error message trying create a query.

Incorrect syntax near 'VERSION'

PBSELECT(VERSION(400) TABLE(NAME="appl_history_lines")
TABLE(NAME="ar.open.items") etc....


Terry Dykstra Posted on 1999-06-08 01:54:11.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Incorrect syntax near 'VERSION'
Date: Mon, 7 Jun 1999 19:54:11 -0600
Lines: 18
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700
Message-ID: <348_BW$ezEVs#GA.205@forums.sybase.com>
References: <348_375C2FC0.CD99029B@ga.wa.gov>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.infomaker.general:6234
Article PK: 240169

The message looks strange. In one case you have underscores, the other
periods.
In your report try converting to syntax and see if that helps. When using
syntax mode, make sure there is a extra space at the end of a line.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.

Connie Felt wrote in message <375C2FC0.CD99029B@ga.wa.gov>...
>We are getting the following error message trying create a query.
>
>Incorrect syntax near 'VERSION'
>
>PBSELECT(VERSION(400) TABLE(NAME="appl_history_lines")
>TABLE(NAME="ar.open.items") etc....
>