Feathing data from access data

Former Member — Wed, 25 May 2011 03:27:49 GMT

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:

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.

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

Re: Feathing data from access data

Former Member — Wed, 25 May 2011 06:09:50 GMT

Plseae Help M.

Thanks,

Shashi