Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Parameterized view
Message
From
16/04/2000 16:45:10
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with Parameterized view
Miscellaneous
Thread ID:
00360173
Message ID:
00360173
Views:
36
I have the following view
create sql view vwconspessoa as ;
SELECT Pessoa.nmpessoa,;
IIF(Pessoa.idpessoa=1,"Física","Jurídica") AS idpessoa,;
Municipio.nmmunicip, Atividade.nmatividade, Pessoa.nrfone, Pessoa.nrfax,;
Pessoa.nmemail, Pessoa.nrpessoa;
FROM advbmala!pessoa, advbmala!municipio, ;
advbmala!atividade ;
WHERE Pessoa.nrmunicip = Municipio.nrmunicip AND ;
Pessoa.nratividade = Atividade.nratividade AND ;
UPPER(pessoa.nmpessoa) LIKE UPPER(?parm_condicao) ;
ORDER BY Pessoa.nmpessoa, Municipio.nmmunicip

Every time I change the parm_condicao I get the message "view definition has been changed" (error 1494)

The parm_condicao assumes values like 'p%' or '%de%'

What is wrong?
Antonio Carlos Kleinübing
Systems Analyst
Next
Reply
Map
View

Click here to load this message in the networking platform