topic Macros in Application Development and Automation Discussions

Macros

Former Member — Mon, 29 Jan 2007 06:16:19 GMT

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 — Mon, 29 Jan 2007 06:35:42 GMT

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 — Mon, 29 Jan 2007 06:35:45 GMT

Hi friends,

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

Thanks,

Rajesh.