Add to Favorites    Make Home Page 19804 Online  
 Language Categories  
 Our Services  

Home » C Home » DBMS Projects Home » To acess the dbf database files and maupulate from the c

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

Search Projects & Source Codes:

Title To acess the dbf database files and maupulate from the c
Author Narender
Author Email narencool_1984 [at] yahoo.com
Description this program is a good database connectivity application in
c

Category C » DBMS Projects
Hits 14985
Code Select and Copy the Code
Code : #include <stdio.h> #include <stdlib.h> #include <string.h> #define MAXFIELDS 1000 /* maximum nr of fields */ #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); 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]+1; /* 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.

New! Click here to Add your Code!


ASP Home | C Home | C++ Home | COBOL Home | Java Home | Pascal Home
Source Codes Home Page

 Advertisements  

Google Search

Google

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

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

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


Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review