2. ASPRunnerPro General questions
  3. Pervasive and ()
This topic is locked

Pervasive and ()

 		2/8/2008 5:50:20 AM
ASPRunnerPro General questions
U
 uros author

Hello,
Pervasive doesn't support () in queries. So I need to remove all "()" from queries. Here is a sample what i have to do:
This is OK: Select from table where field = '1'

And this does not work in Pervasive: FALSE: Select from table where field =('1')
How can i correct this. In ASPRunner 4.1 i change just code below and it was OK:
function db_upper(dbval)

db_upper = ucase (dbval)

end function
In version 5.1 i should change something more, but I don't know what...
Please for your help
U
 		uros author 2/9/2008

Hello,

Pervasive doesn't support () in queries. So I need to remove all "()" from queries. Here is a sample what i have to do:
This is OK: Select from table where field = '1'

And this does not work in Pervasive: FALSE: Select from table where field =('1')
How can i correct this. In ASPRunner 4.1 i change just code below and it was OK:
function db_upper(dbval)

db_upper = ucase (dbval)

end function
In version 5.1 i should change something more, but I don't know what...
Please for your help