Crystal Reports 8.5 - SQL Expressions

From: "Juan Ignacio Lalla" <juanlalla(at)yahoo(dot)com(dot)ar>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Crystal Reports 8.5 - SQL Expressions
Date: 2006-07-12 13:23:53
Message-ID: 20060712132758.72FDC9FB2D5@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm using Crystal Reports 8.5 against PostgreSQL Database Server 8.1.
The thing is that when I try to use an SQL Expression Field in Crystal,
doesn't work (it does work when I don't use it).

Returns the following error:
Error in compiling SQL Expression:
Cannot find parser table file(s).

The expression is the folowing:
{fn SUBSTRING( TABLE."column", 1, 250 )}

(column datatype is "text")

This sentence worked against other databases, but not against PostgreSQL...

Has anybody pass through this situation?

Thanks for your assistance,

Juan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Uma Srinivasan 2006-07-12 13:29:29 disk space usage
Previous Message Merlin Moncure 2006-07-12 13:15:38 Re: pgsql vs mysql