WinSQL Professional automatically encloses the values entered in the insert or update windows with the appropriate prefixes and suffix characters. Therefore, when typing the values in the grid, you do not enclose string values in quotes. Similarly, dates can be entered in the format that is understood by your system. This format is specified in the Regional Settings available in the Windows Control Panel.
Example:
|
Column name |
Data type |
Value entered |
|
FirstName |
VARCHAR |
Sarah |
|
LastName |
VARCHAR |
$$NULL |
|
ID |
INT |
430 |
|
CustSince |
DATETIME |
4/25/1963 3:00 PM |
Based on these values, WinSQL Professional generates the following query:
INSERT INTO customers(first_name, last_name, id, custsince)
VALUES ('Sarah', NULL, '430', DATETIME (1963-04-25 15:00:00.) YEAR TO SECOND)
Notice that WinSQL Professional appropriately encloses the string value and formats the DATETIME field.
Note: This example assumes that the database is Informix.