DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Multiple Record  
DwZone Forum Index -> Multiple Record
.
Moderators: AdministratorsModerators 
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.
New Topic 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  
View this persons public profile  RicSteiner   9:36 16 Jun 2015  
   Re: 2 Multiple Insert Forms on same page  
View this persons public profile  Gianluigi   10:12 16 Jun 2015  
   Re: 2 Multiple Insert Forms on same page  
View this persons public profile  RicSteiner   10:25 16 Jun 2015  
    Incorrect Syntax  
View this persons public profile  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
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Incorrect Syntax  
View this persons public profile  Gianluigi   9:58 9 Dec 2014  
   Re: Incorrect Syntax  
View this persons public profile  RicSteiner   11:06 9 Dec 2014  
   Re: Incorrect Syntax  
View this persons public profile  Gianluigi   11:49 9 Dec 2014  
   Re: Incorrect Syntax  
View this persons public profile  RicSteiner   8:16 11 Dec 2014  
   Re: Incorrect Syntax  
View this persons public profile  RicSteiner   8:32 11 Dec 2014  
   Delete Associated Image  
View this persons public profile  Martin Cotterill   14:44 28 Jul 2014  
Last Visit: Saturday 4 Jul, 2020 11:44 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT+7

Jump to: