|
-
Aug 25th, 2000, 06:27 AM
#2
Fanatic Member
Hi,
I may be going the wrong route here but. I'm assuming any fields that dont meet the criteria fail and you then change the value/delete the record all together. This being the case it would be far more efficient to give the user a screen with a combo containing available fields and another with operators (<, >, <> etc) and a textbox to enter values. Next take this and build an SQL statement using the criteria to build your where clause. that way you would find immediatly all records where a field does not match with one DB call. You can then cycle through and change as necassary or even a single update against the DB.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|