Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View definiton has been changed error
Message
 
To
03/12/2001 15:51:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00588888
Message ID:
00588913
Views:
22
I don't think so. I've been using it in a bunch of similar views without a problem.

>Roi,
>
>Could it be the parameter reference to ThisForm? I think someone mentioned in another thread that this could cause problems. Try to use a variable instead.
>
>HTH
>>I have a view called JobContact_2. If I use the view and browse it from the command window it works fine.
>>
>>If I put it in the DE of a form I get a "View definiton has been changed" error when it is requeried. If I remove the following from the view it works fine:
>>
	Join workman_MAIN!lu_Catagory  ;
>>	ON  JobContact.fk_Type_id = lu_Catagory.pk_id
>>
>>Anybody know what would cause this?
>>
>>Here is the full view code:
>>
>>
Create Sql View "JOBCONTACT_2" ;
>>	AS Select  AddressBook.Company, ;
>>	Iif(Empty(AddressBook.Prefix), "", Alltrim(AddressBook.Prefix) + " ") + ;
>>	Iif(Empty(AddressBook.FirstName), "", Alltrim(AddressBook.FirstName) + " ") + ;
>>	IIF(Empty(AddressBook.MiddleName), "", Alltrim(AddressBook.MiddleName) + " ") + ;
>>	IIF(Empty(AddressBook.LastName), "", Alltrim(AddressBook.LastName) + " ") + ;
>>	IIF(Empty(AddressBook.Suffix), "", Alltrim(AddressBook.Suffix)) As ConName, ;
>>	lu_Catagory.cDesc, JobContact.* ;
>>	FROM  workman_MAIN!JobContact  ;
>>	LEFT Outer Join workman_MAIN!AddressBook  ;
>>	ON  JobContact.fk_ab_id = AddressBook.ab_id  ;
>>	Join workman_MAIN!lu_Catagory  ;
>>	ON  JobContact.fk_Type_id = lu_Catagory.pk_id  ;
>>	WHERE JobContact.fk_job_id = ?Thisform.ncurid  ;
>>	ORDER By Company
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform