RE: [U2] SELECT sub-command
Ron, I donbt know what the command does but shouldnbt it be spelt OPTIMIZE? Even for the adherents of Webster I wouldnbt think therebd be many people who spelt it OPTOb& Which leads me to suspect that itbs a CUSTAMYSED command. Check whatbs in it b is it a copy of an existing bKb type modifier? Stuart From: "Ron Hutchings" We are on UV 10.0.11 PICK flavor Someone has encoded a NO.OPTOMIZE sub-command on some selects on one of our files. I cannot find documentation regarding using this sub-command on a SELECT. Removing it gives no detectable difference. Does anyone have insight into the use of this sub-command? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SELECT sub-command
Ron, By the way b& a quick search of UV docs shows there is a NO.OPTIMIZE command documented in the SQLUSER.PDF of the UniVerse (pp 3-9) documentation. Apparently it disables the WHERE optimisation function. Maybe the developer just got the spelling wrong. Regards, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/