<TBL>.INDEX_TAG_ADD()

[Ronald Anusiewicz]

I�m trying to use the "TBL".INDEX_TAG_ADD() method to add indexes to a table.
I using variables with this method.

This example works �OK�
tbl = table.open(tblName)
idxName = "facility"
idxDef = "FACILITY"
indx = tbl.index_tag_add(idxName,idxDef)
tbl.close()


This example generates the error, Bad Expression Character.

tbl = table.open(tblName)
idxName = "date"
idxDef = "CDATE(DATE)+ALLTRIM(FACILITY)+ALLTRIM(INVOICE)+ALLTRIM(WORK_DONE),\"\",D"
indx = tbl.index_tag_add(idxName,idxDef)
tbl.close()


I�ve tried many different variations and combinations with no success.

The problem does not appear to be the index name or the index field, but it has to do with the filter and ascending/descending portion.

Any help would be greatly appreciated.

Happy New Year!!

Ron

[Tom Cone Jr]

RE: &lt;TBL&gt;.INDEX_TAG_ADD()

Ron, the quote marks look wrong. I'd use the interactive editor to see how Alpha is evaluating the expression.

BTW, the use of the term DATE for the name of the table field and the name of the indextag is something I'd avoid. DATE() is a built in function. I avoid using names that mirror the built in functions.

-- t

[CALocklin]

RE: &lt;TBL&gt;.INDEX_TAG_ADD()

Index_Tag_Add() requires separate arguments for Order, Filter, and Type. It appears that you are attempting to combine them into one string.

Cal Locklin
www.aimsdc.net

[Ronald Anusiewicz]

RE: &lt;TBL&gt;.INDEX_TAG_ADD()

Hi Cal,

I did come to that conclusion also, however; I got the same results when I broke the string down into four seperate variables.

I've included "ui_msg_box"s in my script and all the information appears to be there and in the proper format.

It doesn't work.

Ron

[Ronald Anusiewicz]

RE: &lt;TBL&gt;.INDEX_TAG_ADD()

I�ve been having a terrible time with the enclosed zip file (database).

Overall, using xbasic, I�m trying to do a remote update of an existing application.
In this case, I needed to add 3 new tables to the database. That portion of my code works just fine.
I then need to add 10 indexes to each of the 3 tables.

That�s where everything is going wrong.

I have 2 scripts. The first is �_updatebuild� which when run calls up �_CheckIndex�

�_updatebuild� sets the parameters for the generic script �_CheckIndex�.

As I understand it, the line �indx = idxtbl.index_get(idxName)� is suppose to look for the named index and if that index is not found, it will generate and error. The line is not working reliably at all. Sometimes it finds an error, and other times it does not.

The second problem is that when it does find an error, the line �indx = idxtbl.index_tag_add(idxName, idxDef)� is failing in one of two ways. It either fails to add the new index or it fails and generates an error message �Bad expression character�.

I�ve been looking at this too long and maybe I�m overlooking something. Then again, maybe I�m trying to do something that Alpha 5 cannot do or maybe this is a Bug. I would appreciate it very much if some could take a look at this code.

That�s again,

Ron