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 22:09:13
Message-ID: 20080810060913.ncnymtb4g0wgo4sw@mail.mvc.edu.ph (view raw or flat)
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

pgsql-students by date

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

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