Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View definition has been changed .
Message
From
08/02/2006 12:36:39
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View definition has been changed .
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01094694
Message ID:
01094694
Views:
47
Hi all ,
help please .

I create a remote view , but when i do requery , this message appears 'View definition has been changed .'

CREATE SQL VIEW Vuedetail REMOTE CONNECTION &Cdata AS SELECT Rubrique.rub_code,rpad(Rubrique.rub_libelle,30,' ')as rub_libelle,rpad(Rubrique.rub_alias,30,' ') as rub_alias,;
rpad(Rubrique.rub_touche,30,' ') as rub_touche ,rpad(Typerubrique.trub_libelle,30,' ') as trub_libelle,Rpad(Rubrique.rub_etat,2,'')as rub_etat,;
Rubrique.ser_code,Rubrique.trub_code;
FROM ;
rubrique Rubrique ;
INNER JOIN typerubrique Typerubrique ;
ON Rubrique.trub_code = Typerubrique.trub_code;
WHERE Rubrique.ser_code =?Cser_code;
ORDER BY Rubrique.rub_code

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform