EVALUATE THE CONTENTS OF DATABASE FIELDS & THEN WRITE STATEMENTS 1

[TNN]

Need help with a starting point.

I have numerous records in a databse table that I must evaluate each field in a record of approx 50 fields and then write an appropriate vb statement. 40 of the fields contain either Y for yes or N for no. Depending on the field I must then adjust or modify a calculation to include or exclude certain calculable items. How do I bring forward each field, evaluate it, and write a statement.

Select Case won't work because I will have more than one matching case to write statements for. Each field evaluation may or may not require a vb statement to adjust calculations.

Any suggestions including the use of SQL are appreciated.

TNN, Tom
TNPAYROLL@AOL.COM




TOM

http://WWW.TNPAYROLL@AOL.COM

 

[TomSark]

I still don't have enough info. here, but you could code a cursor to do this. After you fetch each row, you can perform your IF statements, do your calculations, then invoke the appropraite updating actions.

Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[TNN]

Thank You Tom Davis (TomSark),
Tom, would you use SQL only to fetch the recordset and then use vb code to evaluate and write statements.? Then SQL for any updates?
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM

 

[TomSark]

I still don't have all the details here, but I would most likely put all of the logic in a proc that does everything... Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[TNN]

Thanks Tom,
Let me get into this a little bit and then I can be more specific.
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM