Skip to Content
0
Jun 18, 2009 at 04:08 PM

Ole automation for update data in MS Access

52 Views

I all,

i have this problem:

i wont modify one or more record in a db ACCESS, i can insert, i can select but i can't modify or delete.

-i use this code for insert: sql = 'INSERT INTO [ZDEBUGGER] (NUMERO, FLAG) VALUES(4, 3)'. it's work fine

CALL METHOD OF rec 'open'

EXPORTING #1 = sql

#2 = con

#3 = '1'.

-for modify: sql = 'UPDATE ZDEBUGGER set flag = 2 where numero = 3'. it's do not work.

CALL METHOD OF rec 'open'

EXPORTING #1 = sql

#2 = con

#3 = '1'.

please, help me?