Hi,
I build a wizard to update several field for each item.
To search the item I need to update I have 4 criteria.
One is the location (I amusing a LinkEDIT for that)
3 are fields (Assettag, Legacy itemtag etc..) and I am using a comboEdit to display the list of every records possible on each field like below.
RetVal = AmDbGetListEx ("SELECT Assettag FROM amPortfolio where assettag <> '' and Model.Parent.name <> 'LOGICAL' ORDER BY Assettag", "", ",", "").
The problem I have now is to read all the data and create hte order, the wizard need 20 seconds. This is not good and I was wondering if it was possible to use a LINKEDIT and not a ComboEDIT BUT I need to be able to select the field I want on teh portfolio table and not use by befault the Self of the Portfolio table.
I build a wizard to update several field for each item.
To search the item I need to update I have 4 criteria.
One is the location (I amusing a LinkEDIT for that)
3 are fields (Assettag, Legacy itemtag etc..) and I am using a comboEdit to display the list of every records possible on each field like below.
RetVal = AmDbGetListEx ("SELECT Assettag FROM amPortfolio where assettag <> '' and Model.Parent.name <> 'LOGICAL' ORDER BY Assettag", "", ",", "").
The problem I have now is to read all the data and create hte order, the wizard need 20 seconds. This is not good and I was wondering if it was possible to use a LINKEDIT and not a ComboEDIT BUT I need to be able to select the field I want on teh portfolio table and not use by befault the Self of the Portfolio table.