Re: How to modify a value in one of the field while fetching MySQL???

[Adam Donnison]

If you want to update the value in the database, you need to use an UPDATE statement. If you are just asking about updating the value received in code then you have a few problems there, specifically:

char * row_s;
_itoa(row_num,row_s,strlen(row_s)+1);

This is a segfault waiting to happen. I'm not sure of the specifics of the compiler you are using, but itoa expects three parameters, the integer, a pointer to an array that exists and is long enough for the resulting formatted string and an integer indicating the base for the arithmetic conversion. Normally this would be 10 if you want decimal. You are passing a pointer to uninitialised space and a value based on that unitialised memory.

Webmaster - http://www.SkySQL.com/