Thread: Problem accessing View in VB6
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.
please help.
thank you,
ocavid
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
----- Message from andrew@dunslane.net --------- Date: Sat, 09 Aug 2008 11:46:18 -0400 From: Andrew Dunstan <andrew@dunslane.net> Reply-To: Andrew Dunstan <andrew@dunslane.net> Subject: Re: [pgsql-students] Problem accessing View in VB6 To: oca@mvc.edu.ph Cc: pgsql-students@postgresql.org > > > 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 ----- End message from andrew@dunslane.net ----- Thank you, that does the job, but i guess i have to use lowercases for my views names. oscar
oca@mvc.edu.ph wrote: > > > Thank you, that does the job, but i guess i have to use lowercases for > my views names. > > I don't see why. Just use: .Open "SELECT * FROM ""tvwClassSchedules""", dbConn, adOpenDynamic, adLockReadOnly AFAIK that is the way to embed quotes in VB Strings. cheers andrew
----- Message from andrew@dunslane.net ---------
Date: Sat, 09 Aug 2008 13:31:54 -0400
From: Andrew Dunstan <andrew@dunslane.net>
Reply-To: Andrew Dunstan <andrew@dunslane.net>
Subject: Re: [pgsql-students] Problem accessing View in VB6
To: oca@mvc.edu.ph
Cc: pgsql-students@postgresql.org
>
>
> oca@mvc.edu.ph wrote:
>>
>>
>> Thank you, that does the job, but i guess i have to use lowercases
>> for my views names.
>>
>>
>
> I don't see why. Just use:
>
> .Open "SELECT * FROM ""tvwClassSchedules""", dbConn, adOpenDynamic,
> adLockReadOnly
>
>
> AFAIK that is the way to embed quotes in VB Strings.
>
> 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
----- End message from andrew@dunslane.net -----
yes, but i guess it would be more easier for me to code when they are in lower cases, i just rename the views to tvw_class_scedules.
thank you and have a great day!