Not trying to be a smart.. But in your routine that gets these in the db could you not write a code that stops these types of entries? I understand if somebody later edits this row-but then you could delete it then also.
Razzak has some great code/traps that will not allow rows to get entered. I am trying real hard to mimic him, I will never be that good-but I am trying to be at least 45%. Sincerely, Paul D www.SystemNets.com It takes a bit of time and is hard (at least for me, I keep busy with keymaps focused on U's <jk-gig> Mr. Bill ;))) From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, July 14, 2010 11:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - How to make this Delete command faster Hi This command takes too long when we run it from a workstation but I can not think of any way to speed it up. txdate is Indexed symptom is Text 150 no Index we will not search on this column subjx is Varchar no Index and we will not search on this column either DELETE ROWS FROM travcard + WHERE txdate = .#DATE AND sympt1 IS NULL AND subjx IS NULL any suggestions? Thanks Marc
