Message-ID: <435F7AA7.3060508@e9.com>
Date: Wed, 26 Oct 2005 07:46:31 -0500
From: Louis Castoria <louisc@e9.com>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Status question
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'm confused about something and need some help.  I wrote a c routine 
that uses libpq.    if  I use an update  sql command  string like 
"update largetable set t01='update1', t02='update2' where mainkey='12'" 
and the mainkey of 12 does not exist the result code is a 0.   If the 
mainkey exists I get a result of 0.  How can I tell if the update was 
successful or not.  Here is the code.

void                                                                           

pgsql_exec_query( int *dbhandle, char *query, int *qryhandle, int 
*status ) {       
char *r,*n=query;                                                     
      
int nfields, i, j;                                                    
      
PGconn *conn = (PGconn *)*dbhandle;                                   
      
PGresult *res;                                                        
      
while ( *n != ';' || *(n+1) != ';' )
          n++;  
*n=0;                                                                 
      
res = 0;                                                              
      
res = PQexec(conn, query);                                            
      
printf("Result = %d ", (int) res);                                    
      
*status = PQresultStatus(res);                                        
      
printf("status = %f", (int) status);                                       
 *qryhandle = (int) res;                                               
}                                                                              

}

-- 


            Louis  Castoria  -  ADSI
            Software Engineer
            1930 First Commercial  Drive
            Southaven MS,  38671
            Phone: 662-393-2046
            WEB: http://www.e9.com