Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>My disclaimer ... it was late last night ..... and I could not get an SQL statement to work that had always worked previously.
>>
>>subnum is a 5 character field and parcel is a 12 character field. So subnum is matching on the first 5 characters of parcel.
>>
>>SELECT pao1.* FROM pao1, sub INTO CURSOR sub2 WHERE ALLTRIM(subnum) = PARCEL
>>
>>When the SQL kept returning an empty cursor I rewrote the SQL to the following and it worked.
>>
>>SELECT pao1.* FROM pao1, sub INTO CURSOR sub2 WHERE parcel like ALLTRIM(subnum)+ '%'
>>
>>Now in the morning, the original SQL is working. Is the only explaination was that it was late at night?
>>
>>Brenda
>
>Different values for SET ANSI ?
Good thought, although I have never SET ANSI. So I suppose it is always the default. Is SET ANSI influenced by the SET ENGINEBEHAVIOR?
Is it me or are there just a ton of errors in the VFP9 Help? When reading the SET ANSI, the two examples both use the SET ANSI ON and show different results.
Précédent
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