Article View: borland.public.vdbase.data.sql
Article #1622Re: Details on SELECT
From: Greg Hill
Date: Sun, 09 Nov 1997 00:00
Date: Sun, 09 Nov 1997 00:00
28 lines
1381 bytes
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-mailReferences:
<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