How I can get the column header name when i clicked on the concerned column headerHi All
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.
thanks
vasu
Vasu:
You will want to code this in the clicked event.
You can look at GetBandatPointer() and GetObjectatPointer() functions in
help.
HTH,
Austin
"vasu" <vasu@i-vantage.com> wrote in message
news:UfS3lsO2CHA.345@forums.sybase.com...
...
Get a columns column numberHi All.
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
simpler way!).
n_cst_string lnv_cst_string
String ls_columns
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 =
inv_cst_string.of_CountOccurrences(Left(ls_columns, ll_pos2
- 1) , '~t', TRUE) + 1
dw_1.setItem(ll_newRow, 'intcolumnno', ll_columnNo)
Thanks
MB.
You want the "ID" property,...
Can you get rid of the Black Background when you click on a column header in a Grid datawindowIs 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
Regards
Colin
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
missed.
Do you have any idea?
Charles
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 NameThis 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
date.
Any help is appreciated!!
Thanks!!
William
dw.Describe("effective_date.ID")
Good Luck
Michael Walker
Cascadia Software
William_Shiers wrote:
> 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?Hi,
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?
Bo Song
soong@188.net
Hi Bo,
AFAIK, you cannot reference object properties in the expression. That would
be nice...
--
- Eric Aling [TeamPS], Cypres Informatisering bv, The Netherlands
Eric's Home & PB Site @ http://utopia.knoware.nl/users/cypr115
Bo Song <soong@188.net> wrote in message 36D52106.433CE9B2@188.net...
>Hi,
>I have a free style data...
How to know the Column number based on Column header in Grid View
Hi
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)...
Thanks
Archan
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)
{
break;
}
idx++;
}
return idx;
} Mark replies as answers if they helped you solve the problem.
Hi siva
Thanks for your ...
How to get the column header value in the datawindowHi All
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
thanks
Assuming the header is a static text object, dwo.Text
"venu" <pkkrao1@rediffmail.com> wrote in message
news:YBc1M7n2CHA.263@forums.sybase.com...
> 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 ?
Pls advice
steven
try copy it from PFC function
"steven" <stvhui@yahoo.com> wrote in message
news:fNYZJGCECHA.70@forums.sybase.com...
> Hello to you,
>
> How to code, When clicked DataWindow Column Header then sort ?
>
> Pls advice
> steven
>
>
>
...
datawindow.column.count not returning the column count of a datawindowI 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.
HTH
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
Hi experts,
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
go
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 datawindowHi !!
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
change
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.
Dharani Babu
adharani@ssind.stpn.soft.net
...
Getting datatype of clicked Datawindow column in window scriptI 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.
Regds..
Vai
dwo.coltype
--
All views expressed in this message are my own and not necessarily those of
my employer
<vai> wrote in message
news:0B134DC9DCE2A0FF0048F38F85256BA5.0048F3BC85256BA5@webforums...
> 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
...