Thread: Take values from databasefield,calculate them and bring them back

Hi i made an application in BCB6 and connected with SQL Server 2000.

insert

Code:

  int i,records;
  records=ADOTable1->RecordCount;

  //Array for save values from Access
  int *getvalues=new int[records];

  //Take values from Access
  for(i=0;i<records;i++)
  {
  getvalues[i]=ADOTable1->Fields->Fields[1]->AsInteger;
  ADOTable1->Next();
  }
  ADOTable1->First();
  for(i=0;i<records;i++)
  {

  ADOTable1->Append();
  ADOTable1->FieldValues["Pow"]=getvalues[i]*getvalues[i];
  ADOTable1->Post();
  }

So i made the above code. I want to take the values of table of specifiec field "FileValues" calculate them and post them to new Field "Pow" but it doesnt work my code. Any ideas??

http://cboard.cprogramming.com/showthread.php?t=85022
One question at a time please.