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