Take the name of the field from multi-row query

<a href="https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;" onclick="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;">

Could I take the Column Names from a multi-row query ? If so, how to do it ? Thanks.

Hi Louis,

Thank you for your response, but I am sorry that I don't understand your answer. Maybe you can explain to me more specific,  because I am a beginner for VisualAge programming.

PT TASPEN (PERSERO)

Kepala SPIDA Surabaya,

JULI PERMANA A.

NIK. 1685

2014-10-09 21:01 GMT+07:00 Louis LaBrunda <<a href="javascript:" target="_blank" gdf-obfuscated-mailto="jDuI6K3XLX4J" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">L...@...>:

Hi Juli,

This works with ODBC but I think it should work for the others:

multiRowQuery resultTable rows first columnNames

Lou

On Thursday, October 9, 2014 4:35:22 AM UTC-4, Juli Permana wrote:

<a href="https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;" onclick="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;">

Could I take the Column Names from a multi-row query ? If so, how to do it ? Thanks.

--
You received this message because you are subscribed to a topic in the Google Groups "VA Smalltalk" group.
To unsubscribe from this topic, visit <a href="https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe" target="_blank" onmousedown="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;" onclick="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;">https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="jDuI6K3XLX4J" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">va-smalltalk...@googlegroups.com.
To post to this group, send email to <a href="javascript:" target="_blank" gdf-obfuscated-mailto="jDuI6K3XLX4J" onmousedown="this.href='javascript:';return true;" onclick="this.href='javascript:';return true;">va-sma...@....
Visit this group at <a href="http://groups.google.com/group/va-smalltalk" target="_blank" onmousedown="this.href='http://groups.google.com/group/va-smalltalk';return true;" onclick="this.href='http://groups.google.com/group/va-smalltalk';return true;">http://groups.google.com/group/va-smalltalk.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/optout.

Hi Juli,

You are welcome.  I will try to explain things better. 

multiRowQuery resultTable rows first columnNames

multiRowQuery is the name of a variable that contains your multiRowQuery.  It might also be accessed with something like:

(self subpartNamed: 'My MultiRowQuery') if you placed a MultiRowQuery part in the white space and named it "My MultiRowQuery".  Once you have access to the query and after you have executed the query with #executeQuery or #executeQueryAsTransaction sending the query #resultTable will get you the results of executing the query.  The result table will contains the rows retrieved by the query.  Sending the result table #rows will get the rows.  All the rows contain the names of the columns.  Sending rows #first will get you the first row.  Sending the row #columnNames will get you a collection of the column names.  That should be it.  Please ask again if this still isn't clear of if you are doing things differently and aren't sure how to get to the query.

Lou

On Friday, October 10, 2014 8:08:55 AM UTC-4, Juli Permana wrote:

Hi Louis,

Thank you for your response, but I am sorry that I don't understand your answer. Maybe you can explain to me more specific,  because I am a beginner for VisualAge programming.

PT TASPEN (PERSERO)

Kepala SPIDA Surabaya,

JULI PERMANA A.

NIK. 1685

2014-10-09 21:01 GMT+07:00 Louis LaBrunda <[hidden email]>:

Hi Juli,

This works with ODBC but I think it should work for the others:

multiRowQuery resultTable rows first columnNames

Lou

On Thursday, October 9, 2014 4:35:22 AM UTC-4, Juli Permana wrote:

<a href="https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;" onclick="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;">

Could I take the Column Names from a multi-row query ? If so, how to do it ? Thanks.

--
You received this message because you are subscribed to a topic in the Google Groups "VA Smalltalk" group.
To unsubscribe from this topic, visit <a href="https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe" target="_blank" onmousedown="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;" onclick="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;">https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to va-smalltalk...@googlegroups.com.
To post to this group, send email to [hidden email].
Visit this group at <a href="http://groups.google.com/group/va-smalltalk" target="_blank" onmousedown="this.href='http://groups.google.com/group/va-smalltalk';return true;" onclick="this.href='http://groups.google.com/group/va-smalltalk';return true;">http://groups.google.com/group/va-smalltalk.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/optout.

Hi Juli,

