how to get computed column values

string ls_data
ls_data = dw_1.Object.datawindow.data
is not giving me computed field values, how to get the computed field data
also..

Thanx.
Prasadh


0
Prasadh
3/5/2003 9:07:22 PM
sybase.powerbuilder.general 62418 articles. 17 followers. Follow

11 Replies
926 Views

Similar Articles

[PageSpeed] 39

You can't get computed fields with dot notation because they are not in the
buffers. You can get them with GetItemString.

<Prasadh> wrote in message news:ydAMq114CHA.288@forums.sybase.com...
> string ls_data
> ls_data = dw_1.Object.datawindow.data
> is not giving me computed field values, how to get the computed field data
> also..
>
> Thanx.
> Prasadh
>
>


0
Jerry
3/5/2003 9:20:02 PM
You can also get them through dot notation one column at a time, by using
the name of the object explicitly, e.g.:

dw_1.object.computed_field_name.primary

Ken

"Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
news:zYEpM$14CHA.289@forums.sybase.com...
> You can't get computed fields with dot notation because they are not in
the
> buffers. You can get them with GetItemString.
>
> <Prasadh> wrote in message news:ydAMq114CHA.288@forums.sybase.com...
> > string ls_data
> > ls_data = dw_1.Object.datawindow.data
> > is not giving me computed field values, how to get the computed field
data
> > also..
> >
> > Thanx.
> > Prasadh
> >
> >
>
>


0
Ken
3/5/2003 9:57:48 PM
thanx..

so is there a way to get the computed column names alone from a datawindow,
like using describe method and column count..

Prasadh


"Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
message news:s3uNUU24CHA.288@forums.sybase.com...
> You can also get them through dot notation one column at a time, by using
> the name of the object explicitly, e.g.:
>
> dw_1.object.computed_field_name.primary
>
> Ken
>
> "Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
> news:zYEpM$14CHA.289@forums.sybase.com...
> > You can't get computed fields with dot notation because they are not in
> the
> > buffers. You can get them with GetItemString.
> >
> > <Prasadh> wrote in message news:ydAMq114CHA.288@forums.sybase.com...
> > > string ls_data
> > > ls_data = dw_1.Object.datawindow.data
> > > is not giving me computed field values, how to get the computed field
> data
> > > also..
> > >
> > > Thanx.
> > > Prasadh
> > >
> > >
> >
> >
>
>


