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 22:09:13
Message-ID: 20080810060913.ncnymtb4g0wgo4sw@mail.mvc.edu.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-students

----- Message from andrew(at)dunslane(dot)net ---------
    Date: Sat, 09 Aug 2008 13:31:54 -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:
>>
>>
>> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-students[1]
----- End message from andrew(at)dunslane(dot)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!

Links:
------
[1] http://www.postgresql.org/mailpref/pgsql-students

In response to

Browse pgsql-students by date

  From Date Subject
Next Message oca 2008-08-10 21:11:59 Implementing Trigger problem
Previous Message Andrew Dunstan 2008-08-09 17:31:54 Re: Problem accessing View in VB6