Databases
StackOverflow2013
Postsdbo
POC File updating and creating help
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POC File updating and creating help
    primarykey
    data
    text
    <p>I have two .dat(ascii) files. Both sorted.</p> <p>1: a clients file containing ; account number , name ,balance 2: a transaction file containing; account number ,date,saleamount(transaction amount)</p> <p>What i am trying to accomplish is create a new updated clients file which has updated balances for the clients based on adding or subtracting the saleamount of the matching transaction.</p> <p>My code so far enables me to :</p> <p>1: if there are not more than one transactions for a client the code runs perfectly writes the .dat file with the clients and their updated balances.</p> <p>2:if there are more than one transactions for a client my code will run almost perfectly as it will print to the screen the updated clients and accounts for eg:</p> <p>1 james 540.00 2 john 762.00 3 paul 414.00 4 sam 502.00</p> <p>will be displayed , but as there are two transactions for john the created .dat file while contain</p> <p>1 james 540.00 2 john 662.00 2 john 762.00 3 paul 414.00 4 sam 502.00</p> <p>My problem lies here, I need to find a way of having the created .dat contain only one line for each client ( account number)</p> <p>My code is attached any help would be greatly appreciated.</p> <pre><code>#include &lt;stdio.h&gt; #include &lt;string.h&gt; int main(void) { int account, matches=0; /* account number */ char date[ 30 ]; /* account Date */ double balance, saleamount,total=0, temp;; /* account SaleAmount */ int transaccount; char name [ 30 ]; char lastname[30]; int lastaccount=-1; double lastbalance; FILE *cfPtr; /* cfPtr = clients.dat file pointer */ FILE *ctPtr; /* cfPtr = transaction.dat file pointer */ FILE *cfPtr2; /* cfPtr2 = new client file */ cfPtr2 = fopen( "clientupdate.dat", "w" ); /* fopen opens file; exits program if file cannot be opened */ if ( ( cfPtr = fopen( "clients.dat", "r" ) ) == NULL ) { printf( "clients could not be opened\n" ); /*fflush(stdin);*/ } /* end if */ else if( ( ctPtr = fopen( "transactions.dat", "r" ) ) == NULL) { printf( "File could not be opened\n" ); /*fflush(stdin);*/ } else { /* read account, date,name, balance and SaleAmount from files */ fscanf( cfPtr, "%d%s%lf", &amp;account, &amp;name, &amp;balance ); /*fflush(stdin);*/ fscanf( ctPtr, "%d%s%lf", &amp;transaccount, &amp;date, &amp;saleamount ); /*fflush(stdin);*/ printf( "%-13s%-10s%s\n", " Account", "Name", "Balance" ); printf("|----------------------------------|\n"); while( !feof(ctPtr)) { while( !feof(cfPtr) &amp;&amp;matches==0 ) { if(account == transaccount) { if (lastaccount != account) { if (lastaccount != -1) printf(" %-10d%-10s%.2lf\n", lastaccount, lastname, lastbalance); lastaccount = account; strcpy (lastname, name); } matches=1; total=0; temp = balance+saleamount; total = total + temp; balance = total; lastbalance = balance; } else { fscanf( cfPtr, "%d%s%lf", &amp;account, &amp;name, &amp;balance ); /*fflush(stdin);*/ } } fprintf( cfPtr2, "%d %s %.2lf\n", account, name, total ); fscanf( ctPtr, "%d%s%lf", &amp;transaccount, &amp;date, &amp;saleamount ); /*fflush(stdin);*/ matches=0; } } if (lastaccount != -1) printf(" %-10d%-10s%.2lf\n", lastaccount, lastname, lastbalance); fclose( cfPtr2 ); getchar(); return 0; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJames
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POC File updating and creating help
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POC File updating and creating help
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1 for a well made homework question. You wrote some code, and explained to us what you wrote. We don't see many good homework questions around here :)
      singulars
      1. POC File updating and creating help
      1. USEarlz
    2. CO@earlz I'm Studying this in college,The way i look at it is if i don't explain it right / even attempt as much as i can i wont learn if by chance someone does help me.
      singulars
      1. POC File updating and creating help
      1. USJames
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload