Feathing data from access data

[Former Member]

dear all ABAPer's

Please help me

I am feathing data from access data

when we put where clouse this query not woring.

SELECTION-SCREEN: BEGIN OF BLOCK b1 WITH FRAME TITLE text-001.

SELECTION-SCREEN: BEGIN OF BLOCK b2 WITH FRAME .

PARAMETERS : s_date TYPE zrawdata-zdate.

SELECTION-SCREEN: END OF BLOCK b2.

SELECTION-SCREEN: END OF BLOCK b1.

START-OF-SELECTION.

*****Create ADODB Object:

PERFORM progress USING 'Collecting raw data ........' '30'.

CREATE OBJECT conn 'ADODB.Connection'.

CREATE OBJECT rsdb 'ADODB.Recordset'.

*****Set connection and run query:

• MDB Connetion Infomations u2026.

CONCATENATE 'Provider=Microsoft.Jet.OLEDB.4.0;'

• ' Data Source=C:\StarDataCapture\HNGIL.mdb; Jet OLEDB:Database Password=RAWDATA'"

' Data Source=C:\New folder\HNGIL.mdb; Jet OLEDB:Database Password=RAWDATA'"

INTO sql.

CALL METHOD OF conn 'Open' EXPORTING #1 = sql.

• Query Statement ...

sql = 'SELECT * FROM HNGRAWDATA where zdata = s_date'.

how can we write where zdata = s_data

thanks

Shashi

Moderator message: please use the built-in "spell checker" function when posting.

Edited by: Thomas Zloch on May 25, 2011 10:59 AM

[Former Member]

Plseae Help M.

Thanks,

Shashi