Skip to Content
0
Former Member
Apr 11, 2007 at 08:31 AM

Query Syntax

42 Views

Hi Guys,

Is there any where for me to lookup information of syntax that used in queries? I know stored procedure and able to write simply query with no problem

But i encounter a syntax from other partner like:

$[ORDR.DocNum]

$[38.1.0]

/* SELECT FROM [dbo].[OFPR] T0 */

DECLARE @tdocdate as datetime

/* WHERE */

set @tdocdate /* T0.T_RefDate */ = [%1]

this is the syntax i never encounter before... But i know their function. So where can i get more information on this?

Another question:

/* SELECT FROM [dbo].[OFPR] T0 */

DECLARE @tdocdate as datetime

/* WHERE */

set @tdocdate /* T0.T_RefDate */ = [%1]

This prompts the user to enter Posting Date From parameter before query is run. Now, i want to change "Posting Date From" to "Date Start From", how do i do it? And how do i add a new parameter?

I tried to look on SAP but found nothing about this.

I hope u guys can help..

Thanks