0
Prasadh
3/5/2003 10:04:36 PM
Well, yes, you could parse the "datawindow.objects" property and check the
type of each object; but in this case you'll have to use GetItemXXX in a
loop to get the values, as the dot notation syntax I gave you can't be
constructed dynamically (i.e. it won't work with Describe).

<Prasadh> wrote in message news:Oy6#oV24CHA.263@forums.sybase.com...
> thanx..
>
> so is there a way to get the computed column names alone from a
datawindow,
> like using describe method and column count..
>
> Prasadh
>
>
> "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> message news:s3uNUU24CHA.288@forums.sybase.com...
> > You can also get them through dot notation one column at a time, by
using
> > the name of the object explicitly, e.g.:
> >
> > dw_1.object.computed_field_name.primary
> >
> > Ken
> >
> > "Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
> > news:zYEpM$14CHA.289@forums.sybase.com...
> > > You can't get computed fields with dot notation because they are not
in
> > the
> > > buffers. You can get them with GetItemString.
> > >
> > > <Prasadh> wrote in message news:ydAMq114CHA.288@forums.sybase.com...
> > > > string ls_data
> > > > ls_data = dw_1.Object.datawindow.data
> > > > is not giving me computed field values, how to get the computed
field
> > data
> > > > also..
> > > >
> > > > Thanx.
> > > > Prasadh
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
Ken
3/5/2003 10:13:27 PM
thanx ken..

what i really ment was..

for ll_ctr = 1 to long(dw_1.describe('datawindow.column.count'))
  ls_type = dw_describe('#' + string(ll_ctr) + '.XXXXXX')
end for

what should be the 'xxxxxx' value to know the this columns is a computed
column, is it type or coltype.. i hope i am clear this time

Thanx.

Prasadh


"Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
message news:PPWVDd24CHA.287@forums.sybase.com...
> Well, yes, you could parse the "datawindow.objects" property and check the
> type of each object; but in this case you'll have to use GetItemXXX in a
> loop to get the values, as the dot notation syntax I gave you can't be
> constructed dynamically (i.e. it won't work with Describe).
>
> <Prasadh> wrote in message news:Oy6#oV24CHA.263@forums.sybase.com...
> > thanx..
> >
> > so is there a way to get the computed column names alone from a
> datawindow,
> > like using describe method and column count..
> >
> > Prasadh
> >
> >
> > "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> > message news:s3uNUU24CHA.288@forums.sybase.com...
> > > You can also get them through dot notation one column at a time, by
> using
> > > the name of the object explicitly, e.g.:
> > >
> > > dw_1.object.computed_field_name.primary
> > >
> > > Ken
> > >
> > > "Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
> > > news:zYEpM$14CHA.289@forums.sybase.com...
> > > > You can't get computed fields with dot notation because they are not
> in
> > > the
> > > > buffers. You can get them with GetItemString.
> > > >
> > > > <Prasadh> wrote in message news:ydAMq114CHA.288@forums.sybase.com...
> > > > > string ls_data
> > > > > ls_data = dw_1.Object.datawindow.data
> > > > > is not giving me computed field values, how to get the computed
> field
> > > data
> > > > > also..
> > > > >
> > > > > Thanx.
> > > > > Prasadh
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
Prasadh
3/5/2003 10:29:22 PM
oops.. sorry this wont give me computed fields either..


<Prasadh> wrote in message news:Tmiuej24CHA.287@forums.sybase.com...
> thanx ken..
>
> what i really ment was..
>
> for ll_ctr = 1 to long(dw_1.describe('datawindow.column.count'))
>   ls_type = dw_describe('#' + string(ll_ctr) + '.XXXXXX')
> end for
>
> what should be the 'xxxxxx' value to know the this columns is a computed
> column, is it type or coltype.. i hope i am clear this time
>
> Thanx.
>
> Prasadh
>
>
> "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> message news:PPWVDd24CHA.287@forums.sybase.com...
> > Well, yes, you could parse the "datawindow.objects" property and check
the
> > type of each object; but in this case you'll have to use GetItemXXX in a
> > loop to get the values, as the dot notation syntax I gave you can't be
> > constructed dynamically (i.e. it won't work with Describe).
> >
> > <Prasadh> wrote in message news:Oy6#oV24CHA.263@forums.sybase.com...
> > > thanx..
> > >
> > > so is there a way to get the computed column names alone from a
> > datawindow,
> > > like using describe method and column count..
> > >
> > > Prasadh
> > >
> > >
> > > "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> > > message news:s3uNUU24CHA.288@forums.sybase.com...
> > > > You can also get them through dot notation one column at a time, by
> > using
> > > > the name of the object explicitly, e.g.:
> > > >
> > > > dw_1.object.computed_field_name.primary
> > > >
> > > > Ken
> > > >
> > > > "Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
> > > > news:zYEpM$14CHA.289@forums.sybase.com...
> > > > > You can't get computed fields with dot notation because they are
not
> > in
> > > > the
> > > > > buffers. You can get them with GetItemString.
> > > > >
> > > > > <Prasadh> wrote in message
news:ydAMq114CHA.288@forums.sybase.com...
> > > > > > string ls_data
> > > > > > ls_data = dw_1.Object.datawindow.data
> > > > > > is not giving me computed field values, how to get the computed
> > field
> > > > data
> > > > > > also..
> > > > > >
> > > > > > Thanx.
> > > > > > Prasadh
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
Prasadh
3/5/2003 10:48:51 PM
It won't work this way since .count property only holds COLUMNS not compute 
objects.
0
Philip_Salgannik
3/5/2003 11:27:05 PM
Prasadh;

    Suggestion: I use the prefix "CC_" for all computed columns. You can
even do that in your SQL ..... Select 'E' cc_language from ABC. Then it is
easy to parse out the computed column. I sometimes use "C_" for SQL and
"CC_" for the DW so that I can determine at run time which side fathered the
computed column.

 Ahhh ... standards Obe Wan! Don't leave the coding bay without them!

Regards .. Chris

<Prasadh> wrote in message news:Tmiuej24CHA.287@forums.sybase.com...
> thanx ken..
>
> what i really ment was..
>
> for ll_ctr = 1 to long(dw_1.describe('datawindow.column.count'))
>   ls_type = dw_describe('#' + string(ll_ctr) + '.XXXXXX')
> end for
>
> what should be the 'xxxxxx' value to know the this columns is a computed
> column, is it type or coltype.. i hope i am clear this time
>
> Thanx.
>
> Prasadh
>
>
> "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> message news:PPWVDd24CHA.287@forums.sybase.com...
> > Well, yes, you could parse the "datawindow.objects" property and check
the
> > type of each object; but in this case you'll have to use GetItemXXX in a
> > loop to get the values, as the dot notation syntax I gave you can't be
> > constructed dynamically (i.e. it won't work with Describe).
> >
> > <Prasadh> wrote in message news:Oy6#oV24CHA.263@forums.sybase.com...
> > > thanx..
> > >
> > > so is there a way to get the computed column names alone from a
> > datawindow,
> > > like using describe method and column count..
> > >
> > > Prasadh
> > >
> > >
> > > "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> > > message news:s3uNUU24CHA.288@forums.sybase.com...
> > > > You can also get them through dot notation one column at a time, by
> > using
> > > > the name of the object explicitly, e.g.:
> > > >
> > > > dw_1.object.computed_field_name.primary
> > > >
> > > > Ken
> > > >
> > > > "Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
> > > > news:zYEpM$14CHA.289@forums.sybase.com...
> > > > > You can't get computed fields with dot notation because they are
not
> > in
> > > > the
> > > > > buffers. You can get them with GetItemString.
> > > > >
> > > > > <Prasadh> wrote in message
news:ydAMq114CHA.288@forums.sybase.com...
> > > > > > string ls_data
> > > > > > ls_data = dw_1.Object.datawindow.data
> > > > > > is not giving me computed field values, how to get the computed
> > field
> > > > data
> > > > > > also..
> > > > > >
> > > > > > Thanx.
> > > > > > Prasadh
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
Chris
3/6/2003 1:18:09 PM
thanx for all..

i finally found there is a PFC function of_getobjects..

Thanx.
Prasadh

<Philip_Salgannik> wrote in message
news:BB04C9C831FE817C0080D2CB85256CE0.007FE22685256CE0@webforums...
> It won't work this way since .count property only holds COLUMNS not
compute
> objects.


0
Prasadh
3/6/2003 1:45:55 PM
 ls_objectlist= a_dw.describe("datawindow.objects") + "~t"
 ll_pos= pos(ls_objectlist, "~t")

 do while ll_pos > 0

  ls_object = left(ls_objectlist, ll_pos- 1)
  ls_objectlist= mid(ls_objectlist, ll_pos+ 1)
  ll_pos= pos(ls_objectlist, "~t")

  if a_dw.describe(ls_object+".type") = "compute"  then
      //do something
  end if

 loop


<Prasadh> wrote in message news:38JcXu24CHA.296@forums.sybase.com...
> oops.. sorry this wont give me computed fields either..
>
>
> <Prasadh> wrote in message news:Tmiuej24CHA.287@forums.sybase.com...
> > thanx ken..
> >
> > what i really ment was..
> >
> > for ll_ctr = 1 to long(dw_1.describe('datawindow.column.count'))
> >   ls_type = dw_describe('#' + string(ll_ctr) + '.XXXXXX')
> > end for
> >
> > what should be the 'xxxxxx' value to know the this columns is a computed
> > column, is it type or coltype.. i hope i am clear this time
> >
> > Thanx.
> >
> > Prasadh
> >
> >
> > "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> > message news:PPWVDd24CHA.287@forums.sybase.com...
> > > Well, yes, you could parse the "datawindow.objects" property and check
> the
> > > type of each object; but in this case you'll have to use GetItemXXX in
a
> > > loop to get the values, as the dot notation syntax I gave you can't be
> > > constructed dynamically (i.e. it won't work with Describe).
> > >
> > > <Prasadh> wrote in message news:Oy6#oV24CHA.263@forums.sybase.com...
> > > > thanx..
> > > >
> > > > so is there a way to get the computed column names alone from a
> > > datawindow,
> > > > like using describe method and column count..
> > > >
> > > > Prasadh
> > > >
> > > >
> > > > "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote
in
> > > > message news:s3uNUU24CHA.288@forums.sybase.com...
> > > > > You can also get them through dot notation one column at a time,
by
> > > using
> > > > > the name of the object explicitly, e.g.:
> > > > >
> > > > > dw_1.object.computed_field_name.primary
> > > > >
> > > > > Ken
> > > > >
> > > > > "Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
> > > > > news:zYEpM$14CHA.289@forums.sybase.com...
> > > > > > You can't get computed fields with dot notation because they are
> not
> > > in
> > > > > the
> > > > > > buffers. You can get them with GetItemString.
> > > > > >
> > > > > > <Prasadh> wrote in message
> news:ydAMq114CHA.288@forums.sybase.com...
> > > > > > > string ls_data
> > > > > > > ls_data = dw_1.Object.datawindow.data
> > > > > > > is not giving me computed field values, how to get the
computed
> > > field
> > > > > data
> > > > > > > also..
> > > > > > >
> > > > > > > Thanx.
> > > > > > > Prasadh
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
Ken
3/6/2003 1:47:15 PM
thanx ken.. that will do..

Prasadh


"Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
message news:yTP33m#4CHA.287@forums.sybase.com...
>
>  ls_objectlist= a_dw.describe("datawindow.objects") + "~t"
>  ll_pos= pos(ls_objectlist, "~t")
>
>  do while ll_pos > 0
>
>   ls_object = left(ls_objectlist, ll_pos- 1)
>   ls_objectlist= mid(ls_objectlist, ll_pos+ 1)
>   ll_pos= pos(ls_objectlist, "~t")
>
>   if a_dw.describe(ls_object+".type") = "compute"  then
>       //do something
>   end if
>
>  loop
>
>
> <Prasadh> wrote in message news:38JcXu24CHA.296@forums.sybase.com...
> > oops.. sorry this wont give me computed fields either..
> >
> >
> > <Prasadh> wrote in message news:Tmiuej24CHA.287@forums.sybase.com...
> > > thanx ken..
> > >
> > > what i really ment was..
> > >
> > > for ll_ctr = 1 to long(dw_1.describe('datawindow.column.count'))
> > >   ls_type = dw_describe('#' + string(ll_ctr) + '.XXXXXX')
> > > end for
> > >
> > > what should be the 'xxxxxx' value to know the this columns is a
computed
> > > column, is it type or coltype.. i hope i am clear this time
> > >
> > > Thanx.
> > >
> > > Prasadh
> > >
> > >
> > > "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote in
> > > message news:PPWVDd24CHA.287@forums.sybase.com...
> > > > Well, yes, you could parse the "datawindow.objects" property and
check
> > the
> > > > type of each object; but in this case you'll have to use GetItemXXX
in
> a
> > > > loop to get the values, as the dot notation syntax I gave you can't
be
> > > > constructed dynamically (i.e. it won't work with Describe).
> > > >
> > > > <Prasadh> wrote in message news:Oy6#oV24CHA.263@forums.sybase.com...
> > > > > thanx..
> > > > >
> > > > > so is there a way to get the computed column names alone from a
> > > > datawindow,
> > > > > like using describe method and column count..
> > > > >
> > > > > Prasadh
> > > > >
> > > > >
> > > > > "Ken Balakrishnan" <kNOSPAMbalakri@continuumperformance.com> wrote
> in
> > > > > message news:s3uNUU24CHA.288@forums.sybase.com...
> > > > > > You can also get them through dot notation one column at a time,
> by
> > > > using
> > > > > > the name of the object explicitly, e.g.:
> > > > > >
> > > > > > dw_1.object.computed_field_name.primary
> > > > > >
> > > > > > Ken
> > > > > >
> > > > > > "Jerry Siegel" <jerrys@data-sci.com.NOSPAM> wrote in message
> > > > > > news:zYEpM$14CHA.289@forums.sybase.com...
> > > > > > > You can't get computed fields with dot notation because they
are
> > not
> > > > in
> > > > > > the
> > > > > > > buffers. You can get them with GetItemString.
> > > > > > >
> > > > > > > <Prasadh> wrote in message
> > news:ydAMq114CHA.288@forums.sybase.com...
> > > > > > > > string ls_data
> > > > > > > > ls_data = dw_1.Object.datawindow.data
> > > > > > > > is not giving me computed field values, how to get the
> computed
> > > > field
> > > > > > data
> > > > > > > > also..
> > > > > > > >
> > > > > > > > Thanx.
> > > > > > > > Prasadh
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


0
Prasadh
3/6/2003 3:19:49 PM
Reply:

Similar Artilces:

to get a compute column value?
i try the following. variable = dw_1.object.computefield[1] variable = dw_1.getitemnumber(1,"computefield") both doesn't work! how can i get the compute field value? thankx. ---== Posted via the PFCGuide Web Newsreader ==--- http://www.pfcguide.com/_newsgroups/group_list.asp That should work. You could try GroupCalc() before you read the value, to ensure it has been calculated. -- Simon Caldwell Get Real Systems Ltd Holtby Manor, Stamford Bridge Road, York, YO19 5LL Tel 01904 481999 Fax 01904 481666 Visit us at www.getrealsystems.com Specialists in e-Procu...

itemchaged event:how to get compute column value
dataobject : d_1,have columns a ,b and compute c = sum(a*b for all) dw_1.dataobject = d_1 within dw_1 itemchanged event choose case dwo.name case 'a','b' long ll_value ll_value = this.getitemnumber(1,'c') //can not get right value,get values just before itemchaged ll_value = this.post getitemnumber(1,'c') //get the right value end choose Question: rather than uese post ,can i have another ways to get the sum compute values in itemchanged event? Any suggestions? Thanks Hi, I'm in doubt ...

How do you get a column value from a gridview column
How do you get a column value from a gridview column in asp.net 3.5? I tried this but it does not work.Dim myRow As GridViewRowFor Each myRow In GridView1.Rows    Dim strTest As String = DataBinder.Eval(myRow.DataItem, "EmailSubject")Nextif I change the column to a Template field then EmailSubject = myRow.FindControl("EmailSubject") works but I was hoping for a more direct way of getting a column value EmailSubject = myRow.Cells(4).Text also works but is not flexible if I change the column orderThanks Craig Try: Dim strTest As String = CType(...

How To set value of a column from a computed column
PB 5.0 I use the following statement: dw_1.object.share_cost.data[1,ll_row]=dw_1.object.a_share_cost.data[1,ll_row ] then it occur errors 'Error accessing external object property data' If I use getitemnumber function to access each row it is OK but it is too slow. How to fast the process? Jimmy April 28,2000 Hi Jimmy, This error could for one of the following reasons. 1)There may be a datatype mismatch on a column when copying. 2)Number of columns in each datawindow may not match. 3)One of the columns may have the value(Number)> 32k. PB 5.0 has a bug in dot ...

How to get GridView column values while looping through the columns?
Hi everybody, I'm trying to figure out how can I get values from DataFields while  looping through the Grid rows. Here is what I'm trying to do:GridViewRow row = null; for (int i = 0; i < this.ProfilesGrid.Rows.Count; i++ ) {row = this.ProfilesGrid.Rows[i];   CheckBox chkbtnApproved = row.FindControl("chkApproved") as CheckBox ;if (chkbtnApproved != null) {if (chkbtnApproved.Checked == true) {int RegID = (int)this.ProfilesGrid.DataKeys[i].Value ;   //PersonName = row.DataItem["FirstName"] + " " + row.DataItem["LastNam...

How to get display column value in dddw column
Using PB 9. Have a DW with a column of dddw style. Once the user selects a value in the dddw column, how can I get the data column value and the display column value? Thanks. On Nov 25, 10:15=A0am, SamRAm wrote: > Using PB 9. > Have a DW with a column of dddw style. > Once the user selects a value in the dddw column, how can I > get the data column value and the display column value? > Thanks. data value; dw_1.object.column[row] dw_1.getitem<XXX>(row, 'column') display string; ls_display =3D dw_1.describe("evaluate('lookupdisplay(column...

Get value columns value from DW Cross Tab
Is posible? Because only can get number column ... Luis Ramirez Adasme I'm not sure I understand your question. If you are trying to get a value from a column on a crosstab, you can reference each cell by its name. Names are generated at runtime but you can calculate the name based on the defined column name with a number appended to it to represent the column. This is from memory so be sure to test it. You may need to set the crosstab to static mode before referencing the values. dw_crosstab.Object.DataWindow.Crosstab.StaticMode='yes' Regards, John Team Sybas...

Using the column value of another row in computed column.
Hi fellow PBer's, I am having trouble figuring out how to reference the column value of a specific row. In the computed columns property sheet, I select the "More" button to modify the columns expression. The way I understand help is to specify columnname[integer] where integer is the number of rows (positive or negative) relative to the current row (ie Total[-1] would be the value of the Total column in the previous row. However, I cant seem to get this to compile in the modify expression painter. I am using PB5.0 on Win95. Any help would be greatly appreciated. ...

get column value in DW expression without column name
Hi everyone! I've got a common experssion that I'd like to put on every bold column property: I'd like set the column font to bold if the previous column value is equal to the current. As I have many columns, even dynamic columns, I don't know their name in order to set an expression like this: "if (col_name = col_name[-1], ...)" So any idea? Hi Matthieu, get all object names using the expression "datawindow.objects", split this tab separated list into single object names, check every object wether it is a column using the expression &quo...

Datagridview - made column visible false
In my aspnet 2.0 webpage a GRIDVIEW is placed, which is filled from datasource,I want first 2 columns (0,1) to store some Ids, user need'nt to see.But I want to access these column values later in a button click event.  markup <asp:BoundField DataField="txnId" Visible=false></asp:BoundField>         <asp:BoundField DataField="kkId" Visible=false></asp:BoundField> code behindlblMeg.Text = cart.Rows[i].Cells[0].Text;the above code returns 0:  when  Visible=true returns actual values a...

how to get the value of a hidden column/rowindex when mouse hover to a paricular column
hi gurus, sorry im new to asp.net. do you have any suggestions on how to do the above-mentioned function?i have a gridview and i would like to add a new behaviour,that is when i 'mousehover' a column a popup panel will appear.i already did the popup thing,my problem is how to get the value from one of the hidden grid column and the rowindex(currentrow-the row where 'mousehover' executes).those values will be used as a parameter on a stored procedure.this stored proc is used to populate the gridview in the popup panel. so everytime a user hover on a column the popup appears and execut...

How do I get the value of the column
So now I have the dropdowns loaded with the column names from my Excel file. I need to get the value of the selected column to instert into the database column in my stored procedure. How do I do this?         ' Create a new Adapter        Dim objDataAdapter As New OleDbDataAdapter()        ' retrieve the Select command for the Spreadsheet        objDataAdapter.SelectCommand = ExcelConnection()        ' Cre...

How do I get the value from this column?
Post edited by moderator XIII: don't use [ code ] tags as this messes up the html.Hi I am trying to retrieve some values from a database table based on a drop down list selection. This is my code: try { dsPartsListTableAdapters.PartsListTableAdapter partsAdaptor = new dsPartsListTableAdapters.PartsListTableAdapter(); DropDownList myList = (DropDownList)fvSloParts.FindControl("DropDownList1"); int number = Convert.ToInt32(myList.SelectedValue); dsPartsList.PartsListDataTable part = partsAdaptor.GetPartByPartID(number); string partCost; partCost = Conv...

get value from a compute
Hi, it 's still me. I have a computed field in a DW which X and Y properties are set by expression (col1 * X / col2 + 4 ....) In the DW clicked event, I need to get the current position of the cp field. A describe get the expression but not the value. I took a look at evaluate function but I didn't find anything. Any idea ? Take a look at the evaluate() function > Hi, it 's still me. > > I have a computed field in a DW which X and Y properties > are set by expression (col1 * X / col2 + 4 ....) > > In the DW clicked event, I need to get ...

Web resources about - how to get computed column values - sybase.powerbuilder.general

Single-photon emission computed tomography - Wikipedia, the free encyclopedia
However, it is able to provide true 3D information. This information is typically presented as cross-sectional slices through the patient, but ...


For Jacki Weaver, 'Silver Linings Playbook' finally computed
Jacki Weaver of 'Silver Linings Playbook' says it was a thrill to work with Robert De Niro in David O. Russell's quirky film.

A Lion Goes Undergoes Computed Tomography Because Even Big Cats Need a CAT Scan Every Once in a While ...
... The Leibniz Institute for Zoo & Wildlife Research (IZW) in Berlin, Germany, today inaugurates the world’s most advanced state-of-the art computed ...

The guy who found Waldo computed the longest American road trip
... Olson, a doctoral student at Michigan State, and asked him to compute one of the most complicated road trips ever. (Olson previously computed ...

Discovering How Greeks Computed in 100 B.C.
The Antikythera Mechanism organized the ancient Greek calendar in the cycles of the Olympiad, researchers say.

Technique using computed tomography associated with improved detection of lymph node metastasis in patients ...
Preoperative 3-dimensional visualization of sentinel lymph nodes (SLNs) with a technique known as single-photon emission computed tomography/computed ...

Chromatin Conformation Computed
By manipulating DNA sequences that guide genome-folding, researchers confirm an existing model of chromatin structure inside the nucleus.

Researchers use computed microtomography to identify well preserved fossil arthropod
Ludwig Maximilian University researchers have used computed microtomography (micro-CT) to identify to the species level an exceptionally wellpreserved ...

Endocranial features of Australopithecus africanus revealed by 2- and 3-D computed tomography
Department of Anatomy and Neurobiology, Washington University Medical School, St. Louis, MO 63110. The earliest hominid from South Africa, Australopithecus ...

Resources last updated: 12/19/2015 9:31:03 PM