>>>>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:
LAERROR Pub A
( 1, 1) N 1498 ( 1498.00000000)
( 1, 2) C "SQL SELECT statement is invalid."
( 1, 3) C
( 1, 4) C
( 1, 5) C
( 1, 6) C
( 1, 7) C