Board index » delphi » Putting data in a Database Field

Putting data in a Database Field

Hi all,

I am trying to put some numbers in an existing table. what is the
command to do that. In DBase IV it was replace.

Thanks,

Chris

 

Re:Putting data in a Database Field


Well, depends on how you are accessing the record.

If you are using ttable as the component,
you can address it as tablenamefieldname.as<type>

(see my earlier post to someone else on this - posted 5 min ago).

If it is a tquery, use the update syntax of tquery

    update table set field to value where <field> = value.

-Dave

In article <32A61F71.5...@bentley.com>, chris.iver...@bentley.com says...

Quote

>Hi all,

>I am trying to put some numbers in an existing table. what is the
>command to do that. In DBase IV it was replace.

>Thanks,

>Chris

--
Dave Krajcar, Alternative Solutions
rai...@pacifier.com

Re:Putting data in a Database Field


Quote
Chris Iverson wrote:

> Hi all,

> I am trying to put some numbers in an existing table. what is the
> command to do that. In DBase IV it was replace.

> Thanks,

> Chris

Try this:
        table1.edit;
        .
        {assign new values to fields}
        .
        table1.post;

--
Richard D. Tan

Other Threads