General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>cGUID - Uniquely identifies the record in the entire table.
>>>cEmpId - Unique Id of the Employee (This could be duplicated within the table, depending on the number of Earning/Deduction Id for the employee)
>
>To work on a month or year for all the employees at once, you'd need to pull that whole dataset, then locate for records and add if required. But that's a bad idea for SQL, especially if there's large numbers of records. You are supposed to break data into logical manageable subsets to work on just those records.
>
>Example: break the task into rows per employee by making the RV constraint cEmpid=?m.lcEmployee. Then iterate through each employee and requery the RV to get all their records. Update/append, Tableupdate(), next employee. Also think about transactions if it matters if things fail part way through the payroll run.
>
>If you are sure you know what the cGUID would be for each employee record, then you could use the current view, requerying for each expected row. However, if cGUID is random or you need to sum values in multiple fields, then consider whether you definitely need cGUID when you've got an Identity field as well as other fields you can use to pull data. Make id your RV update key if you can.
Hi
Thank you so much for your time, I will do as you advised and revert to you ASAP, if and when I run into issues again :)
Alex
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only