Postgres Pro
Downloads
Home   >   mailing lists

Thread: Query Problem from FoxPro???

Query Problem from FoxPro???

From
dBHS Jakarta
Date:
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: Query Problem from FoxPro???

From
"Jaime Casanova"
Date:
On 7/1/07, dBHS Jakarta <dbhsnet@yahoo.com> 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

Re: Query Problem from FoxPro???

From
dBHS Jakarta
Date:
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.