Macros

[Former Member]

Hi all,

Iam using a sql statement to retrieve records for a particular period in macros.

My sql statement is as follows:

sSql = sSql & " WHERE (FKDAT Like '" & Sheet1.Cells(3, 2) & "%') " & vbCrLf 'Invoice Date

The from-date is in cell(3, 2) and the to-date In (3, 3). I able to use only one date.

Please help to me to get the correct statement,

Raj.

[Former Member]

Use of MAcros -

DEFINE fetch_data.

select * from mara into table &1 up to 20 rows.

END-OF-DEFINITION.

tables mara.

data: begin of itab occurs 0.

include structure mara.

data end of itab.

Fetch_data ITAB.

loop at itab.

write:/ itab-matnr.

endloop.

[Former Member]

Hi friends,

How to use a in operator instead fo a like operator in the sql statement.

Thanks,

Rajesh.