FiveTech Software tech support forums

cSql := "CREATE USER 'name'@'location' IDENTIFIED BY 'password' oCn:Execute( cSql ) // location can be 'localhost' or a wildcard ip address or '%'. '%' indicates from all locations. cSql := "GRANT ALL PREVILEGES ON 'dataasename.*' TO 'username'@'location' oCn:Execute( cSql ...

... '12'" "WHERE bcode LIKE '___12%'" is same as "SUBSTR( bcodi, 4, 2 ) = '12'" LIKE is case insensitive The percentage ( % ) wildcard matches any string of zero or more characters. The underscore ( _ ) wildcard matches any single character.

Hi I Have this error: MAKE Version 5.2 Copyright (c) 1987, 2000 Borland Error test1.mak 161: No match found for wildcard '$**' Error test1.mak 161: Command syntax error Error test1.mak 164: No match found for wildcard '$**' Error test1.mak 164: Command syntax error Error test1.mak ...

... and defined Output _Image1.jpg, more changes of Image1.jpg must have Names : _Image1_3.jpg, _Image1_4.jpg ..... Maybe scanning the Directory with Wildcard to detect the last used Numer ? scanning for : _Image1_*.jpg aDir := directory('.\Images\_Image1_*.jpg') NewValue := Len( aDir ) + 1 Existing ...

... lFound  Instead of using WildMatch function we could use simple "$" also. But by using WildMatch function, the user can enter wildcard character "?" inside the search expression.

... Phones. you can use it to block unwanted incoming calls. You simply add blocking calls to the list. You can block calls by specific numbers, wildcard numbers, anonymous numbers, category numbers etc. Moreever, Pocket Call Blocker can also block text messages from a number of a group of numbers. ...

... 7-Zip Commands 7z <command> [<switch>...] <base_archive_name> [<arguments>...] <arguments> ::= <switch> | <wildcard> | <filename> | <list_file> <switch>::= <switch_symbol><switch_characters>[<option>] <switch_symbol> ...

Hello Rao, Thank you very much for your help. You are right that a filter is fast but to browse a filtered database in xBrowse or a listbox is slow. I had this problem with a PPC solution. http://forums.fivetechsupport.com/viewtopic.php?f=4&t=15482 I have now tested with conditio...

For full text search this is working for me

cFilt := "WildMatch( '*/14/*', DbRecordInfo( 9 ) )"
set filter to &cFilt
Go Top

Works if the expression is found in any field of the DBF. Fast enough still.

Just now I tested with a DBF containing 608664 records with record length of 733 bytes on a field of length 40.
I used the filter using wildmatch( ... )
Time to set the filter and refresh the browse is varying between 0.000 seconds to highest 0.015 seconds.

> I assumed that Dietmar needs a fulltext search I mean he does not know before searching in his case if the lawcase is in this lex or in that. So an index can’t be used. To compare search speed we must assume that the basis data is for every method the same. > If it is full text search, then ...

Hello Mr. Rao, thank you for your answer. >Assume a DBF file with record length of 2048, containing 100,000 records. We read 205 MB of data in our old method. >Assume an index on field city with a field length of 20 bytes. Size of the index is only 2 MB. Isn't it faster to search in 2 MB of da...

Mr Otto All my earlier programs contained similar code since clipper days. Open the dbf file with FOpen in shared mode scan the entire text and work back the record numbers and then proceed. ( I also read the dbf files in this raw mode to check integrity and for repairs. ) But those were the days wh...

Hello Mr. Rao, The search function I suggested above is build after an advice from Antonio: http://forums.fivetechsupport.com/viewtopic.php?f=3&t=968&p=3824&hilit=RecSize#p3824 Jeff, Some years ago we helped a company to test several third party tools for such purpouse an...

Hello Mr. Rao,

would you be so kind to advice me how to handle lower and upper case with OrdWildSeek.
I would need a search independent of the case.

Thanks in advance
Otto