About search on string in table

Quote
PETER ZHOU
n = TableSeek(Table_Candidate.CandidateName,EDT_SearchFullName,False)
will search for string starting with (generic) in "sought element"

n = TableSeek(Table_Candidate.CandidateName,EDT_SearchFullName,True)
will do exact match search in "sought element"

How about i want to do a search on string within the "sought element" ?

Regards,

PETER ZHOU

Quote
PETER ZHOU

Quote
PETER ZHOU
n = TableSeek(Table_Candidate.CandidateName,EDT_SearchFullName,False)
will search for string starting with (generic) in "sought element"

n = TableSeek(Table_Candidate.CandidateName,EDT_SearchFullName,True)
will do exact match search in "sought element"

How about i want to do a search on string within the "sought element" ?

Regards,

PETER ZHOU

Sorry...forgot abt the word "sought element"

PROCEDURE SearchInColumn(sTableName is string,sColumnName is string,sFindString is string,iRowStart=1)
sSearch is string = sTableName+"."+sColumnName
iCnt,iTblCnt is int
iTblCnt = TableCount(sTableName)
//Check if iRowStart not is lower or equal than 0 and not greater than the table rowcount.
//Because it will throw an exception.
IF Val(iRowStart) <= 0 THEN iRowStart = 1
IF Val(iRowStart) > iTblCnt THEN RESULT -1
//Perform search
FOR iCnt = iRowStart TO iTblCnt
   IF Position({sSearch,indControl}[iCnt],sFindString) > 0 THEN RESULT iCnt //return rownumber
END
//found nothing
RESULT -1

Quote
LS

PROCEDURE SearchInColumn(sTableName is string,sColumnName is string,sFindString is string,iRowStart=1)
sSearch is string = sTableName+"."+sColumnName
iCnt,iTblCnt is int
iTblCnt = TableCount(sTableName)
//Check if iRowStart not is lower or equal than 0 and not greater than the table rowcount.
//Because it will throw an exception.
IF Val(iRowStart) <= 0 THEN iRowStart = 1
IF Val(iRowStart) > iTblCnt THEN RESULT -1
//Perform search
FOR iCnt = iRowStart TO iTblCnt
   IF Position({sSearch,indControl}[iCnt],sFindString) > 0 THEN RESULT iCnt //return rownumber
END
//found nothing
RESULT -1

Thanks!

I think it's works great...but don't know how's the speed issue when the data increases
Something like this. I haven't tested this, but it should work.

Quote
Ben
From experience its better to handle all searches on the database side before populating the grid. The database engine is better equiped with years of algorythm evolvement to handle seaches in a much more efficient way.