INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Help Files  (Read 1567 times)

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20062
Help Files
« on: September 24, 2005, 03:54:48 pm »

The New Smart List Options Did Not Make It To The Help Files

Like:

Mid([Artist], 0, 1)\[Artist]
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: Help Files
« Reply #1 on: September 24, 2005, 04:23:14 pm »

Go to:

View files, schemes and libraries > View Files and Libraries > Customize List and/or Thumbnail View

There is a link to the database expressions page in the "columns to show" section.

I don't think there are any usage examples for expressions, nor any detail about their limitations and application in other areas of MC.

There's a link to this thread in the WELCOME ***FAQ*** sticky too.

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20062
Re: Help Files
« Reply #2 on: September 24, 2005, 04:52:59 pm »

there is another theard i started when matt put this in mc11

it would be nice if the samples would have hit the help file

as a matter of fact the sample above should be one of the built in rules
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: Help Files
« Reply #3 on: September 24, 2005, 05:07:24 pm »

Quote
it would be nice if the samples would have hit the help file
indeed it would.

lise

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 946
Re: Help Files
« Reply #4 on: February 09, 2006, 12:51:43 pm »

Hey KingSparta,

I tried your rule, and get to results (granted, I'm working with a very small 'test' database right now).

Can't find info on "Mid". What does the rule mean so that I can include it in the help file?
Any other rules missing that you can think of?

lise
Logged
A wise man once said don't count your years, but make your years count. Or was it beers?

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20062
Re: Help Files
« Reply #5 on: February 09, 2006, 12:58:11 pm »

Matt kind of changed it a bit in MC and i am not sure why, but the text below is much the same.

The text is from Microsofts visual basic's help file and can be found on the internet

Quote
Mid Function
Description

Returns a specified number of characters from a string.

Syntax

Mid(string,start[,length])

The Mid function syntax has these parts:

Part
 Description
 
string
 String expression from which characters are returned. If string contains no valid data, Null is returned.
 
start
 Character position in string at which the part to be taken begins. If start is greater than the number of characters in string, Mid returns a zero-length string.
 
length
 Number of characters to return. If omitted or if there are fewer than length characters in the text (including the character at start), all characters from the start position to the end of the string are returned.
 
Remarks

To determine the number of characters in string, use the Len function.

Note

Another function (MidB) is provided for use with the double-byte character sets (DBCS) used in some Asian locales. Instead of specifying the number of characters to return, length specifies the number of bytes. In areas where DBCS is not used, MidB behaves the same as Mid.

See Also

Left Function; Len Function; LTrim, RTrim, and Trim Functions; Mid Statement; Right Function.

Example

This example uses the Mid function to return a specified number of characters from a string.

MyString = "Mid Function Demo"    ' Create text string.
FirstWord = Mid(MyString, 1, 3)    ' Returns "Mid".
LastWord = Mid(MyString, 14, 4)    ' Returns "Demo".
MidWords = Mid(MyString, 5)    ' Returns "Function Demo".
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42325
  • Shoes gone again!
Re: Help Files
« Reply #6 on: February 09, 2006, 01:06:20 pm »

Logged
Matt Ashland, JRiver Media Center

JimH

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 72380
  • Where did I put my teeth?
Re: Help Files
« Reply #7 on: February 09, 2006, 01:10:04 pm »

Hi Lise,
The Help file could just link to that page.

Jim
Logged

KingSparta

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 20062
Re: Help Files
« Reply #8 on: February 09, 2006, 01:18:25 pm »

yes, that looks like it is full of good info.
Logged
Retired Military, Airborne, Air Assault, And Flight Wings.
Model Trains, Internet, Ham Radio, Music
https://MyAAGrapevines.com
https://centercitybbs.com
Fayetteville, NC, USA

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: Help Files
« Reply #9 on: February 09, 2006, 01:33:34 pm »

As I mentioned above, there is already a link to that page in there. I found it there by searching the for expression.
I think that Database expressions should get their own little chapter in the help file, where a little of what is possible, and areas of the program where they are permitted (or not, whatever's easier) plus a link to the devzone page can be shown.

You can do so much more with expressions than simply using them to add a filelist column

The formatdate info on the devzone page is out of date:
Quote
FormatDate(...): Formats a date value in a specified manner.

Value: the date to format
Formatting: formatting style

Year: 1997
Month: March
Day: 12
Filename: 20040521-032221
Elapsed: 3.2 days ago
Other: flexible formatting (i.e. MMMM-d)

No Date Output: the output when the date is empty (optional: defaults to nothing)

Examples:
FormatDate([Date Imported], elapsed)
FormatDate([Date], MMMM: d, no date)
Pages: [1]   Go Up