Re: qbe files & vdbase

Article View: borland.public.vdbase.data.sql

Article #671

Back to borland.public.vdbase.data.sql Previous Next

#671

From: Ken Mayer [TeamB]
Date: Tue, 04 Aug 1998 00:00

23 lines
1179 bytes

Sam Brown <sbrown@saonet.ucla.edu> wrote:

>The SQl section reads
>
>sql = 'select * from "SBAR.DBF"'
>
>and I want
>
>sql = 'select * from "SBAR.DBF" where college1="lw"'
>
>Is this possible to do in a dmd file?  I'd like to create a new table
>based on the dmd selection criteria.

Try, rather than using the 'where' clause (which might return a
read-only table anyway), and start using the filter property of the
rowset ... you can set that in the dmd designer without any problems.

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

Technical Details

Message-ID: <35c65541.3394155@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <35C24041.4FF9@saonet.ucla.edu> <6pvhkh$rj710@forums.borland.com> <35C607A9.3526@saonet.ucla.edu>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,708abe5b29c68f09
X-Google-Attributes: gidff5a1,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: qbe files & vdbase
Date: 1998/08/04
Message-ID: <35c65541.3394155@forums.borland.com>
X-Deja-AN: 377662942
References: <35C24041.4FF9@saonet.ucla.edu> <6pvhkh$rj710@forums.borland.com> <35C607A9.3526@saonet.ucla.edu>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message