Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Quick point.....
The preferred method with SQL is to use the wildcard charcter of '%' to find all records, or records that begin with a specified string of characters. Also, the Like operator, as opposed to the = operator, provides much more flexbility and is more in line with the SQL world at large. The "" (space(0)) stuff is more of an xBase/Fox thing, not something that applies to the SQL world at large. Finally, using the latter methods, you don't need to worry about the setting of ANSI.
>If the parameter is character (i guess it's the case by name convention) then ou may keep SET ANSI OFF (it's default) and set lcCategory='' (SPACE(0)). This case SELECT-SQL (view) will pick-up all records.
Précédent
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