Query_ForNewRecord.Close; Query_ForNewRecord.SQL.Clear; Query_ForNewRecord.SQL.Add('insert into CH_SATISFY_VALUE CHANNEL_CODE,AREA_TYPE,SAMPLE_CODE,');
Query_ForNewRecord.SQL.Add('RECEIVED,CH_Q1,CH_Q2,CH_Q3,CH_Q4,CH_Q5,CH_Q6,CH_VALUE)');
Query_ForNewRecord.SQL.Add('values(''' + Query_Selected_CH_PG.FieldByName('CHANNEL_CODE').AsString+ ''', ');
Query_ForNewRecord.SQL.Add('''' + Query_Selected_CH_PG.FieldByName('AREA_TYPE').AsString+ ''', ');
Query_ForNewRecord.SQL.Add('''' + Main_windows.Start_Date + ''', ');Query_ForNewRecord.SQL.Add(''''+Main_windows.SampleNum ''', ');
Query_ForNewRecord.SQL.Add('''0'', ''0'', ''0'', ''0'', ''0'', ''0'', ''0'',0)'); Query_ForNewRecord.Prepare;
Query_ForNewRecord.ExecSQL;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
在运行上面划波浪线线句子时,被提示“microsoft[odbc sql server driver]连接占线导致另一个hstmt"请问这个出错信息是什么意思?
导致这个出错信息的有可能是什么原因?
望高手赐教
谢谢
Query_ForNewRecord.SQL.Add('RECEIVED,CH_Q1,CH_Q2,CH_Q3,CH_Q4,CH_Q5,CH_Q6,CH_VALUE)');
Query_ForNewRecord.SQL.Add('values(''' + Query_Selected_CH_PG.FieldByName('CHANNEL_CODE').AsString+ ''', ');
Query_ForNewRecord.SQL.Add('''' + Query_Selected_CH_PG.FieldByName('AREA_TYPE').AsString+ ''', ');
Query_ForNewRecord.SQL.Add('''' + Main_windows.Start_Date + ''', ');Query_ForNewRecord.SQL.Add(''''+Main_windows.SampleNum ''', ');
Query_ForNewRecord.SQL.Add('''0'', ''0'', ''0'', ''0'', ''0'', ''0'', ''0'',0)'); Query_ForNewRecord.Prepare;
Query_ForNewRecord.ExecSQL;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
在运行上面划波浪线线句子时,被提示“microsoft[odbc sql server driver]连接占线导致另一个hstmt"请问这个出错信息是什么意思?
导致这个出错信息的有可能是什么原因?
望高手赐教
谢谢
Query_ForNewRecord.SQL.Add('insert into CH_SATISFY_VALUE CHANNEL_CODE,AREA_TYPE,SAMPLE_CODE,'); 哪一个是表名呀?
少了个括号.
乱是因为排版的问题.不好意思:)
麻烦大家看一下