Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Available Indices in remote tables
Message
De
15/08/2002 15:00:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00689924
Message ID:
00690105
Vues:
29
>Did you try the LIKE clause instead of =? Unlike VFP, Oracle will not compare strings of differing lengths without the LIKE clause.

Sorry Larry, I copied the last "version" of the prg, but I tried both (one of them with a Trim() ):
 SQLexec (nJDEHandle, "select * from user_indexes where upper(table_name) = 'F4211'", "CurOracle")
 SQLexec (nJDEHandle, "select * from user_indexes where trim (upper(table_name)) = 'F4211'", "CurOracle")
 SQLexec (nJDEHandle, "select * from user_indexes where upper(table_name) like 'F4211%'", "CurOracle")
They all give the same empty cursor as result.

Fernando
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform