Forums :: Multiple Record

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Multiple Record

DwZone Forum Index -> Multiple Record
.
Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 11 to 20 of 32 (Total: 32)

First | Prev | Next | Last

Subject

Author

Date

2 Multiple Insert Forms on same page

RicSteiner

9:36 16 Jun 2015

Re: 2 Multiple Insert Forms on same page

Gianluigi

10:12 16 Jun 2015

Re: 2 Multiple Insert Forms on same page

RicSteiner

10:25 16 Jun 2015

Incorrect Syntax

RicSteiner

9:50 9 Dec 2014

When I switch from inputting into an Access database to an SQL database I get this:

DwZone Multiple record error
Error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '5'.
Error:-2147217900

The recordset is 3 rows. it will show the data from the 1st row but then stops

Sql:
INSERT INTO dbo.tbl_Sizes (WO,STYLE,WIDTH,5,5Half,6,6Half,7,7Half,8,8Half,9,9Half,10,10Half,11,11Half,12,13,14,15,SMALL,MEDIUM,LARGE,1,2,3,4,4Half,SMALL_CAN,MEDIUM_CAN,LARGE_CAN,1_CAN,2_CAN,3_CAN,4_CAN,4Half_CAN,5_CAN,5Half_CAN,6_CAN,6Half_CAN,7_CAN,7Half_CAN,8_CAN,8Half_CAN,9_CAN,9Half_CAN,10_CAN,10Half_CAN,11_CAN,11Half_CAN,12_CAN,13_CAN,14_CAN,15_CAN) VALUES ('HP02820A','HP-1053','B',0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

Thanks, Ric