XB to view the properties card for a specified table

[MoGrace]

Re: XB to view the properties card for a specified table

Here's my UDF to make the A5 function give the right picklist:

FUNCTION tbl_info AS C (tablename AS C )
	dim shared tbl_name as c
	tbl_name = tablename
	tbl_info = a5_display_tableset_info(tbl_name)	
END FUNCTION

[Ted Giles]

Re: XB to view the properties card for a specified table

Thanks Robin.

[csda1]

Re: XB to view the properties card for a specified table

Here's my UDF to make the A5 function give the right picklist:

Hi Robin,

Get rid of the word shared in the function. It serves absolutely no purpose here and can actually cause problems. Read my tips on Variable dimensioning.

FUNCTION tbl_info AS C (tablename AS C )
	dim [COLOR="#FF0000"]shared[/COLOR] tbl_name as c
	tbl_name = tablename
	tbl_info = a5_display_tableset_info(tbl_name)	
END FUNCTION

[MoGrace]

Re: XB to view the properties card for a specified table

Hi Ira,
I only did that because the var passed into the function argument is shared (I think), and that was the original var I was using til you mentioned using a keyword to get a picklist. I figured if one was shared, then the var I passed it to ought to be too! Wimmen's logic is a bit different you know ;-)

It's nice to know I am not stuck with just my own ideas on the things I don't know!

[csda1]

Re: XB to view the properties card for a specified table

Hi Robin,

I only did that because the var passed into the function argument is shared (I think), and that was the original var I was using til you mentioned using a keyword to get a picklist. I figured if one was shared, then the var I passed it to ought to be too!

A function's definition parameters are all local values (unless passing a pointer, array pointer or using BYREF keyword). Each usage of the function has that parameter (either expression or a constant) value passed to the function's local value/name (actually it's on a stack physically)

[Ted Giles]

Re: XB to view the properties card for a specified table

Mornin' Ira.
What I want to achieve, in one line of code, is the population of a Calculated Field displayed on a Form with a Tabbed Object.
The Tabbed object has the following Tabs text.
Customer/Address/Contact Details

I have played with the following components and cannot get the ducks in a row as they say.

[Tabbed1.Tab_Get()] Gives me the tab number
[Tabbed1.tabs.sheet.text] Gives me the tab text - but only the first tab. Changing tabs does not change the value in the cal field, nor does Refresh
So I looked at
[Tabbed1.tabs.sheet.Tab_Get().text] which should work but doesn't - well I cannot get it to.

Any help would be appreciated. If it has to be multi line code then so be it, but the aim is to get it in a Calc field.

[Tim Kiebert]

Re: XB to view the properties card for a specified table

Ted,

I got a single line expression to work but not in the regular calculated field area of the form. Trying to make a calc field with the expression gave me an error that the field could not be found.

Tabbed1.Tabs.Sheet[Tabbed1.tab_get()].Text

I placed a regular old text object on the form and then using the dynamic properties of the object's text property found in the properties taskpane/tasklist I used the above expression. This seems to do what you want.

[Ted Giles]

Re: XB to view the properties card for a specified table

Hi Tim, thanks. I wouldn't have thought of that approach.
In V10, the Tabbed1.Tabs.Sheet[Tabbed1.tab_get()].Text works but doesn't refresh unles it is done manually.
It was the placing of the square brackets which stumped me!
I'll post this where it will be found more easily.