PrivateFunction SetUpdate() AsString
Dim qc AsNew QC.Base
Dim SQLString AsString
SQLString=""
If Trim(txtTitle.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"title=" & qc.PrepareStr(txtTitle.Text)
EndIf
If Trim(txtSPN.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"spn =" & qc.PrepareStr(txtSPN.Text)
EndIf
If Trim(txtNumber.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"number=" & Val(txtNumber.Text)
EndIf
If Trim(txtweigth.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"weigth=" & Val(txtweigth.Text)
EndIf
If Trim(cmbSalseProduce.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"SalseProducter =" & qc.PrepareStr(cmbSalseProduce.Text)
EndIf
If Trim(cmbresult.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"result=" & qc.PrepareStr(cmbresult.Text)
EndIf
If Trim(txtBazarganiCode.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"BazarganiCode=" & qc.PrepareStr(txtBazarganiCode.Text)
EndIf
If Trim(txtRequestCode.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"reqcode =" & qc.PrepareStr(txtRequestCode.Text)
EndIf
If Trim(txtactor.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"actor=" & qc.PrepareStr(txtactor.Text)
EndIf
If Trim(txtrequestdate.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"reqdate =" & qc.PrepareStr(txtrequestdate.Text)
EndIf
If Trim(txtresultdate.Text) <> ""Then
SQLString = SQLString & IIf(SQLString =
"", "", " , ") & _
"resultdate=" & qc.PrepareStr(txtresultdate.Text)
EndIf
Return SQLString
EndFunction