VB question

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

VB question

Logged in as: Guest

arrSession:exec spGetSession 2,7,36174

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> VB question
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

VB question - 7/13/2006 3:00:41 AM

dante

Posts: 1
Score: 0
Joined: 7/13/2006
Status: offline

Okay, so I am new to this forum. I am working with Rational ClearQuest for work and it utilizes Basic scripts. I have some programming experience but no VB. I have been googling for most help but this one I am stuck on. Hopefully someone can help.

Scenario:

Two Tables within one SQL database

Project with a column called Defect_Lead

Defect wtih a column called Lead. **Note there is also a referenced field(column) called "Project" No scripted was needed to get this one to work, but I think because it was the name name of the other table.

In the Defect script under the field Lead I need to write a VB script that will take the data from the Project tab column Defect_Lead and display and add it to the column in the Defect table.

Some background, here is what I have written so far.
This script is written in the Defect table.

Sub lead_DefaultValue(fieldname)
fieldname As String
record type name is Defect
field name is Lead

If GetFieldValue("Project").GetValue() != " " then

REM Need to pull the value that was set in Defect_Lead field(column) in the Project Table
REM Need to than Take that value from Defect_Lead and populate the Lead field in the Defect table

End if

Any help would be greatly appreciated!

Post #: 1

RE: VB question - 7/13/2006 11:59:26 PM

mbouchard

Posts: 1804
Score: 12
Joined: 5/15/2003
From: USA
Status: online

From the looks of the code you posted you are talking about Visual Basic (VB) and not VisualBasic Scripting (VBS) they are completely different.

While there are some here that can probably help, you might get more help if you go to google groups and search on Visual Basic MSDN or the like.

_____________________________

Mike

For useful Scripting links see the Read Me First stickey!

Always remember Search is your friend.

(in reply to dante)

Post #: 2

RE: VB question - 9/17/2006 12:50:34 AM

Nari

Posts: 1
Score: 0
Joined: 9/17/2006
Status: offline

HI to all

who can help me about Vbscrit in Corel I want to make a scrip that can Generate the numbers but the Script in the Corel Just repet the same thins *number*

Sub alban()
   '
   ' Recorded 9/17/2006
   '
   ' Description:
   '
   '
   Dim dup1 As ShapeRange
   Set dup1 = ActivePage.Shapes.All.Duplicate()
   dup1.Move 1.181102, 0#
   ' Recording of this command is not supported
   Dim dup2 As ShapeRange
   Set dup2 = dup1.Duplicate()
   dup2.Move 1.181102, 0#
   ' Recording of this command is not supported
End Sub

(in reply to mbouchard)

Post #: 3

RE: VB question - 9/19/2006 6:11:57 AM

mbouchard

Posts: 1804
Score: 12
Joined: 5/15/2003
From: USA
Status: online

As I said to the OP, this isn't VBscript, but may be VB.

_____________________________

Mike

For useful Scripting links see the Read Me First stickey!

Always remember Search is your friend.

(in reply to Nari)

Post #: 4

RE: VB question - 9/19/2006 7:26:14 AM

ebgreen

Posts: 4595
Score: 29
Joined: 7/12/2005
Status: offline

I suspect that the second code may be technically VBScript but since it is being hosted in an application and being generated by a macro recorder (from all appearances) then it would be hard for anyone that has not coded macros in that specific app to help with.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to mbouchard)

Post #: 5

RE: VB question - 9/19/2006 11:36:00 PM

mbouchard

Posts: 1804
Score: 12
Joined: 5/15/2003
From: USA
Status: online

True.

_____________________________

Mike

For useful Scripting links see the Read Me First stickey!

Always remember Search is your friend.

(in reply to ebgreen)

Post #: 6

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.

All Forums >> [General Forum] >> Other Programming/Scripting Languages >> VB question

Page: [1]

Jump to:

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts