>>>SELECT table.projectid,table.name,table.typeid,etc...
>>>
>>
>>If the field names are unique, this is not needed. However,
Name is a reserved Foxpro word, which potentially can cause some problems...
>>
>
>I usually include the table references for readability and avoiding possible conflicts in the future. I have no idea why he would get an invalid subscript error with that select statement either way.
Me neither... I also always separated last comma and semicolon with a space, but this is just a habit, not the cause of the problem, which, I believe, is already resolved :)
If it's not broken, fix it until it is.
My Blog