General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Terry
That was just an example with the typo. that's not the problem.
Thanks
Mo
>Mo
>
>Not sure if this is a typo of yours (and just a generic example) but
>
>colname IN (select xxxx for tablexxx where colyy = ?xxx)
>
>shouldn't it be
>
>colname IN (select xxxx FROM tablexxx where colyy = ?xxx)
>
>Terry
>
>
>>Using VFP7, I get this error "SQL syntax is too complex" when I try to modify a view.
>>The only thing that maybe the problem is I have in teh WHERE clause an IN that looks like
>>
>>colname IN (select xxxx for tablexxx where colyy = ?xxx)
>>
>>It seems like the view works fine but is this a bug???
>>
>>Thanks
>>Mo
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only