Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ugur YILMAZ
  Where is Ugur YILMAZ?
 Istanbul
 Turkey
 Ugur YILMAZ
 To: Emerson Reed
  Where is Emerson Reed?
 Americana - SP
 Brazil
 Emerson Reed
 Tags
Subject: RE: Date in a CA (PostgreSQL using ADO)
Thread ID: 288970 Message ID: 288975 # Views: 39 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, December 27, 2010 1:31:40 PM         
   


> Hi Folks!
> I'm having a problem with a Date field in a PostgreSQL 9 database that is handled with a CA in VFP 9.
> Using ODBC, I'm converting the date using a function in ConversionFunc that returns a date string like this: YYYY-MM-DD and it's working like a charm.
> Using ADO, this isn't woking.
> Any idea on how to solve this?
>
> Thanks a lot!
>
> Emerson Santon Reed
> http://weblogs.foxite.com/emersonreed
> http://emersonreed.spaces.live.com

Hi Emerson;

If I remember well; you need PostgreSQL OleDbProvider for using ADO in VFP.


http://www.postgresql.org/about/news.1153

http://www.google.com.tr/search?source=ig&hl=en&rlz=1G1ACAW_TRTR319&q=PostgreSQL+OleDB&btnG=Google'da+Ara&aq=f&oq=

Ugur
Amateur Programmer
VFP 9 SP2, Win7 64 Bit

ENTIRE THREAD

Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/27/2010 12:28:44 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by Ugur YILMAZ @ 12/27/2010 1:31:40 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/27/2010 2:02:42 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by Ugur YILMAZ @ 12/28/2010 11:44:45 AM
RE: Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/28/2010 1:43:30 PM
RE: Date in a CA (PostgreSQL using ADO) Posted by M. Tanveer Ul Hassan Shaheen @ 12/29/2010 8:56:55 AM
RE: Date in a CA (PostgreSQL using ADO) Posted by Emerson Reed @ 12/30/2010 5:44:17 PM