Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Available Indices in remote tables
Message
 
 
To
15/08/2002 14:10:26
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00689924
Message ID:
00690100
Views:
27
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform