manual retrive dbf data 
Author Message
 manual retrive dbf data



wantedtext:=Table1Fieldname1.Value  or
wantedfloattostringtext:=floattostr(Table1Fieldname1.Value);  
Use the fieldeditor (rightclick on the table-component) to activate all fields.
or look at FIELDBYNAME in delphi Help.

Quote:
>Hi everyone,

>I am using delphi 4 standard,I am very new to delphi( 1 week),I have created
>a simple data aware form and database using dbase for windows,
>I have no problems with adding data,and worked out a  printing
>routine to print the required data,but I have so far been unable to
>find any examples on how to retrive a record from the database.

>      if PrintDialog1.Execute then
>        with PrintDialog1 do
>        begin
>             with Printer do
>             begin
>                  RecNum:=Table1.RecordCount;
>                  if RecNum >0 then
>                  begin
>                        Table1.First;
>                         BeginDoc; (* init printer *)
>                        for i := 1 to RecNum do
>                            begin
>                               (* get data here*)
>                               Table1FNAME.GetData(PChar(name));

>                                (* pass data to print routine *)
>                                PrintPage(name);
>                                NewPage;
>                                Table1.Next;
>                             end;
>                          EndDoc;
>                  end;
>             end;
>        end;

>I would be grateful if someone could tell me the relationship between the
>table
>and record in a dbase file and how to retrieve the fieldname data .
>nether have I found in the delphi help file or examples so far

>Regards
>Steven Watson



Thu, 12 Feb 2004 21:47:36 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Problem retriving Binary Data from a Clipper Character field

2. DBF DBF DBF

3. Importing data to .dbf file

4. Converting QUICKBOOKS data to DBF

5. About Sharing Data(Foxpro dbf).

6. Encrypting tables or securing *.dbf data.

7. Reading old COBOL data files to DBF???

8. Retriving 2 cursors with StoredProc in Delphi 5.0 from Oracle 8 SQL server

9. Retrive an Image from a Paradox DB

10. Retriving 2 cursors from StoredProc with Delphi 5.0 from Oracle 8

11. How do I retrive record values?

12. Retrive alias names

 

 
Powered by phpBB® Forum Software