Kinook Software Forum

Go Back   Kinook Software Forum > Visual Build Professional > [VBP] Third Party Tools

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 01-09-2011, 08:38 AM
maorlast2 maorlast2 is online now
Registered User
 
Join Date: 01-09-2011
Posts: 6
Run Sql Action, how to get a value from SQL?

I am using Visual Build 7.7

I am trying to get a specific value from the database table
I am using “Run Sql” Action and using SELECT query

how can i set the value that i got from the db into a temp marco?
I also tried to take it from LASTSTEP_OUTPUT but i see this result:

“MyValue

(1 row affected)”

I would like to remove the “(1 row affected)” and get the exact value "MyValue"

How can I do that?
Reply With Quote
  #2  
Old 01-10-2011, 10:39 AM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
See attached sample.
Attached Files
File Type: bld parsesql.bld (866 Bytes, 797 views)
Reply With Quote
  #3  
Old 01-10-2011, 04:10 PM
maorlast2 maorlast2 is online now
Registered User
 
Join Date: 01-09-2011
Posts: 6
Querying via ADO

Thank you for your assistance.

I have another question that is also related to the same subject

For querying the database, i am using the ADO component and it does the work very well.

My question is can i do a SELECT query that will return several rows and iterate every value in every single row and save their values into Macro's?

I was able to do that when the SELECT returned me 1 row, can i do it with more than one row?

Thanks
Reply With Quote
  #4  
Old 01-10-2011, 05:42 PM
kinook kinook is online now
Administrator
 
Join Date: 03-06-2001
Location: Colorado
Posts: 6,003
Yes, use the Loop action (see the Server.bld sample).
http://www.kinook.com/VisBuildPro/Ma...rversample.htm
http://www.kinook.com/VisBuildPro/Manual/loopaction.htm
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 02:37 AM.


Copyright © 1999-2023 Kinook Software, Inc.