Skydiver, on 08 October 2012 - 07:44 AM, said:

My bad ,i misunderstand your question.

 INSERT INTO "+ table_name +" VALUES ('insert',EMPTY_BLOB()) 

it is stored in szSqlStat2 .

Thanks.

hello ,

Thank for your reply ,i'm trying to use SQLBindingParameter for binding an blob ,my table has only two columns ,an varchar type and an BLOB type .I believe that the problem is from my bindingparam function but cant figure it out .
I haven't worked with blob type before so it is abstract to me. The date is stored in an char array ,pData.The two statements that i use are :

UPDATE "+ table_name +" SET "+ column_name +" = ? WHERE filename ='insert'")
INSERT INTO "+ table_name +" VALUES ('insert',EMPTY_BLOB())")

the insert for inserting an empty blob ,and the update to update the inserted blob with the data.
Is this not correct ?

Thaks ,looking forward for your rely's.

Aphex19, on 04 October 2012 - 02:32 AM, said:

Hello,

The functions are returning as they should return .There is not problem there ,only that the blob data is not inserted in the table. I believe the statements are ok ,so i am thinking it could be an logic error or something, and i missed .

Thanks for your reply.

Hello ,


I would recommend you to use an sorting method.Your grades will be stored in an array ,and on that array you could use ,lets say bubble sort. So if you sort the array ascendent the the first element of the array will be the minimum and the last the max .I suspect that u use grades from 1 to 10 ,and is a person has lets say 10 5 7 6 as grades after an bubble sort your array would look like {5 6 7 10} so the minimum would be 5 and maximum 10 .

Here is an exemple of bubble sort implementation :

void bubble(int a[],int n)  
  {  
        int i,j,t;  
         for(i=n-2;i>=0;i--)  
         {  
            for(j=0;j<=i;j++)  
  
                  {  
                    if(a[j]>a[j+1])  
                                    {  
                                      t=a[j];  
                                     a[j]=a[j+1];  
                                     a[j+1]=t;  
                                    }  
                   }  
         
  
           }//end for 1.  
  
  }//end function.  

Basacly my app will use only two statements an update that look like :

"UPDATE "+ sw1 +" SET apkdata = ? WHERE filename ='img001'"

and an insert statement :

INSERT INTO table_name VALUES (memberlist,?,memberlist)

This form of insert statement is quite abstract to me .
This insert should be applied on the next table :

CREATE TABLE t_testblob (
  filename VARCHAR2(30) DEFAULT NULL NULL,
  apkdata  BLOB         NULL
)

I have suspected that the problem could be from my statements ,so if you could help me i would be really gratefull.

Thanks.