Dear Halty,
Presuming your Table_A name is PropTable, the following syntax might do the
thing.
Dim MyColumn As String
Dim MyAlias As Alias
Dim i, j As Integer
Dim Current_Prop_Value, ObjProportion As Float
j = TableInfo(colunmtable, TAB_INFO_NROWS)
For i = 1 To j
Fetch Rec i From columntable
MyColumn = columntable.columnname
MyAlias = "PropTable." & MyColumn
Current_Prop_Value = ObjProportion * MyAlias
Next
You can also try using syntax:
MyAlias = MyTable & "." & MyColumn
Where variable MyTable is containing name of your open table.
Regards,
Anssi
>At 15:11 22.3.1999 -0800, you wrote:
>
>
>Halty Barrett@GAPINC
>03/22/99 03:11 PM
>Hi
> I was hoping someone can help me with this:
>
>I am trying to do something that seems very simple. I am trying to calculate
>the product of a constant and a record's value. The code looks like this:
>
> <Current_Prop_Value = ObjProportion * Table_A.variable>
>
>variable is an alias type variable for an array of column names (all are float
>columns)
>Current_Prop_Value is a float variable
>ObjProportion is a float value
>
>Table_A.variable is referring to a column in Table_A, but this code is
nested in
>a do...loop and the column name changes with each iteration. What is the syntax
>for this simple piece of code? Can anyone help?
>
>Regards,
>Halty Barrett
>[EMAIL PROTECTED]
>
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
