Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Opening tables
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01335272
Message ID:
01335575
Vues:
23
Sergey,
in my program there is a view with an alias of V_NMC. it is sometimes used and other times i used the file directly through the alias, not the most ideal situation i know but it was a project i took over and hacked a fair bit over the past few years to get it working as the customer needed. the other table, NMC2, is exactly the same and even has a view but I never use that, or at least i don't think that i do. I presume that if is USE table1 i don't use the view if there is one, and even if i did use the view i would presume that it would be unused when i issued the USE command.
~M

>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
Go raibh maith agat

~M
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform