[問題] Field Calculator使用遇到錯誤（已解決問題）
我有個問題就是我想要把多個字元分別歸類
EX HW、HU歸類為1
RE、1E歸類為2...等
但我在Field Calculator用以下的方CODE
都會出現錯誤（There was a failure during Processing,
check the Geoprocessing Results window for details.)
請求協助...
使用Code如下
Dim sResult as Integer
Dim sFieldsField = [ROADTYPE]
If (sField="HW") Then
sResult ="1"
ElseIf (sField="HU") Then
sResult ="1"
ElseIf (sField="RE") Then
sResult ="2"
ElseIf (sField="1E") Then
sResult ="2"
ElseIf (sField="RD") Then
sResult ="3"
ElseIf (sField="1W") Then
sResult ="3"
ElseIf (sField="1U") Then
sResult ="3"
ElseIf (sField="2W") Then
sResult ="3"
ElseIf (sField="2U") Then
sResult ="3"
ElseIf (sField="3W") Then
sResult ="3"
ElseIf (sField="3U") Then
sResult ="3"
ElseIf (sField="4W") Then
sResult ="3"
ElseIf (sField="IU") Then
sResult ="3"
ElseIf (sField="AL") Then
sResult ="4"
ElseIf (sField="OR") Then
sResult ="4"
ElseIf (sField="OT") Then
sResult ="4"
End If
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.118.5.126