Search results for query: *

This solves my problems. Thank you a lot.

Dear Mr. Testi, Thank you for your reply. I will experiment with your suggestion to reform the database. Meanwhile I would like to know how to store positive integers by 2,3 or 4 characters. I need a way to convert either a group of - 2 characters into numbers 1 - 65535 or - 3 characters into...

Thank you, MrDataGuy and jrbbldr for your consideration. I should have explained beforehand that I am not using VFP for a business or office application, so the traditional database structure is not applicable in my case. I really need to keep on record sequences of numbers (record IDs). Table1...

I need to search between 1 and 5 NON-ADJACENT occurrences of a Varbinary field in another Varbinary field. For example to find in which record are A,B,C and D, querying a field with stuffAstuffstuffBstuffCstuffDstuffstuff. Here is the real picture: There is a Table1 (no more than 300,000...

Hello, I have a field pos_bin, which is Varbinary(2). The following command: REPLACE pos_bin WITH BITSET(pos_bin,1) produces 0200 in the field and REPLACE pos_bin WITH BITSET(pos_bin,8) gives 0201. How can I revert the result, so that when I set bit #0 I get 0001 and when I set...

I was actually asking if there wasn't any way to this natively, some command option. Obviously there isn't. In this case I'm going to use your code (thanks !) and convert all words in reverse order and then use traditional index commands. The aim is to get a list of words ordered like this...

I have to arrange words in reverse order (right to left) to explore the suffixes. Here is an example: http://tinyurl.com/4tvugvr. The Help says 'RightToLeft [property] is disregarded unless you are running a Middle Eastern version of Microsoft Windows.' Is there a way to do it in VFP or Excel...

Many thanks to your replies. I am trying to analyse text. The database is not big, say 10 thousand records. So far I search only in Char(100) fields, which contain keywords in a different order. My goal is to find all records, containing the searched keywords. However the task will get...

Is it possible to search with keywords in any order? For example a field contains the keywords 'journey earth centre', another record has a field with 'centre journey earth'. Is it possible to find both records by searching for 'earth journey centre'? If yes, how should the query be made? What...