search

ZoomApps / Liveapp

Liveapp Framework :rocket:
https://www.liveapp.com.au
2 stars 1 forks source link

"Sorting" on Table Keys #69

Closed paulfisher53 closed 6 years ago

paulfisher53 commented 6 years ago

On the table keys grid in the Table Designer, please add a new column "Sorting". This will allow the designer to add indexes like:

CREATE INDEX IX_VendorID ON dbo.ProductVendor (VendorID DESC, Name ASC, Address DESC);

For the above example, you would put the following data in the table keys grid:

Columns: VendorID,Name,Address Sorting: DESC,ASC,DESC

paulfisher53 commented 6 years ago

Hi @jaffars, please load this mod for Adam:

Fix-69.zip

paulfisher53 commented 6 years ago

Fix/mod is available for this issue

We are closing this issue as a fix/mod has been supplied.

NOTE: If the issue persists, please re-open the issue with the appropriate testing information.