>>>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)?
Mark McCasland
Midlothian, TX USA