>I am using vfp 5.0a to create a local view file. The view file included 7 tables. One of the tables was master table with one primary key. The others have candiate keys. While I finished the creation and close the view designer, a error " SQL:Column "FIELDNAME1" not found" shown on the screen. I checked the tables. I didn't find anything wrong. Each table had the FIELDNAME1. The FIELDNAME1 was indexed already. Any idea?
>
>Sunny
Hi Yung Hung
I encountered that problem at the beginning of my experience with VFP5 and as I red in the replies to your message, I'm sure it's a bug.
What Erik told you is right but I think to remember that sometimes (random I suppose) the same error appears also using the code generated by the wizard.
Now , in my sql statement I'm using the VFP 3 syntax : No Inner Join but a simple 'where ' statements and it seems to work fine
Ciao Alessio
Previous
Next
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