Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Variable disappearing from Filter tab in View Designer
I am trying to create a view in the View Designer which uses a variable in the where clause.
When I view the SQL, the variable has been wrapped in quotes.
The variable C contains the parameter I want to filter with
What I want:
SELECT *;
FROM workout!exercises;
WHERE exercises.cat = C;
ORDER BY exercises.exerciseid
What I get:
SELECT *;
FROM workout!exercises;
WHERE exercises.cat = "C";
ORDER BY exercises.exerciseid
I would like to find a solution that allows me to continue to use the View Designer.
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