To Retrieve and manipulate .dbf files through c program (Mini Project)

Special : Web Developer's Collection CD-ROM
50,000+ Web Templates, Logos, Cliparts, Scripts. Order Now!

Add to Favorites Make Home Page

4214 Online

Language Categories

Source Codes Home
Project Ideas New!
Interview Questions
FAQs Home
ASP Home: ASP Source Codes; ASP Script Directory New!; ASP .Net Script Directory New!; ASP Interview Questions; ASP FAQs; ASP How Tos
C Home: C Source Codes; C Script Directory New!; C Interview Questions; C FAQs; C How Tos
C++ Home: C++ Source Codes; C++ Script Directory New!; C++ Interview Questions; C++ FAQs; C++ How Tos
Java Home: Java Source Codes; Java Directory New!; Java Interview Questions; Java FAQs; Java How Tos
JavaScript Home: JavaScript Directory New!; JavaScript Source Codes; JavaScript FAQs; JavaScript How Tos
COBOL Home: COBOL Source Codes; COBOL FAQs; COBOL How Tos
Pascal Home: Pascal Source Codes; Pascal FAQs; Pascal How Tos
PHP Script Directory New!
Python Script Directory New!
Perl & CGI Script Directory New!
Flash Script Directory New!
CFML Script Directory New!
Remotely Hosted Scripts New!
Tools & Utilities Directory New!
XML Script Directory New!
Best Programmers: Amit Mathur; Vishal Bhardwaj; Deepesh Jain
Vyom NetWork

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

9500+ Pages
9000 Question & Answers
All Tech. Categories

14 MB Content

Get it now !!

Home » C Home » DBMS Projects Home » To Retrieve and manipulate .dbf files through c program (Mini Project)

A D V E R T I S E M E N T

Title	To Retrieve and manipulate .dbf files through c program (Mini Project)
Author	narender
Author Email	narencool_1984 [at] yahoo.com
Description	I had devloped this progarme during my training in Sixth semester B.E.(comp Sc.).this program effectively connects .dbf database files in the c program and performs various functions on it
Category	C » DBMS Projects
Hits	380566
Code	Select and Copy the Code
Code : // This is devloped by narender #include <stdio.h> #include <stdlib.h> #include <string.h> #define MAXFIELDS 1000 #include<mem.h> #include<string.h> void main(int argc, char argv[]) { char p,q,r,buf; typedef char string11[12]; FILE in,out,out1; int a,i,j,n,field_pos[MAXFIELDS+1],nfield=0,pos,lrec; char record,field_type[MAXFIELDS]; // string11 field_data[500]; string11 field_name[MAXFIELDS]; struct { char version; / dBase version / char datum[3]; / date of last update YYMMDD / long nrec; / nr of records in th database file / short nhead; / nr of bytes in the header / short lrec; / nr of bytes in the record / char dum1[2]; char transact; / flag for incomplete transaction / char encrypt; / encryption flag / char mdx; / flag for presence of mdx-file / char dum2[3]; } header; struct { char name[11]; / fieldname zero filled / char type; / field type (C, D, F, L, M, N) / char dum1[4]; unsigned char length; / field length in binary / char ndec; / field decimal count in binary / char dum2[2]; char workid; / work area ID / char dum3[11]; char data[10]; } field; switch(argc) { case 1: in=stdin; break; case 2: if ((in = fopen(argv[1],"rb")) == NULL) { fprintf(stderr,"Input file %s not found ",argv[1]); exit(1); } break; default: fprintf(stderr,"Usage: %s dbase_file > database ",argv[0]); fprintf(stderr,"Or: cat dbase_file \| %s >database ",argv[0]); exit(1); } fread(&header,32,1,in); n=header.lrec; pos=1; // a=field_name[3]; while (n>1) { if (nfield==MAXFIELDS) { fprintf(stderr,"Too many fields "); exit(1); } fread(&field,32,1,in); strcpy(field_name[nfield],field.name); field_type[nfield]=field.type; // printf(" FIELD: %s",field_name[3]); field_pos[nfield++]=pos; pos+=(int)field.length; n-=(int)field.length; } for (i=1;i<nfield;i++) { printf("%s%c",field_name[i],i==nfield-1?' ':' '); } // for (i=0;i<nfield;i++) printf( "!%s%c", field_name[i],i==nfield-1?' ':' '); field_pos[nfield]=pos; / one extra for length calculation of last field / // printf(" %s",field_name[3].data); fread(&i,1,1,in); /read field terminator / if (i!=0xD) { fprintf(stderr,"Illegal field terminator; more than %d fields? ",MAXFIELDS); exit(1); } lrec=header.lrec; record=malloc(lrec+2); for (i=1;i<header.nrec;i++) { if (fread(record,lrec,1,in)!=1) { fprintf(stderr,"Error reading record %d ",i+1); exit(1); } if (record!='') / if not a deleted record / for (j=1;j<nfield;j++) { if(j==1) { p=record+field_pos[j]; / first char of the field / q=record+field_pos[j+1]-1; / last char of the field / while (p==' ' && p<=q) p++; /* remove leading spaces / while (q==' ' && p<=q) *(q--)='

Related Source Codes

Script Name Author

The Game Opposite as seen on Nokia 2300 Mobile Manikanta

RECURSIVE BALANCED QUICK SORT ashish

Radix Sort ashish

Change your mouse pointer Ashim

The blinking star Shashank

Data Validation Crylittlebaby

To search a file by giving file type like mp3 or mpeg or doc Prashanth SR

Menus Demonstration B.Chidhambaram

Employee Database Project Using C. Reenku Raman Nayak

Creating a Lexical Analyzer in c fahad bader al-buhairi �դ ?�� ??��

Calendar Program Omkar & Devendra

Stop double Process for start in C Cedrik Jurak

Stop double Process for start in C Cedrik Jurak

Time Scheduler Atiq Anwar

A timepass game between atmost two players Rahul Roy

A D V E R T I S E M E N T

Google Groups Subscribe to SourceCodesWorld - Techies Talk

Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
Discuss Programming Problems and Freshers Jobs related issues here.
Discuss Final Year Project Ideas here.

Advertisements

L I N K S

Jobs & Career: Freshers Jobs; Jobs Newsletter; Placement Papers; Placement Papers
GATE Preparation: Analysis & Design Of Algo.; Operating System; Lexical Analysis
GRE Preparation: GRE Home; 1208 Antonyms Test; 5000 Word's List; Top 100 Words' List; Scholarships; Top 100 CS Univ.; Top 126 EE Univ.
Tutorials: Hardware Tutorial; 1500 Free eBooks; XML Tutorial
Webmaster Resources: EzTraffic; Articles
Fun: Send FREE SMS!; SMS Jokes; Love SMS; Funny Jokes

Google Search

Source Codes World.com is a part of Vyom Network.

Sitemap | Privacy Policy | Terms and Conditions | Important Websites
Copyright ©2003-2024 SourceCodesWorld.com, All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/source/show.asp?ScriptID=873