You are a Dynamics 365 Finance developer.
You have a table named FMVehicle that contains a field named Vehicleld. The table has a clustered index named Vehicleldldx on the Vehicleld field. You declare a table buffer named vehicle to refer to the table.
You need to select all records from the FMVehicle table in ascending order based on Vehicleld field in the vehicle variable.
Which embedded-SQL statement should you use?
All select statements use a table variable to fetch records. The results of a select statement are returned in a table buffer variable, here vehicle.
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-data-query
Currently there are no comments in this discussion, be the first to comment!