How I can get the column header name when i clicked on the concerned column header
I had a problem in getting the columnheader name . I had tried with
dw.getcolumnname but not successfull .
I was in very big dilema where to write the code(i mean what 'event') .
Suppose i had a fullname as my columnheader then i should able to get the
fullname when i click on that column.
You will want to code this in the clicked event.
You can look at GetBandatPointer() and GetObjectatPointer() functions in
"vasu" <email@example.com> wrote in message
...Get a columns column number
How do I get the number of a column in a datawindow (PB9.0).
The best I can come up with is as follows (there must be a
Long ll_pos2, ll_columnNo
ls_columns = idw_dw.Describe( 'datawindow.table.columns' )
ll_columnNo = 0
ll_pos2 = Pos(ls_columns, ls_columnName)
If ll_pos2 > 0 Then ll_columnNo =
- 1) , '~t', TRUE) + 1
dw_1.setItem(ll_newRow, 'intcolumnno', ll_columnNo)
You want the "ID" property,...Can you get rid of the Black Background when you click on a column header in a Grid datawindow
Is there anyway of getting rid of the black background when you click on a
column header in a grid datawindow. I am using the PFC sort service and I
find the black background a nuisance. I still need to be able to move and
resize colums so turing the grid off is not an option.
I have mouse selection turned off but this only prevents the individual
columns from turning black and it doesn't make any difference if you click
on the column header.
I am using PB 6.5.1
Right-click the datawindow background, and bring up the properties dialog.
Uncheck the &qu...How can I get the column name of a datawindow column?
I want to get the column name in tablename.columnname format. I have tried
to get it using dbname property. However, I found that it work only if the
tables in the datawindow are inner join. If the tables in the datawindow
are outer join, the dbname only return the columnname and the tablename is
Do you have any idea?
You could add the name to the select clause or to the tag property. Or you
caould check to see if it is a join or not (by seeing if there is a '.' in the
column name) if not then get the sql select statment and parse to find the
table...Get Column Number Using Column Name
This ones burning me because, I am sure i've done it before and It's simply
slipping my mind.
I need to be able to get a column number using the column name.
i.e. Column name = 'effective_date'.
Using effective date - get the column number that belongs to effective
Any help is appreciated!!
> This ones burning me because, I am sure i've done it before and It's simply
> slipping my mind.
...How to get a column property in a datawindow column object expression?
I have a free style datawindow, I want such expression:
columnA.x = IF(columnB.visible, columnB.x + 100, 200)
Yes, you can get it in script, but I just want set it in datawindow.
Anyone can help?
AFAIK, you cannot reference object properties in the expression. That would
- Eric Aling [TeamPS], Cypres Informatisering bv, The Netherlands
Eric's Home & PB Site @ http://utopia.knoware.nl/users/cypr115
Bo Song <firstname.lastname@example.org> wrote in message 36D52106.433CE9B2@188.net...
>I have a free style data...How to know the Column number based on Column header in Grid View
I have a gridview with 3 columns. Say : id, Name and skill.
I want to know the column number of Column headers(May be Name,Skill or id)...
I don't think there is any inbuilt way to do it. You have to loop through and compare the header text and get the index. private int GetColumnIndex (string headerText)
int idx = 0;
foreach (DataControlField gcf in GridView1.Columns)
if (gcf.HeaderText == headerText)
} Mark replies as answers if they helped you solve the problem.
Thanks for your ...How to get the column header value in the datawindow
I had problem regarding the column header number in datawindow . I mean that
i want to get the column header value whenever i click on the
column header, i was able to get the column header name with ("dwo.name").
Is there any chance of getting the column header value with
dwo or other event plz help me
Assuming the header is a static text object, dwo.Text
"venu" <email@example.com> wrote in message
> Hi All
> I had problem regarding the column header number in datawindow . ...When is a column not a column?
I have several extremely similar datawindows that I have to maintain that go
against the same table. Recently, I had to add a column to that table, and
also add the column to ALL of these datawindows that go against this table.
I added the column to the first datawindow, set up the edit control style,
etc. I then did a copy/paste of the columns edit control to the remaining
dw's (of course remembering to first add the column in SQL). Everything
(update props, column specs, column props) seems to indicate that the pasted
column is linked to the column I selected, HOWEVER, when I...How to code, When clicked DataWindow Column Header then sort ?
Hello to you,
How to code, When clicked DataWindow Column Header then sort ?
try copy it from PFC function
"steven" <firstname.lastname@example.org> wrote in message
> Hello to you,
> How to code, When clicked DataWindow Column Header then sort ?
> Pls advice
...datawindow.column.count not returning the column count of a datawindow
I am having problems with the datawindow.column.count property of a
datawindow. It just started happening with PB 6.501 and still works
fine in PB 5.0. The function that looks at this property is in an
ancestor userobject. The dataobject is assigned at this point but all
other properties of the datawindow are missing. Any suggestions?
Don't recall, but was it still dwDescribe() in version 5.0? If it was that
may be your problem.
Kent Montgomery wrote:
> I am having problems with the datawindow.column.count property of a
> datawindow. It just started happenin...Get highest number from a Column by Passing Table/ Column Name as Parametre: Stored Procedure
I want to fetch the Maximum ID + 1, of a Column( say Max ID = 7 currently so query should return 8) , & I want to do it for many table
I m using set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[SP_GENERATEID]
@TableName VarChar(50),@ColumnName numeric(10, 0)
ASset nocount on set ansi_warnings off
DECLARE @sql nvarchar(2000)
SET @sql = 'select isNull(MAX('+ @ColumnName+'),'+ 0 + ')'+ 1 + 'from'+ @TableName EXEC (@sql)
My store procedure is ready but when I...Getting column's header in a Crosstab datawindow
My problem is as follows
I have made a cross tab datawindow. In that i want to change the column headers
at runtime. How could i get cloumn header name(it will vary at runtime) and
it at runtime. One thing is that i can't use column expression because i have to
get the value from other table.
Thanks in advance.
...Getting datatype of clicked Datawindow column in window script
I want to know the datatype of the clicked datawindow column in script
where user clicked. For e.g there is a column 'acccd' in datawindow and
user clicks on that, i want to know its datatype.
All views expressed in this message are my own and not necessarily those of
<vai> wrote in message
> I want to know the datatype of the clicked datawindow column in script
> where user clicked. For e.g there is a column 'acccd' in datawindow and