Skip site navigation (1) Skip section navigation (2)

Re: Problem accessing View in VB6

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: oca(at)mvc(dot)edu(dot)ph
Cc: pgsql-students(at)postgresql(dot)org
Subject: Re: Problem accessing View in VB6
Date: 2008-08-09 15:46:18
Message-ID: 489DBBCA.3040303@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-students

oca(at)mvc(dot)edu(dot)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

In response to

Responses

pgsql-students by date

Next:From: ocaDate: 2008-08-09 16:22:02
Subject: Re: Problem accessing View in VB6
Previous:From: ocaDate: 2008-08-09 14:15:16
Subject: Problem accessing View in VB6

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group