该语句在ACCESS中运行的时候没有错误,但在DEPLHI中调用的时候就报UPDATE语句错误,为什么会这样呢?请大虾指教,语句如下:
     update T_MONITOR_RECORD  set stream_id='20050407104i05',f1_stream_id='none',progress='10010001000',progress_content='asfwe',check_detail='gwefwe',record_person='wef',modify_flag='I',create_user='AAA',create_date='2005-04-07',memo='2005-04-07',progress_word='桩机检测',phase='100100010000',type='2',is_random='1',question='Mefwefwe' where CONSTURCT_ID='10002025'(ACCESS中运行通过,但在DELPHI中报错)
以下是写在DELPHI的语句:
strSQL:='update T_MONITOR_RECORD  set stream_id='''+trim(str_Stream_ID)
                             +''',f1_stream_id='''+trim(str_F1_Stream_ID)
                             +''',progress='''+trim(str_Progress)
                             +''',progress_content='''+trim(str_Progress_Content)
                             +''',check_detail='''+trim(str_Check_Detail)
                             +''',record_person='''+trim(str_record_person)
                             +''',modify_flag='''+trim(str_modify_flag)
                             +''',create_user='''+trim(str_create_user)
                             +''',create_date='''+trim(str_create_date)
                             +''',memo='''+trim(str_memo)
                             +''',progress_word='''+trim(str_progress_word)
                             +''',phase='''+trim(str_phase)
                             +''',type='''+trim(str_type)
                             +''',is_random='''+trim(str_is_random)
                             +''',question='''+trim(str_question)+''' where CONSTURCT_ID='''+trim(str_construct_id)+'''';