Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DDEQUERY

Status
Not open for further replies.
Stella001

Stella001

Programmer
Mar 24, 2004
71
US
Can you combine the DDEQUERY with the GETANDSET function?
Here is my rule now:
=DDEQUERY( "TPPC", COMPANY_NAME, "UNBControlReference" )

What I need to do is not only pull the control number I need to update it to the next number after it is pulled. I've tried many ways but none will analyze.
 
Sort by date Sort by votes
GETANDSET is a file function.
You might want to contact TPPC support since Mercator/Ascential/IBM no longer owns TP PC. This should be something they have had to handle before.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!
 
Upvote 0 Downvote
I have already done that. They are aware that advancing the control number is an issue with EDIFACT data so I was attempting to do it myself until their patch comes out. I can do it succesfully with using a text file, but using a text file causes other issues when sending the 997 for inbound documents.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top