Re: [pgsql-students] Problem accessing View in VB6

oca@mvc.edu.ph wrote:
>
> hi,
>
> I got problem accessing views in Visual Basic 6.
>
> Dim rsSchedule As New Recordset
> With rsSchedule
> .Open "SELECT * FROM tvwClassSchedules", dbConn, adOpenDynamic,
> adLockReadOnly
> .Close
> End With
>
> I got this error:
>
> ERROR: relation "tvwClassSchedules" does not exist;
> Error while executing the query
>
> this view exist because i can use the view in pgAdmin to display the
> records.
>
>

If that is really the name of the view then the name needs to be quoted
in double quotes. Postgres folds unquoted names to lower case.

cheers

andrew

--
Sent via pgsql-students mailing list (pgsql-students@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-students