Writing into Paradox DB

[Marius Rus]

We have to write into an Paradox db that we manage to do. Unfortunatelly it
is a field named "Date" of type Date/Time that we cannot write. If the field
it is named as for example "Due_Date" of the same type Date/Time it is
writing without any problem.
Could provide some help please? Thank you.

[Lord2702]

Paradox must be considering a `Date` as a keyword, use _Date instead of Date
or make change as you like but do not use keywords/ special words which
create conflicts.

Good Luck !!!!

"Marius Rus" <Ma*******@discussions.microsoft.com> wrote in message
news:F0**********************************@microsof t.com...

We have to write into an Paradox db that we manage to do. Unfortunatelly it is a field named "Date" of type Date/Time that we cannot write. If the field it is named as for example "Due_Date" of the same type Date/Time it is
writing without any problem.
Could provide some help please? Thank you.

[Doug Forster]

Hi Marius,

Try this:
cmd=new OdbcCommand("insert into
apori(Reference,Supplier,apori.'Date',Due_date)"

Cheers

Doug Forster

"Marius Rus" <Ma*******@discussions.microsoft.com> wrote in message
news:03**********************************@microsof t.com...

Our problem it is that we have to write into this database that belong of
an
accounting software where we cannot change the field names. Our code is as
follows:

+" values('2','R8572229','1','9/21/2004','9/21/2004')",odbcConnection1);

Could you please suggest something?

Thank you
"Lord2702" wrote:

Paradox must be considering a `Date` as a keyword, use _Date instead of
Date
or make change as you like but do not use keywords/ special words which
create conflicts.

Good Luck !!!!

"Marius Rus" <Ma*******@discussions.microsoft.com> wrote in message
news:F0**********************************@microsof t.com...

> We have to write into an Paradox db that we manage to do.
> Unfortunatelly

it

> is a field named "Date" of type Date/Time that we cannot write. If the

field

> it is named as for example "Due_Date" of the same type Date/Time it is
> writing without any problem.
> Could provide some help please? Thank you.

[Marius Rus]

Our problem it is that we have to write into this database that belong of an
accounting software where we cannot change the field names. Our code is as
follows:

cmd=new OdbcCommand("insert into apori(Reference,Supplier,Date,Due_date)"
+" values('2','R8572229','1','9/21/2004','9/21/2004')",odbcConnection1);

Could you please suggest something?

Thank you
"Lord2702" wrote:

Paradox must be considering a `Date` as a keyword, use _Date instead of Date
or make change as you like but do not use keywords/ special words which
create conflicts.

Good Luck !!!!

"Marius Rus" <Ma*******@discussions.microsoft.com> wrote in message
news:F0**********************************@microsof t.com...

We have to write into an Paradox db that we manage to do. Unfortunatelly

it

is a field named "Date" of type Date/Time that we cannot write. If the

field

it is named as for example "Due_Date" of the same type Date/Time it is
writing without any problem.
Could provide some help please? Thank you.