row_number SQL Server function doesn't work on Query Generator for Formatted Searches

[Former Member]

row_number SQL Server function doesn't work on Query Generator for Formatted Searches

It triggers the error message:

1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Debe especificar la tabla en la que hacer la selección.

2). [Microsoft][SQL Server Native Client 10.0][SQL Server]No se puede preparar la instrucción o instrucciones.

'Alertas recibidas' (OAIB)

do you have any idea of how can I get de row number of a simple query?

Kind Regards,

Gabriela López León

[Former Member]

Hi Gabriela

Muito obrigado. This worked 100% for me on SAP B1 8.81 Patch level 10.

[felipe_loyolarodriguez]

Hi

CAST(ROW_NUMBER() .... AS INT) AS ROW

And it will work in SAP B1

Regards

[Former Member]

That's it! I was having the same problem. Thanks for the tip!