New call-to-action
Results 1 to 3 of 3

Thread: Calculated Fields in Grid based on SQL Table

  1. #1
    Member
    Real Name
    Wayne
    Join Date
    Aug 2009
    Posts
    129

    Default Calculated Fields in Grid based on SQL Table

    OK, I have spent alot of time on this in the sample web demo app and have searched the forums to no avail. Whenever a base a grid on a sql table, I do do not see an option on the Query page to add calculated fields. I am using AlphaDAO as recommended. Any help will be appreciated.

    Thanks

  2. #2
    Member
    Real Name
    Wayne
    Join Date
    Aug 2009
    Posts
    129

    Default Re: Calculated Fields in Grid based on SQL Table

    OK, I pretty well solved my own problem. I went to the query definition, and instead of basing on a table/view, I switched to sql select statement and (to my relief), there was a sql builder. From there, I simply created a calculated field ie, [field1] * [field2] as CalcName

    It appears you have to go upstream of the fields page to add a caclulated field (column) to a grid based on a sql table.

    Does anyone know how to simply add a blank "label" column to the sql statement, that way from the fields page, you can then enter your calculations, etc?

  3. #3
    Member Bob Moore's Avatar
    Real Name
    Robert Moore
    Join Date
    Jul 2003
    Location
    Boston, MA
    Posts
    444

    Default Re: Calculated Fields in Grid based on SQL Table

    Base the grid on a query and create a computed or virtual column within the query select statement.

Similar Threads

  1. Using calculated field on SQL based grid
    By Jay Talbott in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 11-14-2009, 02:16 PM
  2. Limitations in Lookup() based on calculated fields
    By MikeData in forum Alpha Five Version 9 - Desktop Applications
    Replies: 2
    Last Post: 04-16-2009, 11:54 AM
  3. calculated Field on Grid using SQL Backend
    By Brian Roche in forum Application Server Version 9 - Web/Browser Applications
    Replies: 0
    Last Post: 09-11-2008, 09:13 PM
  4. calculated fields in grid versus table
    By Conrad Lindes in forum Application Server Version 8
    Replies: 2
    Last Post: 12-16-2007, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •