Community
Showing results for 
Search instead for 
Do you mean 
Reply

Feature Request

Bronze Super Contributor
Posts: 1,231
Country: USA

Feature Request

Create an ACTFieldType of VIRTUAL.  In the field descriptor allow the field selected portion of the select string to be edited. This way we can use SQL Functions:

 

Math function:

CAST(ROUND(SalesYTD/CommissionPCT, 0) AS int) AS Computed

 

It could replace my previous request for GUID type fields since we could create our own ID field using characters

CAST(PARTSIDFIELDas uniqueidentifier) 

 

Think of all the DateDiff functions it would open up:

DATEDIFF(day, OrderDate, GETDATE()) AS NumberOfDays

 

Date aging:

DATEDIFF(dd, [User].DOB, GetDate())  / 365) as YearsOld

 

This would be helpful for many places such as math, date aging, reporting! and any other tool accessing the ACTOLEDB2.1 reader!

 

When building the SQL string from the field descriptors it would look like this

Select Contact, City, State, Zip, CAST(ROUND(SalesYTD/CommissionPCT, 0) AS int) AS Computed from Contacts.

 

 

Thanks for your time.

-- Jim Durkin

 

 

 

Nickel Elite Contributor
Posts: 937
Country: USA

Re: Feature Request

Interesting