I keep getting a syntax error when I add a comma between rows SQL view on access INSERT INTO GG_Service (ServiceID, Serv
Posted: Sun May 15, 2022 8:35 am
I keep getting a syntax error when I add a comma between rows
SQL view on access
INSERT INTO GG_Service (ServiceID, ServiceDescription,
PricePerHour)
Values
(
('1', 'Prune Tree', '40') , <---- that
comma is highlighted for a syntax error when removed it says that
it is required
('2', 'Trim medium Tree', '60') );
SQL view on access
INSERT INTO GG_Service (ServiceID, ServiceDescription,
PricePerHour)
Values
(
('1', 'Prune Tree', '40') , <---- that
comma is highlighted for a syntax error when removed it says that
it is required
('2', 'Trim medium Tree', '60') );