Thanks guys i think i see the problem, I think its because of the missing index for the soundex(c_lname) and soundex(c_fname).
Thanks guys You give me a very helpful Ideas.
By the way,I use the Alltrim() just to Eliminate the spaces in my field. Thanks anyway for the suggestions
Sorry guys, Heres my code
Note: I have index on last name,first name
Thanks
SELECT ALLTRIM(control_no) as control_no,;
ALLTRIM(c_lname) as last_name, ALLTRIM(c_fname) as First_name,;
ALLTRIM(c_minit) as MI, dob_dt as Birthday,;
ALLTRIM(c_adr1) as address1,ALLTRIM(c_adr2) as address2...
Good Day guys
Guys how can i speed up my query selection in our system, it takes more than a minute to process a single query we ony have 300,000+ records. My query is just selecting names with soundex equivalent.
Hi Guys,
I have 2 different report in 2 different excel file and its being updated daily, now i have to create another excel summary report consist of those 2 excel report which i need to have a formula. Is it possible to have another excel file w/ formula coming from 2 different excel.
EX...
Yap, i think i can use your codes but the problem is the codes aint simple enough and it has so many variation of reports to incorporate it. Im thinking of starting again from scratch by using SQL Statements in that way i can manipulate it mush more easier. I have some idea i dont know if it...
ok, sorry for that,Generally the report is for the breakdown count of each questions (Age breakdown,Do you smoke?, Etc) for a certain Survey Questionaire so i have put this report into a report form giving me the quick view and automation of report to print smoothly but i only did was to save it...
Tnx Yeah i think i can do that, the thing is the current report is generated from several variables like this:
Age
18-24 x1824
25-29 x2529
Total
where: x1824,x2529 is 2 unique variables then i use the command Report form "Report_name" to file "file_name" ascii.
Please tell me if i've done...
Guys,
Question guys, I have a system revision which includes all report form from Visual Foxpro reports to a Text delimited file. Any way of conerting it without starting from scratch? thanks in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.