I'm not sure what you are trying to accomplish but for now I will assume you are just playing a bit to learn.  That said I have a few suggestions on how to clean things up a bit (simplify) that may make it easier to see what is going on.  First you can remove all of the following from the white space, "Ordered Collection1", "size of Ordered Collection1" and "self of size of Ordered Collection1".  I will tell you how to replace then shortly.  You can also remove your process method.  Instead connect the clicked event to the execute action of the query.  Tear off the columnNames attribute of the currentRow and drop it in the white space.  Then connect the size attribute of that collection to your columns display field/label.  Also connect the columnNames attribute directly to the items attribute of your list part.

As to your question about two databases, I assume you mean two database tables.  The answer is basically yes for both but two databases is more complicated that two tables and both are tricky and you should proceed with caution.  You would need two queries, pointing to the two tables/databases.  I try not to be using/changing two rows/tables/databases at the same time.

Lou

On Sunday, October 12, 2014 12:16:30 PM UTC-4, Juli Permana wrote:

<a href="https://lh3.googleusercontent.com/-7Jwp5HKgY1A/VDqgq5VBe4I/AAAAAAAAAG8/LN7SMlwZ_-Y/s1600/ColumnNames-5.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh3.googleusercontent.com/-7Jwp5HKgY1A/VDqgq5VBe4I/AAAAAAAAAG8/LN7SMlwZ_-Y/s1600/ColumnNames-5.jpg';return true;" onclick="this.href='https://lh3.googleusercontent.com/-7Jwp5HKgY1A/VDqgq5VBe4I/AAAAAAAAAG8/LN7SMlwZ_-Y/s1600/ColumnNames-5.jpg';return true;">

<a href="https://lh3.googleusercontent.com/-mxGutnQ-1KA/VDqfqcRz0XI/AAAAAAAAAG0/48NWAAbILMc/s1600/ColumnNames-2.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh3.googleusercontent.com/-mxGutnQ-1KA/VDqfqcRz0XI/AAAAAAAAAG0/48NWAAbILMc/s1600/ColumnNames-2.jpg';return true;" onclick="this.href='https://lh3.googleusercontent.com/-mxGutnQ-1KA/VDqfqcRz0XI/AAAAAAAAAG0/48NWAAbILMc/s1600/ColumnNames-2.jpg';return true;">

Hi Louis,

I've understand with your explanation and I've made a visual part (ExtractColumnNames) as shown in the first image above. The column names appear directly on each text-box when I test this visual part, though I have not clicked the PROCESS button (the second image), because I've connected the columns in Packeting Container Details1 to each text-box (Column-1 Name, Column-2 Name, etc).

The PROCESS button has script as: 

Process
| a1 |
(self subpartNamed: 'qPeserta') executeQuery.
a1 := (self subpartNamed: 'currentRow of resultTable of qPeserta') abtAtAttribute: #columnNames.
(self subpartNamed: 'List1') items: a1.

As shown in the first image, I send the items to Ordered Collection 1 and then I get a number of items. A further question is how do I code the VAST script to get the items from Ordered Collection 1 (which contains the column names from the Lists Part) and send it to each text-box (Column-1 Name, Column-2 Name, etc.) ?

By the way ... Could I open two databases (remote db and local db) in a VAST application ? If so, how ? 

Thank you.

Juli Permana A.

Pada Jumat, 10 Oktober 2014 22:45:27 UTC+7, Louis LaBrunda menulis:

Hi Juli,

You are welcome.  I will try to explain things better. 

multiRowQuery resultTable rows first columnNames

multiRowQuery is the name of a variable that contains your multiRowQuery.  It might also be accessed with something like:

(self subpartNamed: 'My MultiRowQuery') if you placed a MultiRowQuery part in the white space and named it "My MultiRowQuery".  Once you have access to the query and after you have executed the query with #executeQuery or #executeQueryAsTransaction sending the query #resultTable will get you the results of executing the query.  The result table will contains the rows retrieved by the query.  Sending the result table #rows will get the rows.  All the rows contain the names of the columns.  Sending rows #first will get you the first row.  Sending the row #columnNames will get you a collection of the column names.  That should be it.  Please ask again if this still isn't clear of if you are doing things differently and aren't sure how to get to the query.

Lou

On Friday, October 10, 2014 8:08:55 AM UTC-4, Juli Permana wrote:

