Hi!
is it possible to use upper function in select statement using Paradox dirver ?
or may be there is a substitution function ?
statement example - select UPPER(filed1) from TABLE1 where FIELD=1
?
Asking you because now, when we executing same request - we're getting error message. Executing same query withour UPPER - everything works.
Thank you!
|
UPPER should be supported. It's listed at String Functions. What's your error message?
catch( SQLException sqle )
{
do
{
System.out.println(sqle.getMessage());
System.out.println("Error Code:"+sqle.getErrorCode());
System.out.println("SQL State:"+sqle.getSQLState());
sqle.printStackTrace();
}while((sqle=sqle.getNextException())!=null);
}
|
Function works fine!
Sorry for disturbing!
Thank you!
|