Re: Problem accessing View in VB6

[oca(at)mvc(dot)edu(dot)ph]

----- Message from andrew(at)dunslane(dot)net ---------
    Date: Sat, 09 Aug 2008 11:46:18 -0400
    From: Andrew Dunstan <andrew(at)dunslane(dot)net>
Reply-To: Andrew Dunstan <andrew(at)dunslane(dot)net>
 Subject: Re: [pgsql-students] Problem accessing View in VB6
      To: oca(at)mvc(dot)edu(dot)ph
      Cc: pgsql-students(at)postgresql(dot)org


> 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
>
> --
> Sent via pgsql-students mailing list (pgsql-students(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-students


----- End message from andrew(at)dunslane(dot)net -----

Thank you, that does the job, but i guess i have to use lowercases for  
my views names.

oscar