Hi Louis,

Thank you for your response, but I am sorry that I don't understand your answer. Maybe you can explain to me more specific,  because I am a beginner for VisualAge programming.

PT TASPEN (PERSERO)

Kepala SPIDA Surabaya,

JULI PERMANA A.

NIK. 1685

2014-10-09 21:01 GMT+07:00 Louis LaBrunda <[hidden email]>:

Hi Juli,

This works with ODBC but I think it should work for the others:

multiRowQuery resultTable rows first columnNames

Lou

On Thursday, October 9, 2014 4:35:22 AM UTC-4, Juli Permana wrote:

<a href="https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;" onclick="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;">

Could I take the Column Names from a multi-row query ? If so, how to do it ? Thanks.

--
You received this message because you are subscribed to a topic in the Google Groups "VA Smalltalk" group.
To unsubscribe from this topic, visit <a href="https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe" target="_blank" onmousedown="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;" onclick="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;">https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to va-smalltalk...@googlegroups.com.
To post to this group, send email to [hidden email].
Visit this group at <a href="http://groups.google.com/group/va-smalltalk" target="_blank" onmousedown="this.href='http://groups.google.com/group/va-smalltalk';return true;" onclick="this.href='http://groups.google.com/group/va-smalltalk';return true;">http://groups.google.com/group/va-smalltalk.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/optout.

Hi Louis,

Once again I thank you for your help. The method you provided is working well.

You are correct that I'm still learning VAST programming, although from 2009 I've been able to develop audit applications using the VAST platform with IBM DB2 as the DBMS. I don't yet have had special education (training) for the VAST programming. During this time I learned autodidact from IBM VAST Red-Book or other articles that I obtained from the results of googling, and the help of friends from the IT department. 

Currently I'm doing the application development by using OLE Automation utility (Excel Automation), to facilitate the work performed by the Auditor in the place I work.

Juli Permana A.

Pada Senin, 13 Oktober 2014 3:31:10 UTC+7, Louis LaBrunda menulis:

Hi Juli,

I'm not sure what you are trying to accomplish but for now I will assume you are just playing a bit to learn.  That said I have a few suggestions on how to clean things up a bit (simplify) that may make it easier to see what is going on.  First you can remove all of the following from the white space, "Ordered Collection1", "size of Ordered Collection1" and "self of size of Ordered Collection1".  I will tell you how to replace then shortly.  You can also remove your process method.  Instead connect the clicked event to the execute action of the query.  Tear off the columnNames attribute of the currentRow and drop it in the white space.  Then connect the size attribute of that collection to your columns display field/label.  Also connect the columnNames attribute directly to the items attribute of your list part.

As to your question about two databases, I assume you mean two database tables.  The answer is basically yes for both but two databases is more complicated that two tables and both are tricky and you should proceed with caution.  You would need two queries, pointing to the two tables/databases.  I try not to be using/changing two rows/tables/databases at the same time.

Lou

On Sunday, October 12, 2014 12:16:30 PM UTC-4, Juli Permana wrote:

<a href="https://lh3.googleusercontent.com/-7Jwp5HKgY1A/VDqgq5VBe4I/AAAAAAAAAG8/LN7SMlwZ_-Y/s1600/ColumnNames-5.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh3.googleusercontent.com/-7Jwp5HKgY1A/VDqgq5VBe4I/AAAAAAAAAG8/LN7SMlwZ_-Y/s1600/ColumnNames-5.jpg';return true;" onclick="this.href='https://lh3.googleusercontent.com/-7Jwp5HKgY1A/VDqgq5VBe4I/AAAAAAAAAG8/LN7SMlwZ_-Y/s1600/ColumnNames-5.jpg';return true;">

<a href="https://lh3.googleusercontent.com/-mxGutnQ-1KA/VDqfqcRz0XI/AAAAAAAAAG0/48NWAAbILMc/s1600/ColumnNames-2.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh3.googleusercontent.com/-mxGutnQ-1KA/VDqfqcRz0XI/AAAAAAAAAG0/48NWAAbILMc/s1600/ColumnNames-2.jpg';return true;" onclick="this.href='https://lh3.googleusercontent.com/-mxGutnQ-1KA/VDqfqcRz0XI/AAAAAAAAAG0/48NWAAbILMc/s1600/ColumnNames-2.jpg';return true;">

