Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening tables
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01335272
Message ID:
01335467
Views:
17
I don't see any views in the code you posted. What view it's complaining about?

>I have a problem. what i am trying to do is simple enough, I have 2 call systems, both held in seperate folders but build on the same framework, they use tables of the same name, but in different folders, etc. I need to pass details from one to the other, befor ei was creating a dbf with 1 line and saving it into a sub folder. then a timer in the other program would import it, only problem here was that it the users was doing something in the second call system this would cause an error. So what i decided to do was this
>
>mlocation = ALLTRIM(TBD_valx3) + "zfnwc"    && Getting the file location
>SELECT 0
>USE &mlocation ALIAS 'NWC2'
>SELECT NWC2
>SEEK lclcalnum ORDER CMA_calnum
>IF FOUND()
>	* should not happen - do nothing, as call already there
>ELSE
>	* add in the details to the limited system
>	SELECT NWC
>	SCATTER MEMO MEMVAR	
>	
>	SELECT NWC2
>	APPEND BLANK
>	GATHER MEMVAR MEMO
>	....   && have a few replace field1 with " " lines in here
>	SELECT NWC2
>	USE
>
>this works but on the save of the form there is a requery that is necessary and it gives me this error.
>1542/Base table fields have been changed and no longer match view
>Now these tables in both folders are fine but this error always comes up. any ideas?
>~M
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform