Saturday, August 9, 2008

Re: [pgsql-students] Problem accessing View in VB6

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


No comments: