>>>>>Can anybody tell me why this is invalid? I can run it, I just can't save it.
>>>>>
>>>>>
>>>>>SELECT Selections.*, Catalogue.cproduct;
>>>>> FROM catalogue!catalogue INNER JOIN catalogue!selections ;
>>>>> ON Catalogue.iid = Selections.iproductid
>>>>
>>>>Try this:
>>>>
>>>>CLOSE ALL
>>>>OPEN DATABASE CATALOGUE EXCL
>>>>DROP VIEW ThisView
>>>>VALIDATE DATABASE RECOVER
>>>>PACK DATABASE
>>>>
>>>>CREATE SQL VIEW ThisView AS ... < your code from above >
>>>
>>>Thanks, Mark. That didn't work. This is a pretty straight-forward join. I wonder what the problem is?
>>
>>After the error is generated, what do the elements of the array laError return from aerror(laError)?
>
>Not alot of info here:
Jim --
Taking off from Dan's note, I wonder if the view designer is getting confused by both the DBC and a table sharing the same name. Can you drop the DBC reference in your application, and does that allow the view to save?
Jay