Hi Louis,

I've understand with your explanation and I've made a visual part (ExtractColumnNames) as shown in the first image above. The column names appear directly on each text-box when I test this visual part, though I have not clicked the PROCESS button (the second image), because I've connected the columns in Packeting Container Details1 to each text-box (Column-1 Name, Column-2 Name, etc).

The PROCESS button has script as: 

Process
| a1 |
(self subpartNamed: 'qPeserta') executeQuery.
a1 := (self subpartNamed: 'currentRow of resultTable of qPeserta') abtAtAttribute: #columnNames.
(self subpartNamed: 'List1') items: a1.

As shown in the first image, I send the items to Ordered Collection 1 and then I get a number of items. A further question is how do I code the VAST script to get the items from Ordered Collection 1 (which contains the column names from the Lists Part) and send it to each text-box (Column-1 Name, Column-2 Name, etc.) ?

By the way ... Could I open two databases (remote db and local db) in a VAST application ? If so, how ? 

Thank you.

Juli Permana A.

Pada Jumat, 10 Oktober 2014 22:45:27 UTC+7, Louis LaBrunda menulis:

Hi Juli,

You are welcome.  I will try to explain things better. 

multiRowQuery resultTable rows first columnNames

multiRowQuery is the name of a variable that contains your multiRowQuery.  It might also be accessed with something like:

(self subpartNamed: 'My MultiRowQuery') if you placed a MultiRowQuery part in the white space and named it "My MultiRowQuery".  Once you have access to the query and after you have executed the query with #executeQuery or #executeQueryAsTransaction sending the query #resultTable will get you the results of executing the query.  The result table will contains the rows retrieved by the query.  Sending the result table #rows will get the rows.  All the rows contain the names of the columns.  Sending rows #first will get you the first row.  Sending the row #columnNames will get you a collection of the column names.  That should be it.  Please ask again if this still isn't clear of if you are doing things differently and aren't sure how to get to the query.

Lou

On Friday, October 10, 2014 8:08:55 AM UTC-4, Juli Permana wrote:

Hi Louis,

Thank you for your response, but I am sorry that I don't understand your answer. Maybe you can explain to me more specific,  because I am a beginner for VisualAge programming.

PT TASPEN (PERSERO)

Kepala SPIDA Surabaya,

JULI PERMANA A.

NIK. 1685

2014-10-09 21:01 GMT+07:00 Louis LaBrunda <[hidden email]>:

Hi Juli,

This works with ODBC but I think it should work for the others:

multiRowQuery resultTable rows first columnNames

Lou

On Thursday, October 9, 2014 4:35:22 AM UTC-4, Juli Permana wrote:

<a href="https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg" style="margin-left:1em;margin-right:1em" target="_blank" onmousedown="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;" onclick="this.href='https://lh6.googleusercontent.com/-6vnjtKUdwmg/VDZH-w_QnjI/AAAAAAAAAF0/BeHV6M01Bxw/s1600/Multi-RowQ.jpg';return true;">

Could I take the Column Names from a multi-row query ? If so, how to do it ? Thanks.

--
You received this message because you are subscribed to a topic in the Google Groups "VA Smalltalk" group.
To unsubscribe from this topic, visit <a href="https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe" target="_blank" onmousedown="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;" onclick="this.href='https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe';return true;">https://groups.google.com/d/topic/va-smalltalk/SOC3QN5uggs/unsubscribe.
To unsubscribe from this group and all its topics, send an email to va-smalltalk...@googlegroups.com.
To post to this group, send email to [hidden email].
Visit this group at <a href="http://groups.google.com/group/va-smalltalk" target="_blank" onmousedown="this.href='http://groups.google.com/group/va-smalltalk';return true;" onclick="this.href='http://groups.google.com/group/va-smalltalk';return true;">http://groups.google.com/group/va-smalltalk.
For more options, visit <a href="https://groups.google.com/d/optout" target="_blank" onmousedown="this.href='https://groups.google.com/d/optout';return true;" onclick="this.href='https://groups.google.com/d/optout';return true;">https://groups.google.com/d/optout.