Date Calculation

[Mike Reed]

I am new to the this App Server stuff and I have a question. In an Alpha table, the field rules allow for a calculated value. For example, the table has a field called DateAdd and is set as a calculated field, with calculated field expression being if(dateadd = {}, date(), dateadd).

There is a field in the table called DateMod which is a calculated field and the field expression is simply date()

How do I do same thing in Web Component? I want the users to see the values, but not change them and to have the values assigned upon submit.

Thanks,
mike

[jkletrovets]

Re: Date Calculation

Hi Mike

The calc fields should work as they do on the desktop side. If you change the control type to "label" from "text box" it will prevent the user from making changes to that field.

I have attached a screen shot.

Regards,

Jeff

[Mike Reed]

Re: Date Calculation

I guess I didn't ask the question right. I did understand the label part, but where do I put in the calculated expression... is that some A5 five I put in, but where and how? I'm pretty new at this and I couldn't find what I was looking for in the help file. I haven't learned all the terminology yet so I don't know what to ask for.

thanks again for your response.

mike

[Al Buchholz]

Re: Date Calculation

In a grid component, look at the query dialog where you chose the table to base the grid on.

[jkletrovets]

Re: Date Calculation

Mike

You can create calculated fields where Al showed you. But, it sounds like you want to save the data, so the easiest way might be to just create a calculated field rule for the table. You can do this in the same place you define field rules for a desktop app. Most of the field rules don't work on the web side of things but auto increment and calc fields do. Once you have the calc field defined in the table you can just choose it like any other field for inclusion in your web app.

[Mike Reed]

Re: Date Calculation

In the Calculated Values section --thanks Al, I put this code in:

mgmt_co->Dateadd = if(mgmt_co->Dateadd={},date(),mgmt_co->Dateadd)
mgmt_co->Datemod = date()
mgmt_co->Timeadd = if(mgmt_co->Timeadd="",time(),mgmt_co->timeadd)
mgmt_co->timemod = time()

When I save a changed record, the date and time don't update. Sorry I'm such a pain, what am I doing wrong?

thanks,
mike

[jkletrovets]

Re: Date Calculation

Mike,

Unless I am wrong, the calculated values section inside the WAS stuff is just for displaying calc values in your grid / dialog. You would still have to save the value to your table with some xbasic in the events area of the component.

I am new to the WAS stuff as well but it seems you have to change your mindset a bit on the web side.

mgmt_co->Dateadd = if(mgmt_co->Dateadd={},date(),mgmt_co->Dateadd)
mgmt_co->Datemod = date()
mgmt_co->Timeadd = if(mgmt_co->Timeadd="",time(),mgmt_co->timeadd)
mgmt_co->timemod = time()

Where the code above works on the desktop side, I think what you are doing here is actually creating calc fields that are named whatever is on the left side of the "=" sign - not saving the values to the table. You would need some code in an event for that I believe.

Try creating the calc fields actually in the field rules area for table design and I don't think you'll have to worry about it at all. That field will just be available for use in your web component and the "back end" will handle all the updating.

Jeff