Page 1 of 1

Modify mdb files? [EDITED]

Posted: Sat May 14, 2016 11:20 pm
by 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?

Re: Modify mdb files? [EDITED]

Posted: Sun May 15, 2016 1:26 am
by apais
You could use ADORDD (see harbour group )

Re: Modify mdb files? [EDITED]

Posted: Sun May 15, 2016 1:29 am
by apais
Found it !

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


HTH
Angel

Re: Modify mdb files? [EDITED]

Posted: Sun May 15, 2016 9:46 am
by mustafa
Hola Roberto haber si te puede servir
mi sample
http://hmgforum.com/viewtopic.php?f=9&t ... 207#p45207
Un cordial saludo
Mustafa

Re: Modify mdb files? [EDITED]

Posted: Sun May 15, 2016 11:46 pm
by 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!