🚀 go-pugleaf

Greg

SQL has a habit of giving misleading error messages, but in this case this
is not supported.

Joe
-- 
Joe  < jyuzamas@wrdiss1.robins.af.mil or jyuzamas@sprynet.com >

Greg Hill <ghill@n2.net> wrote in article <34669F79.E5F@n2.net>...
> > 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
>