Article View: borland.public.intrabuilder.data.sql
Article #28Re: SQL Queries to Paradox or dBase files
From: N. van Dijk
Date: Mon, 29 Dec 1997 00:00
Date: Mon, 29 Dec 1997 00:00
28 lines
1178 bytes
1178 bytes
On 29 Dec 1997 20:54:09 GMT, "John J. Bowman" <desslock@comcat.com>
wrote:
>I am still in the learning stages of Intrabuilder as an application and am
>having serious problems with using SQL queries in any of my test
>applications. The problems appear when I use the WHERE clause of a SELECT
>statement. On simple Paradox / dBase tables, SQL statements such as:
>
> SELECT * FROM "PassTabl.db"
>
>return the entire table, as it should. However, once I change this to the
>following:
>
> SELECT * FROM "PassTabl.db" WHERE ("GroupID" = '12345')
>
(cut)
Hi John,
I think you should quit the quotes when you reference the database
field:
SELECT * FROM "PassTabl.db" WHERE (GroupID = '12345')
Good luck,
Niels
Technical Details
Message-ID:
<34a82586.44455985@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bd149b$9f988060$cb02ccc0@j-bowman>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 101d9a,fbb1df6c87df1f6a X-Google-Attributes: gid101d9a,public From: Niels@lx.student.wau.nl (N. van Dijk) Subject: Re: SQL Queries to Paradox or dBase files Date: 1997/12/29 Message-ID: <34a82586.44455985@forums.borland.com> X-Deja-AN: 311148500 References: <01bd149b$9f988060$cb02ccc0@j-bowman> Organization: None Newsgroups: borland.public.intrabuilder.data.sql