Query examples for views

You can create queries for views.

SELECT Formula_Code, Version, Description 
FROM FsFormula 
WHERE Item_Code = [%1]

INSERT INTO FSVALIDATIONFIELD
(VALIDATION_CODE, VALIDATION_RECFMT, VALIDATION_SUBCODE, FIELD_NAME, FIELD_NO, DB_FIELD_NAME, DEP_FIELD, TYPE_DATA, LENGTH_DATA, READ_ONLY, REQUIRED, CASE_FORCE,SET_IND, CALL_IND, ENUM_IND, ENUM_STYLE, ENUM_STYLE_X, KEY_CHECK, CHAR_CHECK, ENUM_CODE, ENUM_QUERY, LOOKUP_CODE, LOOKUP_FLAG, ENUM_LABELIND, MINVAL, MAXVAL, FORMAT_CODE, MULTIFIELD_COUNT, VERSION, FS_SYS_ROWID) VALUES ('V\VIEWS', 'A', ' ',
'VIEWCOL21', 2100, NULL, -1, 8, 50, 1, 0, 3, 0, 0, 0, 0, 0, ' ', 1, ' ', ' ', ' ', 0, 0, NULL, NULL, NULL, 0, '5.30.28.00', NULL);