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

Re: Problem accessing View in VB6

From: oca(at)mvc(dot)edu(dot)ph
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-students(at)postgresql(dot)org
Subject: Re: Problem accessing View in VB6
Date: 2008-08-09 16:22:02
Message-ID: 20080810002202.pj97hcciokowcw8o@mail.mvc.edu.ph (view raw or flat)
Thread:
Lists: pgsql-students
----- 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



In response to

Responses

pgsql-students by date

Next:From: Andrew DunstanDate: 2008-08-09 17:31:54
Subject: Re: Problem accessing View in VB6
Previous:From: Andrew DunstanDate: 2008-08-09 15:46:18
Subject: Re: Problem accessing View in VB6

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