[SQL] 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 - Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more.
Re: [SQL] Query Problem from FoxPro???
On 7/1/07, dBHS Jakarta <[EMAIL PROTECTED]> wrote: 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? maybe m$ knows -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
