Re: Query Problem from FoxPro???
| От | dBHS Jakarta |
|---|---|
| Тема | Re: Query Problem from FoxPro??? |
| Дата | |
| Msg-id | 847675.99328.qm@web32802.mail.mud.yahoo.com обсуждение |
| Ответ на | Query Problem from FoxPro??? (dBHS Jakarta <dbhsnet@yahoo.com>) |
| Список | pgsql-sql |
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
Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search.
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 <dbhsnet ( at ) yahoo ( dot ) com>
- 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.
В списке pgsql-sql по дате отправления: