🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: qbe files & vdbase

#668
From: Sam Brown
Date: Mon, 03 Aug 1998 00:00
30 lines
1447 bytes
Bowen Moursund (TeamB) wrote:
> 
> >I have several qbe files from an older version of dbase that are used
> >properly in a vdbase program but I don't know how to modify the qbe
> >files in vdbase.
> 
> VdB includes a utility for converting QBEs to DMDs. Look in the VdB
> Utilities folder for Qbe2dmd.prg.
> ____
> Bowen Moursund (TeamB)
> bowen at nerds dot com
> http://lonestar.texas.net/~moursund/
> Try this help resource:
>  http://www.dejanews.com/home_ps.shtml
I did this conversion but it doesn't appear that it put the proper sql
filter condition in the dmd file.  I tried to do this after the
conversion to no avail.

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.

Sam
Technical Details
Message-ID: <35C607A9.3526@saonet.ucla.edu>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <35C24041.4FF9@saonet.ucla.edu> <6pvhkh$rj710@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,708abe5b29c68f09
X-Google-Attributes: gidff5a1,public
From: Sam Brown <sbrown@saonet.ucla.edu>
Subject: Re: qbe files & vdbase
Date: 1998/08/03
Message-ID: <35C607A9.3526@saonet.ucla.edu>
X-Deja-AN: 377572531
Content-Transfer-Encoding: 7bit
References: <35C24041.4FF9@saonet.ucla.edu> <6pvhkh$rj710@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql