Information générale
Catégorie:
Codage, syntaxe et commandes
Try this: DELETE FOR !("PLED" $ Field_a) AND !("CERTIFIED" $ Field_a)
>I am trying to delete a specific set of records that don't meet a particular criteria from my table. The code is as follows:
>
>DELETE FOR Field_a not LIKE '%PLED%' AND field_a NOT LIKE '%CERTIFIED%' IN DOWNLOAD_TABLE3
>
>and I get the following error message:
>
>command contains unrecognized phrase/keyword
>
>
>I am trying to delete all record that don't contain the word "CERTIFIED" OR 'PLED'. Is a problem using the operator LIKE? If so, is a another way of deleting records that don't match my criteria?
>Help appreciated.
>
>
>THanks
>Nick Patel
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