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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: Problem accessing View in VB6





  ----- 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




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group