VB运用SQL更新语句出现让人头疼的错误

senrea 2009-12-03 01:12:52

'UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'



Public Function ChangeValue(tableName As String, ValueToChange As String, Value As String, WhereIs As String, WhereName As String) As Boolean



    '编辑记录



    Dim strSqlText As String



    Value = Replace(Value, "", "")



    Value = Replace(Value, "#", "")



    strSqlText = "UPDATE " _



                 & tableName _



                 & " SET " _



                 & ValueToChange & " = '" & Value & "' WHERE " & WhereIs & " = '" & WhereName & "'"



    'MsgBox strSqlText



    strSqlText = Replace(strSqlText, "*", "%")



    strSqlText = Replace(strSqlText, "?", "_")



    ChangeValue = DBManager.RunSQL(strSqlText)



End Function

但是当更新如下字符串到数据库中时，就出现莫名错误：

【导演 Director：
詹姆斯·卡梅隆 James Cameron

编剧 Writer：
詹姆斯·卡梅隆 James Cameron ....(written by)

演员 Actor：
萨姆·沃辛顿 Sam Worthington ....Jake Sully
佐伊·索尔达娜 Zoe Saldana ....Neytiri
西格妮·韦弗 Sigourney Weaver ....Dr. Grace Augustine
希·庞德 CCH Pounder ....Moha (as C.C.H. Pounder)
米歇尔·罗德里格兹 Michelle Rodriguez ....Trudy Chacon
吉奥瓦尼·瑞比西 Giovanni Ribisi ....Selfridge
乔·摩尔 Joel Moore ....Norm Spellman (as Joel David Moore)
韦斯·斯塔迪 Wes Studi拉兹·阿隆索 Laz Alonso ....TsuTey
Peter Mensah ....Akwey
Julene Renee ....Med Tech #1
Matt Gerald ....Lyle Wainfleet
Peter Dillon ....Shuttle Crew Chief
Sean Anthony Moran ....Fike
Kevin Dorman ....Tractor operator
Dean Knowsley ....Pilot
迪利普·劳 Dileep Rao ....Dr. Max Patel
Nick Miller ....Airfield Trooper (uncredited)
Logan Pithyou ....Blast Technician (uncredited)
Grant Roa ....Bouncer (uncredited)
Woody Schultz ....Med Tech #2 (uncredited)
史蒂芬·朗 Stephen Lang ....Col. Quaritch
Scott Lawrence ....Vaklyrie Crew Chief
Sean Patrick Murphy ....Shuttle Co-pilot
Jacob Tomuri ....Dragon Navigator
J. Patrick Pitts ....Shuttle Pilot
Andrew Emilio DeCesare ....Trooper (uncredited)
Luke Hawker ....Med Tech (uncredited)
Kelson Henderson ....Dragon Gunship Pilot (uncredited)
David Van Horn ....Dragon Gunner (uncredited)
Amy Clover ....Navi
Sean Moran ....Shuttle pilot
Christian Di Salvo ....Dragon Pilot (uncredited)
Leandro Di Salvo ....Dragon Pilot (uncredited)
Camille Keenan ....Waitress (uncredited)
Daniel Rathbon ....Militia (uncredited)
Nikie Zambo ....Navi (uncredited)
制作人 Produced by：
詹姆斯·卡梅隆 James Cameron ....producer
乔恩·兰道 Jon Landau ....producer
Josh McLaglen ....co-producer
Colin Wilson ....executive producer
Peter M. Tobyansen ....line producer
Janace Tashjian ....associate producer
Brooke Breton ....co-producer

原创音乐 Original Music：
詹姆斯·霍纳 James Horner

摄影 Cinematography：
Mauro Fiore

剪辑 Film Editing：
John Refoua
Stephen E. Rivkin ....(as Stephen Rivkin)
Steve R. Moore

选角导演 Casting：
Margery Simkin

艺术指导 Production Designer：
Robert Stromberg
瑞克·卡特 Rick Carter

美术设计 Art Direction by：
Todd Cherniawsky
Stefan Dechant
Sean Haworth
Andrew Menzies
Andrew L. Jones
Nick Bassett
Robert Bavin
Seth Engstrom
Kevin Ishioka ....(supervising art director)
Andy McLaren
Ben Procter
Kim Sinclair ....(supervising art director)
Simon Bright
Jill Cormack

服装设计 Costume Design by：
玛耶斯·C·鲁贝奥 Mayes C. Rubeo
黛博拉·琳恩·斯科特 Deborah Lynn Scott

视觉特效 Visual Effects Supervisor：
Joe Letteri ....Weta Digital
Stephen Rosenbaum ....Weta Digital
Eric Saindon
Guy Williams
Mathilde Tollec ....BUF
John Bruno
Jonathan Rothbart
Edson Williams ....lola visual effects
Daniel Leduc ....Hybride
Richard Martin ....s: Hybride】

不包含【】