slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Controls | New Thread

View: Search:

Author

Thread: Format Strings for Columns in a Lookup

Dag Anderson
Posts: 6

Format Strings for Columns in a Lookup Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Dec 06 12:39 PM

I am having some junior programmer difficulty figuring out what to use as a Format String for a Column in one of my Lookups. In Architect I go to Tools -> Manage Lookups, find my Lookup and Edit it. Then I click Layout, which shows me all of the columns I am going to display. I double click on the column I care about, which is an Integer. I want to format the Integer to not display decimal places. When I tried putting %.0n in there Architect crashed with a "Format '%.0n' invalid or incompatible with argument" error.

Side Questoin - Searching Articles:
When searching from the Home Page on SLX Developer for Format String I found no Articles, then I searched on %. and "%." and found way too many. Does the search engine have esacpe characters I can use to search for %.?

Side Question - Searching Forums:
Is there a way to search all Forums at the same time or do you have to select each forum one at a time and do your search?

Thanks for any help,

Dag

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Format Strings for Columns in a Lookup Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 03 Dec 06 1:51 PM

Not sure I'll be much help with the issue of format strings in a lookup.

As far as the searching on the site goes, I am currently working on migrating the site to a new v2.0 and greatly improved site. One of the major enhancements is the ability to perform better searches. Bear with the site for now, new enhanced searching is around the corner (with the ability to include attachments to posts and the searching will even include the contents of attached files)

-Ryan

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Format Strings for Columns in a Lookup Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Dec 06 9:15 AM

Quote:

Originally posted by Dag Anderson

I am having some junior programmer difficulty figuring out what to use as a Format String for a Column in one of my Lookups. In Architect I go to Tools -> Manage Lookups, find my Lookup and Edit it. Then I click Layout, which shows me all of the columns I am going to display. I double click on the column I care about, which is an Integer. I want to format the Integer to not display decimal places. When I tried putting %.0n in there Architect crashed with a "Format '%.0n' invalid or incompatible with argument" error.

.......
Dag

Did you try #0 ?

[Reply][Quote]

Dag Anderson
Posts: 6

Re: Format Strings for Columns in a Lookup Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Dec 06 2:07 PM

#0, %.0d, %.2d, N, 9, 1234567 all do not work - they replace the data value with those entities as a constant.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/23/2024 3:11:13 AM