|
Retail Pro 9 - Updating Table Records  OVERVIEW: Gain knowledge in the ability to make direct changes to data in Retail Pro tables using the Technicians Toolkit when the necessary security permission is granted. This mini course will illustrate how to establish the security permission that allows update rights to tables and introduce you to the SQL UPDATE statement. Learn the basic syntax of the UPDATE command and how to issue Update statements in the Technicians Toolkit that will change the values in designated fields within a Retail Pro 9 table. Learn Retail Pro's recommendations when using the Update statement and addresses the potential danger of its use. Time to Complete: 4 Hours
NOTE: this is a training course. Successful completion of this training course will entitle you to a certificate-of-completion. This course may also be used to help you prepare for a given certification exam. For more information about available Retail Pro certifications, please visit the certifications section of this website. TRAINING/CERTIFICATION METHOD:
Online:
| |
Cost: BP: No Charge for 1st Enrollment, 1 Training Credit per Re-enrollment
End-User: 1 Training CreditRegister: Submit Request |
TOPICS:
- Granting the Update Permission
- Syntax of the Update statement
- Updating specific columns
- Setting up conditions
- Using a nested Select statement
- Using the Select statement to query the table
|
