🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Problems with SQL in VDB 7

#1478
From: Ken Mayer
Date: Fri, 12 Dec 1997 00:00
20 lines
1219 bytes
Gerald Fay wrote:
> The sql designer in VDB7 is giving me problems. And as you know SQL is
> where it is at in VDB7.

Gerald -- just a point -- you don't _have_ to use SQL commands much, and
don't need to use the SQL builder or .SQL files. It's certainly a way to
do anything in dBASE, but it's (like usual) not the only way ...

> My greatest difficulty is the inablity to get any return with using the
> LIKE compare.

> For example under criterion field I enter a character field by dragging
> from the database, choose like as the compare and enter a value in the
> third column. When running the query I get notified "Database Error.
> Operation not applicable".

What does the SQL look like that's being streamed out? 

Ken
Technical Details
Message-ID: <349166DE.339E@corp.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <MPG.efb0429f384b2dc989682@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,be82ae786d2066b7
X-Google-Attributes: gidff5a1,public
From: Ken Mayer <kmayer@corp.borland.com>
Subject: Re: Problems with SQL in VDB 7
Date: 1997/12/12
Message-ID: <349166DE.339E@corp.borland.com>
X-Deja-AN: 297584745
References: <MPG.efb0429f384b2dc989682@forums.borland.com>
Reply-To: kmayer@corp.borland.com
Organization: Borland, International
Newsgroups: borland.public.vdbase.data.sql