> I have asked this,but can no understand your answer.
> Here,My goal is coping or updating records from a table to another.So
> I want to push values to a "SQLQueryParms sqp",and then pass "sqp" to
> query.excute(sqp).As you can see,two questions arise:
> 1,some value is NULL,how to handle these NULL values?
> Should I do as following first:(assume the field type is char)
> ---------------------------
> Null<sql_char> tempValue= res[1][i];
> sqp <<tempValue;
> ----------------------------------------
>
> 2,FieldType vary from one to another,some is Datetime,some is
> float.....,Can I just put them into "SQLQueryParms sqp",then pass
> "sqp" to query?Or I should do following first?
> Or I can not do this at all.
> ---------------------------------------
> if(type==Date) {//pseudo-code
> sql_date tempValue= res[1][i];
> sqp <<tempValue;
> }else if(type==int){
> Null<sql_int> tempValue= res[1][i];
> sqp <<tempValue;
> }
>
> The last question is how to see what query sql has been built and
> executed?I mean I want to see this:
> ---------------------------
> UPDATE calls SET date_entered=2008-12-23 03:26:04 and date_modified=
> 2008-12-23 03:26:04.....
> ---------------------------------------
>> My code is like this:
>> -----------------------------------------------------------------------------
>>
>> try
>> {
>> query = clientConn.query(usql);
>> query.parse();
>>
>> SQLQueryParms sqp;
>>
>> for (size_t i = 1; i <20; i++)
>> {
>> sqp << res[1][i];
>> }
>> // put id into sqp for "where id=%q"
>> sqp << res[1][0];
>> query.execute(sqp);
>> cout<<query.str()<endl;
>> } catch (Exception& er)
>> {
>> cerr << "update: " << er.what() << endl;
>> }
>> --------------------------------------------------------------------------
>>
>
>
>> result:
>> table has not been updated,no exception,no error.no output,So what is
>> the problem here?
>
>
>>
>> usql is:
>> ----------------
>> UPDATE calls SET date_entered=%0 and date_modified=%1 and
>> assigned_user_id=%2q and modified_user_id=%3q and created_by=%4q and
>> name=%5q and duration_hours=%6 and duration_minutes=%7 and
>> date_start=%8 and time_start=%9 and date_end=%10 and parent_type=%11q
>> and status=%12q and direction=%13q and parent_id=%14q and
>> description=%15 and deleted=%16 and reminder_time=%17 and
>> outlook_id=%18q WHERE id=%19q
>> -----------------------
>>
>
>> the values of res[1] is
>> ----------------------------------------
>> fsfjl058230dfksdfk
>> 2008-12-23 03:26:04
>> 2008-12-23 03:26:04
>> 1
>> 1
>> 1
>> Get More information on the proposed deal
>> 0
>> 30
>> 2009-05-03
>> 09:00:00
>> 2009-05-03
>> Accounts
>> Planned
>> Outbound
>> 6b4f8eed-df99-d5bf-bc25-49505a8ce81f
>> NULL
>> 0
>> -1
>> NULL
>>
>
>
>
>
