pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery Problem from FoxPro???
3+ messages / 2 participants
[nested] [flat]
* Query Problem from FoxPro???
@ 2007-07-01 03:47 dBHS Jakarta <dbhsnet@yahoo.com>
2007-07-01 04:44 ` Re: Query Problem from FoxPro??? Jaime Casanova <systemguards@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: dBHS Jakarta @ 2007-07-01 03:47 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query Problem from FoxPro???
2007-07-01 03:47 Query Problem from FoxPro??? dBHS Jakarta <dbhsnet@yahoo.com>
@ 2007-07-01 04:44 ` Jaime Casanova <systemguards@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Jaime Casanova @ 2007-07-01 04:44 UTC (permalink / raw)
To: dBHS Jakarta <dbhsnet@yahoo.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Query Problem from FoxPro???
@ 2007-07-04 06:48 dBHS Jakarta <dbhsnet@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: dBHS Jakarta @ 2007-07-04 06:48 UTC (permalink / raw)
To: 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
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-07-04 06:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-01 03:47 Query Problem from FoxPro??? dBHS Jakarta <dbhsnet@yahoo.com>
2007-07-01 04:44 ` Jaime Casanova <systemguards@gmail.com>
2007-07-04 06:48 Re: Query Problem from FoxPro??? dBHS Jakarta <dbhsnet@yahoo.com>
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