Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Paul Michael
  Where is Paul Michael?
 Shelton
 Connecticut - United States
 Paul Michael
 To: Jamie Osborn
  Where is Jamie Osborn?
 Melbourne
 Australia
 Jamie Osborn
 Tags
Subject: RE: Syntax problem??? (UPDATE on problem)
Thread ID: 21735 Message ID: 21830 # Views: 12 # Ratings: 0
Version: Visual FoxPro 5 Category: General VFP Topics
Date: Wednesday, April 02, 2003 6:12:26 PM         
   


GOT IT !!!

I want to thank you all for your help.

PM

SOLUTION:

GOT IT TO WORK

SOLUTION:
Function call in the power act should be GetSackNo(sc_ship.a_cus[8]). whatever value is in sc_ship.a_cus(8) will be tcZipcode in the function.


the function should be :
FUNCTION GetSackNo (tcZipCode)

*LOCAL llRetVal && don;t need
local array arrRet[1]
SELECT scfCode FROM POMB3Z ;
WHERE BETWEEN(tcZipCode,Zip,ZipEnd);
INTO ARRAY arrRet
IF _TALLY > 0
sa_cust[1] = arrRet(1) && need array sunscript
*llRetVal = .T. && don;t need
ELSE
sa_cust[1] = ""
*llRetVal = .F. && don;t need
ENDIF
RETURN (.T.) don;t check the return value of the fucntion any code to change it is eroneous

endfunc

COMPLETE THREAD

Syntax problem??? Posted by Paul Michael @ 3/31/2003 9:30:42 PM
RE: Syntax problem??? Posted by Simon Arnold @ 3/31/2003 10:11:38 PM
RE: Syntax problem??? Posted by Paul Michael @ 3/31/2003 10:34:02 PM
RE: Syntax problem??? Posted by Michael Gill @ 4/1/2003 12:46:11 AM
RE: Syntax problem??? Posted by Simon Arnold @ 4/1/2003 1:08:51 PM
RE: Syntax problem??? Posted by Paul Michael @ 4/1/2003 6:41:59 PM
RE: Syntax problem??? Posted by Paul Michael @ 4/1/2003 7:29:43 PM
RE: Syntax problem??? Posted by Michael Gill @ 4/1/2003 7:52:16 PM
RE: Syntax problem??? Posted by Paul Michael @ 4/1/2003 8:01:50 PM
RE: Syntax problem??? Posted by Paul Michael @ 4/1/2003 8:04:35 PM
RE: Syntax problem??? (UPDATE on problem) Posted by Paul Michael @ 4/2/2003 2:34:47 AM
RE: Syntax problem??? (UPDATE on problem) Posted by Jamie Osborn @ 4/2/2003 4:19:34 AM
RE: Syntax problem??? (UPDATE on problem) Posted by Paul Michael @ 4/2/2003 6:12:26 PM