Syntax error in INSERT INTO statement
-
hello friend, plz tell what is the syntax error in belows access query.pdpstate is the name of table INSERT INTO pdpstate(setid,power,input,aspect,ontimer,offtimer,multiscreen, volume,mute,balance,treble,bass,brightness,contrast,tint,red,green,blue,frequency,phase, hposition,vposition,displayflag,ontimehour,ontimemin,ontimeampm,ontimeonoff,ontimevolume, offtimehour,offtimemin,offtimeampm,offtimeonoff,failcount,sharpness,color,rgb_contrast, rgb_brightness,pip_onoff,pip_aspect,pip_source,ontimesource,service5v,service12v_main, service12v_audio,servicelamp_time1,servicelamp_time2,servicelamp_time3,servicelamp_status, rgb_sharpness,rgb_colortemp,shiftonoff,h_dot,v_line,shifttime,wiper,allwhite,videowall, timedisplay,eq100hz,eq300hz,eq1khz,eq3khz,eq10khz,bbe,max_hour,max_min,max_ampm,max_value, min_hour,min_min,min_ampm,min_value,autolamp,scroll_period,scroll_time,colortone,comport, vwallmode,scroll_type,tv_select,wall_div,wall_sno,rgb_colortone,lamp_error,temperature, br_sensor,no_sync,current_temp,fan_error,tv_ mode,major_ch1,major_ch2,sel_minor, minor_ch1,minor_ch2)VALUES('0','1','30','16','1','1','10','80','0','50','10','60','20','0','30', '26','88','29','40','20','1','1','0','2','9','0','1','5','10','7','0','0','0','76','0','20','20', '1','0','20','33','1','1','1','1','1','1','1','2','2','1','1','1','1','1','1','1','1','1','10','1', '1','1','1','63','255','1','100','63','255','1','255','70','1','1','2','1','1','6','1','36','3','1', '0','0','0','1','44','0','20','4','50','20','10','5') regards jitu
-
hello friend, plz tell what is the syntax error in belows access query.pdpstate is the name of table INSERT INTO pdpstate(setid,power,input,aspect,ontimer,offtimer,multiscreen, volume,mute,balance,treble,bass,brightness,contrast,tint,red,green,blue,frequency,phase, hposition,vposition,displayflag,ontimehour,ontimemin,ontimeampm,ontimeonoff,ontimevolume, offtimehour,offtimemin,offtimeampm,offtimeonoff,failcount,sharpness,color,rgb_contrast, rgb_brightness,pip_onoff,pip_aspect,pip_source,ontimesource,service5v,service12v_main, service12v_audio,servicelamp_time1,servicelamp_time2,servicelamp_time3,servicelamp_status, rgb_sharpness,rgb_colortemp,shiftonoff,h_dot,v_line,shifttime,wiper,allwhite,videowall, timedisplay,eq100hz,eq300hz,eq1khz,eq3khz,eq10khz,bbe,max_hour,max_min,max_ampm,max_value, min_hour,min_min,min_ampm,min_value,autolamp,scroll_period,scroll_time,colortone,comport, vwallmode,scroll_type,tv_select,wall_div,wall_sno,rgb_colortone,lamp_error,temperature, br_sensor,no_sync,current_temp,fan_error,tv_ mode,major_ch1,major_ch2,sel_minor, minor_ch1,minor_ch2)VALUES('0','1','30','16','1','1','10','80','0','50','10','60','20','0','30', '26','88','29','40','20','1','1','0','2','9','0','1','5','10','7','0','0','0','76','0','20','20', '1','0','20','33','1','1','1','1','1','1','1','2','2','1','1','1','1','1','1','1','1','1','10','1', '1','1','1','63','255','1','100','63','255','1','255','70','1','1','2','1','1','6','1','36','3','1', '0','0','0','1','44','0','20','4','50','20','10','5') regards jitu
-
hello friend, plz tell what is the syntax error in belows access query.pdpstate is the name of table INSERT INTO pdpstate(setid,power,input,aspect,ontimer,offtimer,multiscreen, volume,mute,balance,treble,bass,brightness,contrast,tint,red,green,blue,frequency,phase, hposition,vposition,displayflag,ontimehour,ontimemin,ontimeampm,ontimeonoff,ontimevolume, offtimehour,offtimemin,offtimeampm,offtimeonoff,failcount,sharpness,color,rgb_contrast, rgb_brightness,pip_onoff,pip_aspect,pip_source,ontimesource,service5v,service12v_main, service12v_audio,servicelamp_time1,servicelamp_time2,servicelamp_time3,servicelamp_status, rgb_sharpness,rgb_colortemp,shiftonoff,h_dot,v_line,shifttime,wiper,allwhite,videowall, timedisplay,eq100hz,eq300hz,eq1khz,eq3khz,eq10khz,bbe,max_hour,max_min,max_ampm,max_value, min_hour,min_min,min_ampm,min_value,autolamp,scroll_period,scroll_time,colortone,comport, vwallmode,scroll_type,tv_select,wall_div,wall_sno,rgb_colortone,lamp_error,temperature, br_sensor,no_sync,current_temp,fan_error,tv_ mode,major_ch1,major_ch2,sel_minor, minor_ch1,minor_ch2)VALUES('0','1','30','16','1','1','10','80','0','50','10','60','20','0','30', '26','88','29','40','20','1','1','0','2','9','0','1','5','10','7','0','0','0','76','0','20','20', '1','0','20','33','1','1','1','1','1','1','1','2','2','1','1','1','1','1','1','1','1','1','10','1', '1','1','1','63','255','1','100','63','255','1','255','70','1','1','2','1','1','6','1','36','3','1', '0','0','0','1','44','0','20','4','50','20','10','5') regards jitu
Beware: you're just one step away from Liquid Nitrogen. :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
hello friend, plz tell what is the syntax error in belows access query.pdpstate is the name of table INSERT INTO pdpstate(setid,power,input,aspect,ontimer,offtimer,multiscreen, volume,mute,balance,treble,bass,brightness,contrast,tint,red,green,blue,frequency,phase, hposition,vposition,displayflag,ontimehour,ontimemin,ontimeampm,ontimeonoff,ontimevolume, offtimehour,offtimemin,offtimeampm,offtimeonoff,failcount,sharpness,color,rgb_contrast, rgb_brightness,pip_onoff,pip_aspect,pip_source,ontimesource,service5v,service12v_main, service12v_audio,servicelamp_time1,servicelamp_time2,servicelamp_time3,servicelamp_status, rgb_sharpness,rgb_colortemp,shiftonoff,h_dot,v_line,shifttime,wiper,allwhite,videowall, timedisplay,eq100hz,eq300hz,eq1khz,eq3khz,eq10khz,bbe,max_hour,max_min,max_ampm,max_value, min_hour,min_min,min_ampm,min_value,autolamp,scroll_period,scroll_time,colortone,comport, vwallmode,scroll_type,tv_select,wall_div,wall_sno,rgb_colortone,lamp_error,temperature, br_sensor,no_sync,current_temp,fan_error,tv_ mode,major_ch1,major_ch2,sel_minor, minor_ch1,minor_ch2)VALUES('0','1','30','16','1','1','10','80','0','50','10','60','20','0','30', '26','88','29','40','20','1','1','0','2','9','0','1','5','10','7','0','0','0','76','0','20','20', '1','0','20','33','1','1','1','1','1','1','1','2','2','1','1','1','1','1','1','1','1','1','10','1', '1','1','1','63','255','1','100','63','255','1','255','70','1','1','2','1','1','6','1','36','3','1', '0','0','0','1','44','0','20','4','50','20','10','5') regards jitu
Start with this:
INSERT INTO pdpstate(setid)VALUES('0')If that works, add another field/value pair. Continue until syntax error appears."Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown
"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons