Alpha Video Training
Results 1 to 5 of 5

Thread: Help formatting data in a dialog before submit to table

  1. #1
    Member
    Real Name
    Larry mandras
    Join Date
    Nov 2010
    Posts
    89

    Default Help formatting data in a dialog before submit to table

    I am trying to use the new Dialog features in V11. I know I can format the data in a grid in the can insert event before it is submitted to the table (w_upper(lower(<value>)), but I can't seem to find the same feature in the dialog component.

    Where do I put this type of transformation in the dialog component, I assumed it would be on the control itself?

    For example, if the users types in "test program" in the name field, I want "Test Program" submitted to the table. I see where you can set the display formatting, but not he submit formatting.

  2. #2
    Member
    Real Name
    Jim Coltz
    Join Date
    Oct 2005
    Location
    Western Pennsylvania
    Posts
    597

    Default Re: Help formatting data in a dialog before submit to table

    You can use the server side events in the Dialog to do the same formatting as you did in the grid. Look at the dialogValidate or afterDialogValidate events.
    Jim Coltz
    Alpha Custom Database Solutions, LLC
    A5CustomSolutions.com
    jimcoltz@a5customsolutions.com

  3. #3
    Member
    Real Name
    Larry mandras
    Join Date
    Nov 2010
    Posts
    89

    Default Re: Help formatting data in a dialog before submit to table

    I tried this earlier today

    e.dataSubmitted.Name = w_upper(lower(e.dataSubmitted.Name))

    but it did not work

  4. #4
    Member
    Real Name
    Jim Coltz
    Join Date
    Oct 2005
    Location
    Western Pennsylvania
    Posts
    597

    Default Re: Help formatting data in a dialog before submit to table

    Quote Originally Posted by lemandras View Post
    I tried this earlier today

    e.dataSubmitted.Name = w_upper(lower(e.dataSubmitted.Name))

    but it did not work
    A short video without sound showing it working here. Using your example.

    http://screencast.com/t/EBYF9WMLWs
    Jim Coltz
    Alpha Custom Database Solutions, LLC
    A5CustomSolutions.com
    jimcoltz@a5customsolutions.com

  5. #5
    Member
    Real Name
    Larry mandras
    Join Date
    Nov 2010
    Posts
    89

    Default Re: Help formatting data in a dialog before submit to table

    Thanks, I had it in afterDialogValidate and it did not work, it works in dialogValidate.

    Thanks again

Similar Threads

  1. Dialog component will not submit data to DBF table
    By George Morley in forum Application Server Version 11 - Web/Browser Applications
    Replies: 23
    Last Post: 02-11-2013, 12:45 PM
  2. Is it possible to populate a dialog with a data from a DBF table? Error says SQL only
    By LukeS in forum Application Server Version 11 - Web/Browser Applications
    Replies: 9
    Last Post: 12-07-2011, 10:54 PM
  3. Access DBF table data in dialog
    By russellhaggard in forum Application Server Version 10 - Web/Browser Applications
    Replies: 3
    Last Post: 08-06-2011, 04:33 PM
  4. Very basic question: getting data from dialog components into a table
    By robp in forum Application Server Version 8
    Replies: 9
    Last Post: 02-14-2008, 07:48 AM
  5. Formatting dialog box
    By Alan Lander in forum Alpha Five Version 5
    Replies: 3
    Last Post: 05-20-2004, 05:55 AM

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
  •