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  
   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  
 
Made the changes and got this...

DwZone Multiple record error
Error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'five'.
Error:-2147217900
Sql:
INSERT INTO dbo.tbl_Sizes (WO,STYLE,WIDTH,five,fiveHalf,six,sixHalf,seven,sevenHalf,eight,eightHalf,nine,nineHalf,ten,tenHalf,eleven,elevenHalf,twelve,thirteen,fourteen,fifteen,SMALL,MEDIUM,LARGE,one,two,three,four,fourHalf,SMALL_CAN,MEDIUM_CAN,LARGE_CAN,one_CAN,two_CAN,three_CAN,four_CAN,fourHalf_CAN,five_CAN,fiveHalf_CAN,six_CAN,sixHalf_CAN,seven_CAN,sevenHalf_CAN,eight_CAN,eightHalf_CAN,nine_CAN,nineHalf_CAN,ten_CAN,tenHalf_CAN,eleven_CAN,elevenHalf_CAN,twelve_CAN,thirteen_CAN,fourteen_CAN,fifteen_CAN) VALUES ('HP02822A','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)
 
Reply to this current thread  View this persons public profile  Send Private Message
   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: Sunday 5 Jul, 2020 1:23 am 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: