Modify mdb files? [EDITED]

[Roberto Lopez]

EDIT: I've solved. It was a problem with field name (sorry).

Hi All,

HMG includes a demo (samples\hfcl\sql\rdd_sql\demo.prg) That I've adapted from Harbour showing how to read an mdb file.

My problem now, is that I need to modify an mdb file.

Following the MySql demo, I've added the following:

Code: Select all

RDDINFO(RDDI_EXECUTE, "DELETE FROM test WHERE last = 'Logan'")

In fact, I've tried lots of variants (including INSERT and UPDATE) with other mdb files and the result is always the same: RDDINFO call returns .F. and table is not affected.

Any ideas?

TIA.

PS: And... by the way... why is this demo located in HFCL foder?

[apais]

You could use ADORDD (see harbour group )

[apais]

Found it !

New version of adordd at https://github.com/AHFERREIRA/adordd.git


HTH
Angel

[mustafa]

Hola Roberto haber si te puede servir
mi sample
http://hmgforum.com/viewtopic.php?f=9&t ... 207#p45207
Un cordial saludo
Mustafa

[Roberto Lopez]

Many thanks to all.

As I've added in the edit note, my problem was a fieldname.

I've been working with a lot of different tools in the last months and I'm making some silly mistakes

I'll test ADO too and I'll take a rest this week, I need it

Thanks again!