From: dBHS Jakarta <dbhsnet@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Query Problem from FoxPro???
Date: Sat, 30 Jun 2007 20:47:04 -0700 (PDT)
Message-ID: <645011.54788.qm@web32807.mail.mud.yahoo.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dbhsnet@yahoo.com
Subject: Re: Query Problem from FoxPro???
In-Reply-To: <645011.54788.qm@web32807.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox