Files in C

[trinath]

Hi all,

I have a problem in handling files through C.

here is the problem im having:

i will query the database (for instance consider employees table )
for empno,ename,job,salary fields.The query returns me some 100 of rows. now i need to place them in a file in row wise pattern as they exist in the database.

now , if any row is updated in the database i need to update the same row in the file . also if any row is deleted i need to remove the same row in the file , and if any new row is inserted into the data base i need to insert the row in the file.

can any one suggest me any method to do this .
The performance is and main criteria(i mean time to do file operations. )

please help me in this regard,

thanks in advance,


Trinath Somanchi,
Hyderabad.

[PING]

I suppose you have a table with all the information about one employee on one line.
You can consider taking in each line using fgets() , and writing it to another file.
If a line is deleted, pass the line number to the linedeletion function, ignore (n-1) endofline characters '\n' and delete the line that the file pointer now points to, that is, delete characters from that position till you encounter the next '\n' or replace them with blankspaces, whichever suits you.

[Salem]

I'm sure a search for "employee database" will work....