Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Trying to use variable in Create SQL View command
I'm trying to use a variable in the SELECT statement in the following CREATE SQL VIEW command. I've tried it various different ways ("&p_claimno", "p_claimno", and p_claimno) but each time I get an ODBC error. Any ideas? (I can't create the view using the view designer, the entire command creates a view using left outer joins that I couldn't get working with the view designer).
create sql view add_update2 remote connection upsize share as SELECTfield names FROM Claimant_record
WHERE Claim_Number > &p_claimno;
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement