Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 2A6249FB4CF
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun,  1 Jul 2007 00:47:11 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 40584-04 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun,  1 Jul 2007 00:47:05 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web32807.mail.mud.yahoo.com (web32807.mail.mud.yahoo.com
	[68.142.206.37]) by postgresql.org (Postfix) with SMTP id 7CC1A9FB3EE
	for <pgsql-sql@postgresql.org>; Sun,  1 Jul 2007 00:47:05 -0300 (ADT)
Received: (qmail 56376 invoked by uid 60001); 1 Jul 2007 03:47:04 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=wH1x2XVcSzU2WXpqLP39pcPynxf3kNDmlNHpFqWwWu+30BpApyKZGTVx75RNbXHSilEatm/yvzZpBL50FeVoPGNwcdCBDTNVt9FnhUhZEnrE90EDq2K3fuPNZHwbz77me4LtNikhyWqZiSOLVVv8dzJtIRDRqnrInrHcQTt77ZU=;
X-YMail-OSG: 
 wmUdGGgVM1kXR91dRBp68EvychQahzSLVjTA7rj65nsmg2y6cmcL2Cm8msqqa.Xu865Ty8lxeyKYBkwX1cPJ_mixtRYuJjR4ru0fE3oXfJFhTo3DxX.80woSd74BkQ--
Received: from [202.158.113.79] by web32807.mail.mud.yahoo.com via HTTP;
	Sat, 30 Jun 2007 20:47:04 PDT
Date: Sat, 30 Jun 2007 20:47:04 -0700 (PDT)
From: dBHS Jakarta <dbhsnet@yahoo.com>
Subject: Query Problem from FoxPro???
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-779650544-1183261624=:54788"
Content-Transfer-Encoding: 8bit
Message-ID: <645011.54788.qm@web32807.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.757 tagged_above=0 required=5 tests=BAYES_00=-2.599,
	DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708,
	DNS_FROM_RFC_WHOIS=1.447, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200707/1
X-Sequence-Number: 28736

--0-779650544-1183261624=:54788
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Dear all,
  
 I am try to migrate from VFP back-end database to  PostgreSQL.
  
 Table: mst_lang 
 Columns:
 lang_id   Char (2)
 lang_nm Char (20)
 is_pil      Boolean
  
 I try to query from FoxPro via ADODB,  Recordset using this SelectCmd:
 "SELECT * FROM mst_lang"
 Everything is showed.
  
 When I try to query using:
 "SELECT lang_id, lang_nm, is_pil FROM  mst_lang"
 No Results showed...
  
 Does anybody know what's the problem  is?
  
  
 Regards,
  
 djDevX

       
---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. 
--0-779650544-1183261624=:54788
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div><font face="Arial" size="2">Dear all,</font></div> <div>&nbsp;</div> <div><font face="Arial" size="2">I am try to migrate from VFP back-end database to  PostgreSQL.</font></div> <div>&nbsp;</div> <div><font face="Arial" size="2">Table: mst_lang </font></div> <div><font face="Arial" size="2">Columns:</font></div> <div><font face="Arial" size="2">lang_id&nbsp;&nbsp; Char (2)</font></div> <div><font face="Arial" size="2">lang_nm Char (20)</font></div> <div><font face="Arial" size="2">is_pil&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Boolean</font></div> <div>&nbsp;</div> <div><font face="Arial" size="2">I try to query from FoxPro via ADODB,  Recordset&nbsp;using this SelectCmd:</font></div> <div><font face="Arial" size="2">"SELECT * FROM mst_lang"</font></div> <div><font face="Arial" size="2">Everything is showed.</font></div> <div>&nbsp;</div> <div><font face="Arial" size="2">When I try to query using:</font></div> <div><font face="Arial" size="2">"SELECT lang_id, lang_nm, is_pil
 FROM  mst_lang"</font></div> <div><font face="Arial" size="2">No Results showed...</font></div> <div>&nbsp;</div> <div><font face="Arial" size="2">Does anybody know what's the problem  is?</font></div> <div>&nbsp;</div> <div>&nbsp;</div> <div><font face="Arial" size="2">Regards,</font></div> <div>&nbsp;</div> <div><font face="Arial" size="2">djDevX</font></div><p>&#32;
      <hr size=1>Take the Internet to Go: Yahoo!Go puts the <a href="http://us.rd.yahoo.com/evt=48253/*http://mobile.yahoo.com/go?refer=1GNXIC">Internet in your pocket:</a> mail, news, photos & more. 
--0-779650544-1183261624=:54788--