Xdialog Currency Formatting

[Truman]

I want to use an xdialog box which include a rental field. I would like this rental field to be displayed with $ sign and commas as appropriate.

Can someone suggest how I can do this. I am trying to use [text edit control].

Thanks
Truman

[Stan Mathews]

Re: Xdialog Currency Formatting

amt = 123.45

? str(amt,7,2,"$(B")
= "$123.45"

amt = 121113.45


? alltrim(str(amt,19,2,"$(B"))
= "$121,113.45"

[Truman]

Re: Xdialog Currency Formatting

Hi Stan

Thanks for your prompt reply, but I think that I did not state my problem correctly. The attached file shows the code I am using to edit a rent payment record. My problem is how to format the rent variable in currency values and allow the user to change the values which then are added to the table.

Are you suggesting that I can insert the str(...) command in my xdialog?

Thanks
Truman

[Stan Mathews]

Re: Xdialog Currency Formatting

Don't see a way to do that. Maybe something like the attached screenshot would do?

[Truman]

Re: Xdialog Currency Formatting

Thanks Stan

That is a clever idea.

A least you confirmed what I was afraid I found out - you can't do it.

I guess what is needed is a directive like %TF= %" for currency and number formating. I would have thought that xdialog would have all the formating properties that are available for fields in a form.

Thanks again
Truman

[G Gabriel]

Re: Xdialog Currency Formatting

Here is how you do it:

ui_dlg_box("rent",<<%dlg%

	{region}
	{lf};
	Change information in the Fields.
	{endregion};
	{frame=1,1}
	{region}
	Payment Date: | [.14vdate];
	Rent: | [.50vpayment!pmt_*];
	Comment: | [.75vComment];
	{endregion};
	{lf};
	{justify=right}
	<10&OK!ok> <10&Cancel!cancel>;
	 %dlg%,<<%code%
	       if a_dlg_button = "pmt_killfocus"
	       	        a_dlg_button=""
	       vpayment=ltrim(str(val(vpayment),15,2,"$,"))
	else
	a_dlg_button=""
	end if
	%code%)

[Tom Cone Jr]

Re: Xdialog Currency Formatting

Maybe you should post a "wishlist" item requesting a smart "currency" control? -- tom

[G Gabriel]

Re: Xdialog Currency Formatting

Maybe you should post a "wishlist" item requesting a smart "currency" control? -- tom

Doesn't alpha already have that? Isn't called a form? An xdlg with smart controls?

[Tom Cone Jr]

Re: Xdialog Currency Formatting

... for xdialogs, of course.

[G Gabriel]

Re: Xdialog Currency Formatting

Yes Tom, I totally understand what you mean....my point is, by the time alpha does that (smart controls for xdlg, drag and drop fields..etc) it ends up being, what else? a form.

[Truman]

Re: Xdialog Currency Formatting

Yes Tom, I totally understand what you mean....my point is, by the time alpha does that (smart controls for xdlg, drag and drop fields..etc) it ends up being, what else? a form.

I understand what you are saying - there are limits to what you can add to xdialog. I already can change fonts, size, color, format date BUT I can't format numbers. I don't understand why you can't format numbers. Is that too much to hope for?

Cheers
Truman

[G Gabriel]

Re: Xdialog Currency Formatting

Have you tried the script I gave you?

[Truman]

Re: Xdialog Currency Formatting

I have had a first go at your script.

It works but still causes a bit of a work around. Intially vpayment was numaric so it seems that I have to convert vpayment to character and then when I replace the field I will have to convert it back to numaric. A minor problem is that I will also have to use your script to convert vpayment to currency format for the first time the xdialog opens.

Thanks. I really had not thought of, or perhaps not had an idea how to program, the little function you suggested.

Cheers
Truman

[Tom Cone Jr]

Re: Xdialog Currency Formatting

Truman, commas and dollar signs are not "numeric" values as far as the computer is concerned. To display them the computer must convert "numeric" to character strings, and vice versa. You can "format" the "display" of a number, but you can't do that without working with character type data.

[Truman]

Re: Xdialog Currency Formatting

Truman, commas and dollar signs are not "numeric" values as far as the computer is concerned. To display them the computer must convert "numeric" to character strings, and vice versa. You can "format" the "display" of a number, but you can't do that without working with character type data.

I knew that. Now why didn't I think of that?!

Maybe I just have to use a form (sort of Gabriel's comment).

Thanks