🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Details on SELECT

#1622
From: Greg Hill
Date: Sun, 09 Nov 1997 00:00
28 lines
1381 bytes
> To get you started I suggest you down load Borland's TI (Tech Info) 2718,
 
I'll check that out.  I'm doing stuff with it right now but I just feel 
like there is allot to learn and I was not finding it where I usually 
find things I need.

One of the things that I really need to know is how to make updateable 
queries views I don't really want the complex queries to read only, and 
that is what I'm finding out so far.

Also it does not seem possible to do subqueries example:

SELECT Leads.Lname, ;
       Leads.phone, ;
       Selectee.Client_ID, ;
       Selectee.member_no, ;
       Selectee.response, ;
       selectee."date" ;
       FROM Leads, selectee
       WHERE IN (SELECT * FROM leads WHERE Leads.Client_ID=:mClient_ID)

I get the error message saying "Capability not supported"

When I see that message, can I be sure that my syntax is correct and 
that it just simply can not be done in VDB??

Thanks, Greg
Technical Details
Message-ID: <34669F79.E5F@n2.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <345F12B6.6FEE@n2.net> <01bced1d$f9a97c80$1030f489@jyuzamas.robins.af.mil>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,752e9937407662f3
X-Google-Attributes: gidff5a1,public
From: Greg Hill <ghill@n2.net>
Subject: Re: Details on SELECT
Date: 1997/11/09
Message-ID: <34669F79.E5F@n2.net>
X-Deja-AN: 288364481
References: <345F12B6.6FEE@n2.net> <01bced1d$f9a97c80$1030f489@jyuzamas.robins.af.mil>
Organization: Serv-U Computers
Newsgroups: borland.public.vdbase.data.sql