Kbase P63576: Using SQL-89 with 'SomeString' MATCHES SomeDatabaseField, Er
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/20/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Using ESQL/C (SQL-89)
Using 'SomeString' MATCHES SomeDatabaseField
** Unable to understand after -- "<x>". (247)
** <program> Line <number>. Invalid SQL statement. (945)
CAUSE:
The MATCHES phrase needs to be in the format of Field MATCHES 'String'
FIX:
Modify the SQL statement and which the order of the parameters to the MATCHES phrase