20241218085749am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES (?,				?,		?,			?,			?,				
			?,			?,			?,					?,			?,				
			?,				?,		?,			?,	?,		
			NULL,						NULL,						'P',						?,		GetDate(),					
			?,		GetDate(),					'ADMIN',				GetDate(),					'?,
			?)
SQLSTATE: 07002
code: 0
message: [Microsoft][ODBC Driver 17 for SQL Server]COUNT field incorrect or syntax error

20241218085809am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES (?,				?,		?,			?,			?,				
			?,			?,			?,					?,			?,				
			?,				?,		?,			?,	?,		
			NULL,						NULL,						'P',						?,		GetDate(),					
			?,		GetDate(),					'ADMIN',				GetDate(),					'?,
			?)
SQLSTATE: 07002
code: 0
message: [Microsoft][ODBC Driver 17 for SQL Server]COUNT field incorrect or syntax error

20241218092730am
INSERT tim_crd 
	
		(	site_cd ,					tim_crd_card_no ,			tim_crd_date ,				tim_crd_empl_id ,			tim_crd_craft ,
			tim_crd_hours_type , 		tim_crd_hrs ,				tim_crd_rate ,				tim_crd_multiplier ,		tim_crd_adder ,				
			tim_crd_act_cost ,			tim_crd_wo, 				tim_crd_assetno ,			tim_crd_chg_costcenter ,	tim_crd_chg_account ,		
			tim_crd_crd_costcenter,		tim_crd_crd_account,		tim_crd_status , 			tim_crd_create_by ,			tim_crd_create_date ,	
			audit_user ,				audit_date,					mbl_audit_user,				mbl_audit_date,				tim_crd_datetime1,
			tim_crd_datetime2 )
			
	VALUES ('MSW',				'TM141486',		'2024-10-01 11:29',			'000485',			'BWK',				
			'D',			1,877.01,			5.0000,					2.0000,			0.0000,				
			18770.17,				'P108572',		'MSW102383',				'BOWN',		'',		
			NULL,						NULL,						'P',						'000485',			GetDate(),					
			'000485',			GetDate(),					'ADMIN',				GetDate(),					'2024-10-01 11:29',
			'2024-12-18 16:30')
SQLSTATE: 21S01
code: 110
message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.