Query Problem from FoxPro???

From: dBHS Jakarta <dbhsnet(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Query Problem from FoxPro???
Date: 2007-07-01 03:47:04
Message-ID: 645011.54788.qm@web32807.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jaime Casanova 2007-07-01 04:44:00 Re: Query Problem from FoxPro???
Previous Message Gregory Stark 2007-06-30 04:15:43 Re: percentages of a column