p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   Passing recordset fields using a Variable (http://p2p.wrox.com/showthread.php?t=52525)

johnslaughter January 12th, 2007 12:39 PM

All of the data I am capturing is just text...

The screen looks like this

 SICE04 CUSTOMER SEARCH ENTRY 10:29 CS 01/12/2007

 PRO NUMBER CHK DIGIT SUFFIX BILL DATE ORG DST
 054 - 704279 7 01/11/07 ATL MED

 PPD/COL: P SERVICE TYPE: SG


 SHIPPER: NAME SIEMENS
             ADDR 3130 N BERKELEY LAKE RD NW
             CITY DULUTH ST GA ZIP 30096

 CONSIGNEE: NAME MARVINS INC
             ADDR 2015 HIGHWAY 19 N
             CITY MERIDIAN ST MS ZIP 393074959

 BILL TO: NAME SIEMENS INC % DATA2LOGISTICS
             ADDR PO BOX 61050
             CITY FORT MYERS ST FL ZIP 33906


  EXIT CITY ST ZIP COUNTRY
  ______________________ __ ______ ___



  TENDERED BY NAME
  _____________________________________


  SHIPPER ROUTING ____ TIME CRITICAL: _

 ORIGIN CARRIER LINE
 SCAC DATE BILL NBR AMOUNT
 ____ __ / __ / __ ________________ _______

 ORIGIN CARTAGE
 SCAC BILL NBR AMOUNT
 ____ ________________ _______

 FUNC ENTER-NEXT PF1-HELP PF2-MENU PF5-CUST SEARCH PF6-RESET
 KEYS: PF9-PRNT SESS PF15-ERRORS PF16-CODE MANUAL PF18-COR PF24-FORCE
 MSG ==>

the loop file looks like this:

SICE04_Name SICE04_Row SICE04_Col SICE04_Length
ProNumberProPrefix 4 2 3
ProNumber 4 8 6
ProNumberProChkDigit 4 22 1
ProNumberProSuffix 4 32 2
BillDate 4 40 8
OrgTerminal 4 55 3
DstTerminal 4 63 3
Ppd-Coll 6 11 1
ServiceType 6 36 3
ShipperName 9 19 45
ShipperAddr 10 19 45
ShipperZip 11 57 9
ConsigneeName 13 19 45
ConsigneeAddr 14 19 45
ConsigneeZip 15 57 9
BillToName 17 19 45
BillToAddress 18 19 45
BillToZip 19 57 9
ExitCity 23 3 22
ExitSt 23 27 2
ExitZip 23 31 6
ExitCountry 23 39 3
TenderedByName 28 3 37
ShipperRouting 31 19 4
TimeCritical 31 46 1
OrigCarrierSCAC 35 2 4
OrigCarrierMonth 35 8 2
OrigCarrierDate 35 13 2
OrigCarrierYear 35 18 2
OrigCarrierBillNbr 35 22 16
OrigCarrierAmount 35 40 7
OrigCartageSCAC 39 2 4
OrigCartageBillNbr 39 8 17
OrigCartageAmount 39 27 7


The table I am adding to looks like this

FullProNumber ProNumberProPrefix ProNumber ProNumberProChkDigit ProNumberProSuffix BillDate OrgTerminal DstTerminal Ppd-Coll ServiceType ShipperName ShipperAddr ShipperZip ConsigneeName ConsigneeAddr ConsigneeZip BillToName BillToAddress BillToZip ExitCity ExitSt ExitZip ExitCountry TenderedByName ShipperRouting TimeCritical OrigCarrierSCAC OrigCarrierMonth OrigCarrierDate OrigCarrierYear OrigCarrierBillNbr OrigCarrierAmount OrigCartageSCAC OrigCartageBillNbr OrigCartageAmount
043-397127



mmcdonal January 12th, 2007 12:45 PM

Okay, where did the loop file come in and what is it for?

Given the first screen, you can capture the data and post it to the table you have.

What is the loop table supposed to do?





mmcdonal


All times are GMT -4. The time now is 01:13 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.