Writing into Paradox DB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 !!!!
 
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
 
Hi Marius,

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

Cheers

Doug Forster
 
Back
Top