PRINT 'Inserting values into [TouchScreenMatrixHeader] ...'

INSERT [dbo].[TouchScreenMatrixHeader] ([TSMHCode], [TSMHStatus], [TSMHDesc], [TSMHWidth], [TSMHHeight], [TSMHOther], [tblDummy]) VALUES (N'SPCFUN', 1, N'SPECIAL FUNCTIONS                       ', 6, 8, N' ', NULL)
GO

Print 'Done'


PRINT 'Inserting values into [TouchScreenMatrix] ...'

INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0101', 1, N'', 2, 2, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Save Layaway (Park Bill)''
Picture=''''
BackColor=65535

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.Layaway("Save")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0106', 1, N'                                        ', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''View X-Reading''
Picture=''''
BackColor=4210816

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ZReadingFile(.T., "View")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0107', 0, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''View X-Reading''
Picture=''''
BackColor=4210816

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ZReadingFile(.T., "View")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0108', 1, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''Open Drawer''
Picture=''''
BackColor=16711680

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.NS()''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0203', 1, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''View Last Bill''
Picture=''''
BackColor=12615935

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.RePrintCheque("View")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0204', 1, N'                                        ', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''View Recent Bills''
Picture=''''
BackColor=8454016

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.RePrintCheque("View", "ListBills")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0205', 1, N'                                        ', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''View Recent Z-Readings''
Picture=''''
BackColor=16776960

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.RePrintCheque("View", "ZReadings")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''

', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0301', 1, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''U.O.M''
Picture=''''
BackColor=16744576

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.RightClick_TLUnitLevel()''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0306', 1, N'                                        ', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''Print X-Reading''
Picture=''''
BackColor=128

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ZReading(.T.)''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0307', 0, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''Print X-Reading''
Picture=''''
BackColor=128

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ZReading(.T.)''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0403', 1, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Print Last Bill''
Picture=''''
BackColor=8388863

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.RePrintCheque("Print")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0404', 1, N'                                        ', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Print Recent Bills''
Picture=''''
BackColor=4259584

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.RePrintCheque("Print", "ListBills")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0405', 1, N'                                        ', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Print Recent Z-Readings''
Picture=''''
BackColor=16744448

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.RePrintCheque("Print", "ZReadings")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''

', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0501', 1, N'', 2, 2, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=0
Caption=''Load Layaway (Load Bill)''
Picture=''''
BackColor=4227327

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.Layaway("Load")''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0506', 1, N'                                        ', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''Print Z-Reading''
Picture=''''
BackColor=8404992

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ZReading(.F.)''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0507', 0, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''Print Z-Reading''
Picture=''''
BackColor=8404992

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.ZReading(.F.)''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO
INSERT [dbo].[TouchScreenMatrix] ([TSMCode], [TSMButton], [TSMStatus], [TSMCaption], [TSMWidth], [TSMHeight], [TSMOther], [TSMCmd], [tblDummy]) VALUES (N'SPCFUN', N'0508', 1, N'', 2, 1, N'FontName=''Microsoft Sans Serif''
FontSize=14
FontBold=.F.
FontItalic=.F.
ForeColor=16777215
Caption=''Re Log''
Picture=''''
BackColor=10485760

', N'Item Type=''''
Item Code=''''
Weighing Required=0
Desc Required=0
Price Required=0
Unit Price=0
Zero Price=0
Complementary=0
Menu=''''
Keyboard=''''
Command=''ThisForm.Relog()''
Sub-Menu=''''
Sub-Menu Compulsory=''''
Visible=''''
Enabled=''''
', NULL)
GO

Print 'Done'