This

SELECT *
FROM Information.Indexes I
JOIN Information.IndexColumns C ON I.TableName = C.TableName AND I.Name = C.IndexName
WHERE
Type = 'Text Index'
AND
TableName = :Table
AND
ColumnName = :Column

used to work. Now I get
ElevateDB Error #700 An error was found in the statement at line 9 and column 12 (Expected ( but instead found =)

I found out I have to use

SELECT *
FROM Information.Indexes I
JOIN Information.IndexColumns C ON I.TableName = C.TableName AND I.Name = C.IndexName
WHERE
Type = 'Text Index'
AND
TableName = :Table
AND
C.ColumnName = :Column

Is this a change that hasn't filtered into my brain yet or something else?


Roy Lambert

Roy,

<< Is this a change that hasn't filtered into my brain yet or something
else? >>

It's due to this new SQL/PSM function:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=COLUMNNAME

EDB parses column names/functions in a generic fashion, so it thinks that
the COLUMNNAME column is a function instead.  I'm going to be fixing this
for the next release, however.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


OK that hadn't sunk in yet cos I haven't used it yet.

Roy Lambert