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: (view raw or whole 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.



In response to


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-2015 The PostgreSQL Global Development Group