Read Aloud the Text Content

This audio was created by Woord's Text to Speech service by content creators from all around the world.

Text Content or SSML code:

A WHERE clause is Used when statement should only affect that meet specified criteria. Or it is used to extract only those results from a statement. Column Name is used to select the name of the field for which the “where” condition to be applied. The fields will appear based of the form selected Ref table from other form and all the field of the same form. Compute This is used to for the condition that filter based on DAY,WEEKDAY,WEEK,MONTH,QUARTER,YEAR,HOUR,MINUTE,SECOND. Operations allows you to easily test if an expression matches any value in a list. There are different kind of value which are pre-defined they are Equal, Greater than or equal, less then, less than or equal, not equal, Between. The VALUES command specifies the values of an insert into statement. The value may be 1,2,3… or the value may be True or False or the value may be field value. Based on the condition required the value are added. Cascade It is used in conjunction with UPDATE. It means that the child data is updated when the parent data is updated. example There is the master form Having fields “user i d”, “Name” and “Phone Number” and the other form will require the same data such as “user I d”, “Name” and “Phone Number” so in the second form I will make auto fill in such a way that on adding or select the “user I d” the “Name” and “Phone no” will automatically filled . Condition specifies a combination of one or more expressions and logical operators and returns a value of TRUE. There are two values they are . And . Or. And – If the three are both condition then if we use AND then if both values are true then the value will display. If any one condition is false, then the value will not appear. Or- If the there are both condition then if we use OR then if any on the value is TRUE out of then the value the true value will be displayed. Action are used to add or delete a where condition