Search results for query: *

Depending on which machine you decide to run it on it could take a good length. For what we need it for and the machines we'll be running it on it's not time consuming. 200k records took about 10 seconds.

Tamar I like to avoid array's if at all possible. This works: CLEAR SELECT 2 USE (TempCount) EXCL SET SAFETY OFF ZAP FOR nQuesCount = 1 TO 10 APPE BLANK REPLACE q WITH nQuesCount FOR nValCount = 1 to 13 STORE "v" + ALLT(STR(nValCount)) TO m.numValue REPLACE (m.numValue) WITH 0 ENDFOR...

mmerlinn that is precisely what I had planned on doing once I figured out why I was getting the error 'Variable mValue is not found.' Where as mValue would be the equivilant to your 'z' var. I'm going to try wrapping paranthesis around mValue. If that doesn't work I'll try the ampersand. Thanks...

Tamar. And everyone else who commented. My original goal was to write this program in as little lines as possible, my mistake was not taking into account I didn't want to scan through a large database multiple times. Thanks to input from all of you I've written my program that is both...

Thank you everyone for giving your two cents on how I did everything wrong. Constructive criticism is always a bonus. Thank you GriffMG for actually answering my question and later mmerlinn too after realizing what I was asking. For future reference I now know I can use evaluate to substitute a...

store 1 to inc do while inc < 11 store "=ques"+allt(str(inc)) to mques store 1 to inq do while inq < 11 store 0 to mput go top do while not eof() if mques = inq &&*********This line right here is where I keep getting my error. mput = mput + 1 ?mques,inq,mput endif skip...

I'm not sure if this is resolved nor am I too clear on SQL... if you can index on your fields, index on one field that stores the same information regardless of which branch you are at. I would use field3 seeing as that looks like the record identifier. Import everything into one table as you...

Greetings, I have a question that I am not sure of how to ask. This prevents me from accurately searching for a solution, therefore I must rely on good ole fashion verbiage...or in this case Typiage. I have a database with 10 questions in it. Each question may contain 1 through 10 in the...