ODBiC Discussion Board


RE: trying to updated field , John Thompson, 04-18-2007

Try it without the brackets around column names

by Roger Harris, April 23, 2007 13:30

The "Too few parameters. Expected 1" error is usually caused by misspelling a column name, so the SQL parser thinks it should be expecting a named input parameter. I haven't tested this but in standard SQL, column names don't require the [ and ] brackets, so if AddressInvoice is the correct column name, I think this should work:

<!--UPDATE plog SET plog.InvoiceIDNum = Left(AddressInvoice,InStr(1,AddressInvoice,",")-1)-->


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


Copyright ©1997-2003, Roger Harris. All rights reserved.