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
the problem is, this laptop i have was given to me as a gift of my auntie w/ complete installaton already (Windows XP Professional) but i dont have any copy of the Disk or CD my auntie is in another country.
what version of DOS can try the fdisk you suggest?
Windows XP Professional was installed, i dont know what happen its just keeps on displaying that error. I try inserting a bootable floopy disk but i still cannot see my Hard drive it display a error message "Invalid Drive".
I try to enter the bios to see what happen in my hard drive but i dont...
Guys,
My HP Compaq Armada 1750 laptop doesnt open up, it displays
"Non-System Disk Error Please insert diskette and press any key to restart" but i dont have any disk on the floppy disk and neither on my CD-ROM, I can't access my Hard disk (Drive C:) I try entering the bios by pressing F10...
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.