Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 3E3569FBF02 for ; Wed, 4 Jul 2007 03:48:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 24799-05 for ; Wed, 4 Jul 2007 03:48:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web32802.mail.mud.yahoo.com (web32802.mail.mud.yahoo.com [68.142.206.32]) by postgresql.org (Postfix) with SMTP id B2E559FBEEC for ; Wed, 4 Jul 2007 03:48:13 -0300 (ADT) Received: (qmail 2722 invoked by uid 60001); 4 Jul 2007 06:48:12 -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=F8Y8mpPhwhPTb75AAy7UxZwpABJxr0PwS1SKpLmvKtNAkEcflQe2QOA0ukozE2DMF1g9iuwj2M8aCf906A3O21TPyVnm/YEPDA1zoMScD9Sj+Y0HJZiUPZ/wIaelw54VK6rAwdSoGm3hEMezbMAAniAehAtTZwJyjf+62P1p4J0=; X-YMail-OSG: i0ZgssMVM1nuOgLtJdtaM_Ia50mnj_BNbK7Lh9cKaAQf5qtLSscp6sdKxzk8RTcQAiOk0owJbKMUqNfP3gB7wnWHH7p5IIHAXRUkEZg2gynOuCWh1_BNenNt.ZBjZA-- Received: from [202.158.17.34] by web32802.mail.mud.yahoo.com via HTTP; Tue, 03 Jul 2007 23:48:12 PDT Date: Tue, 3 Jul 2007 23:48:12 -0700 (PDT) From: dBHS Jakarta Subject: Re: Query Problem from FoxPro??? To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1049860358-1183531692=:99328" Content-Transfer-Encoding: 8bit Message-ID: <847675.99328.qm@web32802.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/29 X-Sequence-Number: 28764 --0-1049860358-1183531692=:99328 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Dear All, It turns out that, column "is_pilih" was written with "Is_Pilih". PostgreSQL column name is case sensitive! After I change the column name to "is_pilih" everything's showed up! Another NEW Question arose: "Why the is_pilih data type become Character when it displayed in VFP?" Anybody can help? T.I.A. Regards, djDevX Query Problem from FoxPro??? --------------------------------- From: dBHS Jakarta To: pgsql-sql ( at ) postgresql ( dot ) org Subject: Query Problem from FoxPro??? Date: Sat, 30 Jun 2007 20:47:04 -0700 (PDT) --------------------------------- 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 --------------------------------- Luggage? GPS? Comic books? Check out fitting gifts for grads at Yahoo! Search. --0-1049860358-1183531692=:99328 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Dear All,

It turns out that, column "is_pilih" was written with "Is_Pilih". PostgreSQL column name is case sensitive! After I change the column name to "is_pilih" everything's showed up!

Another NEW Question arose: "Why the is_pilih data type become Character when it displayed in VFP?"

Anybody can help?

T.I.A.


Regards,


djDevX




Query Problem from FoxPro???

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

Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search. --0-1049860358-1183531692=:99328--