Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Available Indices in remote tables
Message
 
 
À
15/08/2002 14:10:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00689924
Message ID:
00690100
Vues:
26
>I created the following prg:
>
> nJDEHandle = SqlConnect (cJDEDataSource, cJDEUserId, cJDEPassword)
>
> SQLexec (nJDEHandle, "select * from user_indexes where upper(table_name) = 'F4211'", "CurOracle")
>
> SqlDisconnect (nJDEHandle)
>
> Select CurOracle
> Browse
>
>When executed it browses an empty cursor (CurOracle). I tested with many other tables of that database and it allways returned an empty cursor (I made sure the tables I tested had indexes). I never got an error message returned by Oracle.
>

Fernando,
Did you try the LIKE clause instead of =? Unlike VFP, Oracle will not compare strings of differing lengths without the LIKE clause.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform