Help with VB Form data

Yahoo Archive
1
That worked so perfect I can't even begin to thanks you.

Thank you very very much.

Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Tuesday, November 04, 2003 5:06 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Help with VB Form data


Instead of trying to populate more fields on the VBForm (Sales Order #),
just create a .p file to gather all the information you need, format it in
the correct string and launch your app:

DEF VAR data AS CHARACTER.
FIND FIRST OrderHed where (rowid(OrderHed) = GetCurrentRowID()) no-lock.
...
ASSIGN data = data + "~" + STRING(OrderHed.OrderNum).
FIND FIRST Customer WHERE Customer.CustNum = OrderHed.CustNum NO-LOCK.
ASSIGN data = data + "~" + Customer.Name + "~" + STRING(OrderHed.CustNum).


My syntax may be a bit off cause I typed this from memory, but it works
really well.


-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Tuesday, November 04, 2003 1:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Help with VB Form data


I am trying to launch our document imaging application from a VB Form. I
don't know if my brain is so Microsoft oriented now that I cant figure this
out or what. I need to supply it with several parameters.
As an example, I am trying to launch an app from the Sales Order VB Form. I
need to supply the program with a command line that will look like this.

v:\ud\myapp.exe jleonard~SO~23890~Boeing~113

jleonard=vantage user name
SO=Type of Document being Scanned
23890=Sales Order Number
Boeing=Customer Name
113=CustNum

I was able to get the user name and Type of Document easy. What I cant
figure out is how to get the last three variables.

I tried this in a .p file to just get the Sales Order Number but I keep
getting an error.

FIND FIRST OrderHed where (rowid(OrderHed) = GetCurrentRowID()) no-lock.
setdecimalvalue("OrderHed.NUMBER-FIELD_1.SCRVALUE":U,Orderhed.ordernum)
no-error.
RETURN.

I was thinking that if I could at least get the Sales Order number into a
field on the VB Form I could go from there. I would prefer just to load the
sales order number into a variable that I can pass to the command line.

Any help would be greatly appreciated.

Thanks
FRUSTRATED





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I am trying to launch our document imaging application from a VB Form. I don't know if my brain is so Microsoft oriented now that I cant figure this out or what. I need to supply it with several parameters.
As an example, I am trying to launch an app from the Sales Order VB Form. I need to supply the program with a command line that will look like this.

v:\ud\myapp.exe jleonard~SO~23890~Boeing~113

jleonard=vantage user name
SO=Type of Document being Scanned
23890=Sales Order Number
Boeing=Customer Name
113=CustNum

I was able to get the user name and Type of Document easy. What I cant figure out is how to get the last three variables.

I tried this in a .p file to just get the Sales Order Number but I keep getting an error.

FIND FIRST OrderHed where (rowid(OrderHed) = GetCurrentRowID()) no-lock.
setdecimalvalue("OrderHed.NUMBER-FIELD_1.SCRVALUE":U,Orderhed.ordernum) no-error.
RETURN.

I was thinking that if I could at least get the Sales Order number into a field on the VB Form I could go from there. I would prefer just to load the sales order number into a variable that I can pass to the command line.

Any help would be greatly appreciated.

Thanks
FRUSTRATED
3
Instead of trying to populate more fields on the VBForm (Sales Order #),
just create a .p file to gather all the information you need, format it in
the correct string and launch your app:

DEF VAR data AS CHARACTER.
FIND FIRST OrderHed where (rowid(OrderHed) = GetCurrentRowID()) no-lock.
...
ASSIGN data = data + "~" + STRING(OrderHed.OrderNum).
FIND FIRST Customer WHERE Customer.CustNum = OrderHed.CustNum NO-LOCK.
ASSIGN data = data + "~" + Customer.Name + "~" + STRING(OrderHed.CustNum).


My syntax may be a bit off cause I typed this from memory, but it works
really well.


-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Tuesday, November 04, 2003 1:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Help with VB Form data


I am trying to launch our document imaging application from a VB Form. I
don't know if my brain is so Microsoft oriented now that I cant figure this
out or what. I need to supply it with several parameters.
As an example, I am trying to launch an app from the Sales Order VB Form. I
need to supply the program with a command line that will look like this.

v:\ud\myapp.exe jleonard~SO~23890~Boeing~113

jleonard=vantage user name
SO=Type of Document being Scanned
23890=Sales Order Number
Boeing=Customer Name
113=CustNum

I was able to get the user name and Type of Document easy. What I cant
figure out is how to get the last three variables.

I tried this in a .p file to just get the Sales Order Number but I keep
getting an error.

FIND FIRST OrderHed where (rowid(OrderHed) = GetCurrentRowID()) no-lock.
setdecimalvalue("OrderHed.NUMBER-FIELD_1.SCRVALUE":U,Orderhed.ordernum)
no-error.
RETURN.

I was thinking that if I could at least get the Sales Order number into a
field on the VB Form I could go from there. I would prefer just to load the
sales order number into a variable that I can pass to the command line.

Any help would be greatly appreciated.

Thanks
FRUSTRATED