Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL statement /Pervasive
Message
 
 
À
21/07/2010 18:32:06
John Vlahos
V I Software Solutions Design
Mississauga, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Divers
Thread ID:
01470450
Message ID:
01473411
Vues:
27
Sorry, I probably should not ask for this as it's not that much helpful and too much info.

Can you run the select statement in pervasive or create a remote view using this select statement as I shown?

>Here are the other 2 files, RV_AR_CUS and RV_ICPRIC (below):
>
>John
>
>=========================
> Structure for view: RV_ARCUS (Remote)
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
> Source Name: RV_ARCUS
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 1 IDCUST C(12) Yes ARCUS.IDCUST
> 2 AUDTDATE N(11,0) Yes ARCUS.AUDTDATE
>
> 3 AUDTTIME N(11,0) Yes ARCUS.AUDTTIME
>
> 4 AUDTUSER C(8) Yes ARCUS.AUDTUSER
>
> 5 AUDTORG C(6) Yes ARCUS.AUDTORG
> 6 TEXTSNAM C(10) Yes ARCUS.TEXTSNAM
>
> 7 IDGRP C(6) Yes ARCUS.IDGRP
>
> 8 IDNATACCT C(12) Yes ARCUS.IDNATACCT
>
> 9 SWACTV I Yes ARCUS.SWACTV
> 10 DATEINAC N(11,0) Yes ARCUS.DATEINAC
>
> 11 DATELASTMN N(11,0) Yes ARCUS.DATELASTMN
>
> 12 SWHOLD I Yes ARCUS.SWHOLD
>
> 13 DATESTART N(11,0) Yes ARCUS.DATESTART
>
> 14 IDPPNT C(12) Yes ARCUS.IDPPNT
> 15 CODEDAB C(9) Yes ARCUS.CODEDAB
>
> 16 CODEDABRTG C(5) Yes ARCUS.CODEDABRTG
>
> 17 DATEDAB N(11,0) Yes ARCUS.DATEDAB
>
> 18 NAMECUST C(60) Yes ARCUS.NAMECUST
> 19 TEXTSTRE1 C(60) Yes ARCUS.TEXTSTRE1
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ARCUS (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
>
> Source Name: RV_ARCUS
>
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 20 TEXTSTRE2 C(60) Yes ARCUS.TEXTSTRE2
> 21 TEXTSTRE3 C(60) Yes ARCUS.TEXTSTRE3
>
> 22 TEXTSTRE4 C(60) Yes ARCUS.TEXTSTRE4
>
> 23 NAMECITY C(30) Yes ARCUS.NAMECITY
>
> 24 CODESTTE C(30) Yes ARCUS.CODESTTE
> 25 CODEPSTL C(20) Yes ARCUS.CODEPSTL
>
> 26 CODECTRY C(30) Yes ARCUS.CODECTRY
>
> 27 NAMECTAC C(60) Yes ARCUS.NAMECTAC
>
> 28 TEXTPHON1 C(30) Yes ARCUS.TEXTPHON1
> 29 TEXTPHON2 C(30) Yes ARCUS.TEXTPHON2
>
> 30 CODETERR C(6) Yes ARCUS.CODETERR
>
> 31 IDACCTSET C(6) Yes ARCUS.IDACCTSET
>
> 32 IDAUTOCASH C(6) Yes ARCUS.IDAUTOCASH
>
> 33 IDBILLCYCL C(6) Yes ARCUS.IDBILLCYCL
> 34 IDSVCCHRG C(6) Yes ARCUS.IDSVCCHRG
>
> 35 IDDLNQ C(6) Yes ARCUS.IDDLNQ
>
> 36 CODECURN C(3) Yes ARCUS.CODECURN
>
> 37 SWPRTSTMT I Yes ARCUS.SWPRTSTMT
> 38 SWPRTDLNQ I Yes ARCUS.SWPRTDLNQ
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ARCUS (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
>
> Source Name: RV_ARCUS
>
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 39 SWBALFWD I Yes ARCUS.SWBALFWD
> 40 CODETERM C(6) Yes ARCUS.CODETERM
>
> 41 IDRATETYPE C(2) Yes ARCUS.IDRATETYPE
>
> 42 CODETAXGRP C(12) Yes ARCUS.CODETAXGRP
>
> 43 IDTAXREGI1 C(20) Yes ARCUS.IDTAXREGI1
> 44 IDTAXREGI2 C(20) Yes ARCUS.IDTAXREGI2
>
> 45 IDTAXREGI3 C(20) Yes ARCUS.IDTAXREGI3
>
> 46 IDTAXREGI4 C(20) Yes ARCUS.IDTAXREGI4
>
> 47 IDTAXREGI5 C(20) Yes ARCUS.IDTAXREGI5
> 48 TAXSTTS1 I Yes ARCUS.TAXSTTS1
>
> 49 TAXSTTS2 I Yes ARCUS.TAXSTTS2
>
> 50 TAXSTTS3 I Yes ARCUS.TAXSTTS3
>
> 51 TAXSTTS4 I Yes ARCUS.TAXSTTS4
>
> 52 TAXSTTS5 I Yes ARCUS.TAXSTTS5
> 53 AMTCRLIMT Y Yes ARCUS.AMTCRLIMT
>
> 54 AMTBALDUET Y Yes ARCUS.AMTBALDUET
>
> 55 AMTBALDUEH Y Yes ARCUS.AMTBALDUEH
>
> 56 DATELASTST N(11,0) Yes ARCUS.DATELASTST
> 57 AMTLASTSTT Y Yes ARCUS.AMTLASTSTT
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ARCUS (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
>
> Source Name: RV_ARCUS
>
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 58 AMTLASTSTH Y Yes ARCUS.AMTLASTSTH
> 59 DTBEGBALFW N(11,0) Yes ARCUS.DTBEGBALFW
>
> 60 AMTBALFWDT Y Yes ARCUS.AMTBALFWDT
>
> 61 AMTBALFWDH Y Yes ARCUS.AMTBALFWDH
>
> 62 DTLASTRVAL N(11,0) Yes ARCUS.DTLASTRVAL
> 63 AMTBALLARV Y Yes ARCUS.AMTBALLARV
>
> 64 CNTOPENINV N(9,0) Yes ARCUS.CNTOPENINV
>
> 65 CNTINVPAID N(9,0) Yes ARCUS.CNTINVPAID
>
> 66 DAYSTOPAY N(9,0) Yes ARCUS.DAYSTOPAY
> 67 DATEINVCHI N(11,0) Yes ARCUS.DATEINVCHI
>
> 68 DATEBALHI N(11,0) Yes ARCUS.DATEBALHI
>
> 69 DATEINVHIL N(11,0) Yes ARCUS.DATEINVHIL
>
> 70 DATEBALHIL N(11,0) Yes ARCUS.DATEBALHIL
>
> 71 DATELASTAC N(11,0) Yes ARCUS.DATELASTAC
> 72 DATELASTIV N(11,0) Yes ARCUS.DATELASTIV
>
> 73 DATELASTCR N(11,0) Yes ARCUS.DATELASTCR
>
> 74 DATELASTDR N(11,0) Yes ARCUS.DATELASTDR
>
> 75 DATELASTPA N(11,0) Yes ARCUS.DATELASTPA
> 76 DATELASTDI N(11,0) Yes ARCUS.DATELASTDI
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ARCUS (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
>
> Source Name: RV_ARCUS
>
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 77 DATELASTAD N(11,0) Yes ARCUS.DATELASTAD
> 78 DATELASTWR N(11,0) Yes ARCUS.DATELASTWR
>
> 79 DATELASTRI N(11,0) Yes ARCUS.DATELASTRI
>
> 80 DATELASTIN N(11,0) Yes ARCUS.DATELASTIN
>
> 81 DATELASTDQ N(11,0) Yes ARCUS.DATELASTDQ
> 82 IDINVCHI C(22) Yes ARCUS.IDINVCHI
>
> 83 IDINVCHILY C(22) Yes ARCUS.IDINVCHILY
>
> 84 AMTINVHIT Y Yes ARCUS.AMTINVHIT
>
> 85 AMTBALHIT Y Yes ARCUS.AMTBALHIT
> 86 AMTINVHILT Y Yes ARCUS.AMTINVHILT
>
> 87 AMTBALHILT Y Yes ARCUS.AMTBALHILT
>
> 88 AMTLASTIVT Y Yes ARCUS.AMTLASTIVT
>
> 89 AMTLASTCRT Y Yes ARCUS.AMTLASTCRT
>
> 90 AMTLASTDRT Y Yes ARCUS.AMTLASTDRT
> 91 AMTLASTPYT Y Yes ARCUS.AMTLASTPYT
>
> 92 AMTLASTDIT Y Yes ARCUS.AMTLASTDIT
>
> 93 AMTLASTADT Y Yes ARCUS.AMTLASTADT
>
> 94 AMTLASTWRT Y Yes ARCUS.AMTLASTWRT
> 95 AMTLASTRIT Y Yes ARCUS.AMTLASTRIT
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ARCUS (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
>
> Source Name: RV_ARCUS
>
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 96 AMTLASTINT Y Yes ARCUS.AMTLASTINT
> 97 AMTINVHIH Y Yes ARCUS.AMTINVHIH
>
> 98 AMTBALHIH Y Yes ARCUS.AMTBALHIH
>
> 99 AMTINVHILH Y Yes ARCUS.AMTINVHILH
>
> 100 AMTBALHILH Y Yes ARCUS.AMTBALHILH
> 101 AMTLASTIVH Y Yes ARCUS.AMTLASTIVH
>
> 102 AMTLASTCRH Y Yes ARCUS.AMTLASTCRH
>
> 103 AMTLASTDRH Y Yes ARCUS.AMTLASTDRH
>
> 104 AMTLASTPYH Y Yes ARCUS.AMTLASTPYH
> 105 AMTLASTDIH Y Yes ARCUS.AMTLASTDIH
>
> 106 AMTLASTADH Y Yes ARCUS.AMTLASTADH
>
> 107 AMTLASTWRH Y Yes ARCUS.AMTLASTWRH
>
> 108 AMTLASTRIH Y Yes ARCUS.AMTLASTRIH
>
> 109 AMTLASTINH Y Yes ARCUS.AMTLASTINH
> 110 CODESLSP1 C(8) Yes ARCUS.CODESLSP1
>
> 111 CODESLSP2 C(8) Yes ARCUS.CODESLSP2
>
> 112 CODESLSP3 C(8) Yes ARCUS.CODESLSP3
>
> 113 CODESLSP4 C(8) Yes ARCUS.CODESLSP4
> 114 CODESLSP5 C(8) Yes ARCUS.CODESLSP5
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ARCUS (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
>
> Source Name: RV_ARCUS
>
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 115 PCTSASPLT1 Y Yes ARCUS.PCTSASPLT1
> 116 PCTSASPLT2 Y Yes ARCUS.PCTSASPLT2
>
> 117 PCTSASPLT3 Y Yes ARCUS.PCTSASPLT3
>
> 118 PCTSASPLT4 Y Yes ARCUS.PCTSASPLT4
>
> 119 PCTSASPLT5 Y Yes ARCUS.PCTSASPLT5
> 120 PRICLIST C(6) Yes ARCUS.PRICLIST
>
> 121 CUSTTYPE I Yes ARCUS.CUSTTYPE
>
> 122 AMTPDUE Y Yes ARCUS.AMTPDUE
>
> 123 EMAIL1 C(50) Yes ARCUS.EMAIL1
> 124 EMAIL2 C(50) Yes ARCUS.EMAIL2
>
> 125 WEBSITE C(100) Yes ARCUS.WEBSITE
>
> 126 BILLMETHOD I Yes ARCUS.BILLMETHOD
>
> 127 CCNUMBER C(30) Yes ARCUS.CCNUMBER
>
> 128 CCEXP N(11,0) Yes ARCUS.CCEXP
> 129 CCNAME C(50) Yes ARCUS.CCNAME
>
> 130 CODPAYMTYP C(6) Yes ARCUS.CODPAYMTYP
>
> 131 FOB C(60) Yes ARCUS.FOB
>
> 132 SHPVIACODE C(6) Yes ARCUS.SHPVIACODE
> 133 SHPVIADESC C(60) Yes ARCUS.SHPVIADESC
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ARCUS (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (1)
> Parameters:
>
> Source Name: RV_ARCUS
>
> Tables: ARCUS
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ARCUS
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 134 DELMETHOD I Yes ARCUS.DELMETHOD
> 135 PRIMSHIPTO C(6) Yes ARCUS.PRIMSHIPTO
>
> 136 CTACPHONE C(30) Yes ARCUS.CTACPHONE
>
> 137 CTACFAX C(30) Yes ARCUS.CTACFAX
>
> 138 SWPARTSHIP I Yes ARCUS.SWPARTSHIP
> 139 SWWEBSHOP I Yes ARCUS.SWWEBSHOP
>
> 140 RTGPERCENT Y Yes ARCUS.RTGPERCENT
>
> 141 RTGDAYS I Yes ARCUS.RTGDAYS
>
> 142 RTGTERMS C(6) Yes ARCUS.RTGTERMS
> 143 RTGAMTTC Y Yes ARCUS.RTGAMTTC
>
> 144 RTGAMTHC Y Yes ARCUS.RTGAMTHC
>
> 145 VALUES I Yes ARCUS.VALUES
>
> 146 CNTPPDINVC N(9,0) Yes ARCUS.CNTPPDINVC
>
> 147 AMTPPDINVT Y Yes ARCUS.AMTPPDINVT
> 148 AMTPPDINVH Y Yes ARCUS.AMTPPDINVH
>
> LS 3.1 - John Koziol (5/9/2001)
>==============================================================================================
>================================================================================================
> Structure for view: RV_ICPRIC (Remote)
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
> Connection Name/#: C_DeFediSDATA (3)
> Parameters:
> Source Name: RV_ICPRIC
> Tables: ICPRIC
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ICPRIC
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 1 CURRENCY C(3) Yes ICPRIC.CURRENCY
> 2 ITEMNO C(24) Yes ICPRIC.ITEMNO
>
> 3 PRICELIST C(6) Yes ICPRIC.PRICELIST
>
> 4 AUDTDATE N(11,0) Yes ICPRIC.AUDTDATE
>
> 5 AUDTTIME N(11,0) Yes ICPRIC.AUDTTIME
> 6 AUDTUSER C(8) Yes ICPRIC.AUDTUSER
>
> 7 AUDTORG C(6) Yes ICPRIC.AUDTORG
>
> 8 DESC C(60) Yes ICPRIC.DESC
>
> 9 PRICEDECS I Yes ICPRIC.PRICEDECS
> 10 BASEPRICE Y Yes ICPRIC.BASEPRICE
>
> 11 BASEUNIT C(10) Yes ICPRIC.BASEUNIT
>
> 12 BASECONV Y Yes ICPRIC.BASECONV
>
> 13 SALEPRICE Y Yes ICPRIC.SALEPRICE
>
> 14 SALEUNIT C(10) Yes ICPRIC.SALEUNIT
> 15 SALECONV Y Yes ICPRIC.SALECONV
>
> 16 SALESTART N(11,0) Yes ICPRIC.SALESTART
>
> 17 SALEEND N(11,0) Yes ICPRIC.SALEEND
>
> 18 MARKUPCOST Y Yes ICPRIC.MARKUPCOST
> 19 MARKUPUNIT C(10) Yes ICPRIC.MARKUPUNIT
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ICPRIC (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (3)
> Parameters:
>
> Source Name: RV_ICPRIC
>
> Tables: ICPRIC
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ICPRIC
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 20 MARKUPCONV Y Yes ICPRIC.MARKUPCONV
> 21 PRICETYPE I Yes ICPRIC.PRICETYPE
>
> 22 PRICEFMT I Yes ICPRIC.PRICEFMT
>
> 23 PRCNTLVL1 Y Yes ICPRIC.PRCNTLVL1
>
> 24 PRCNTLVL2 Y Yes ICPRIC.PRCNTLVL2
> 25 PRCNTLVL3 Y Yes ICPRIC.PRCNTLVL3
>
> 26 PRCNTLVL4 Y Yes ICPRIC.PRCNTLVL4
>
> 27 PRCNTLVL5 Y Yes ICPRIC.PRCNTLVL5
>
> 28 PRICEBASE I Yes ICPRIC.PRICEBASE
> 29 PRICEQTY1 Y Yes ICPRIC.PRICEQTY1
>
> 30 PRICEQTY2 Y Yes ICPRIC.PRICEQTY2
>
> 31 PRICEQTY3 Y Yes ICPRIC.PRICEQTY3
>
> 32 PRICEQTY4 Y Yes ICPRIC.PRICEQTY4
>
> 33 PRICEQTY5 Y Yes ICPRIC.PRICEQTY5
> 34 MARKUP Y Yes ICPRIC.MARKUP
>
> 35 LASTPRICDT N(11,0) Yes ICPRIC.LASTPRICDT
>
> 36 PREVPRICE Y Yes ICPRIC.PREVPRICE
>
> 37 LASTMKPDT N(11,0) Yes ICPRIC.LASTMKPDT
> 38 PREVMKPCST Y Yes ICPRIC.PREVMKPCST
>
>
> LS 3.1 - John Koziol (5/9/2001)
>
> Structure for view: RV_ICPRIC (Remote)
>
> View database: C:\DOCUMENTS AND SETTINGS\JOHNV\MY DOCUMENTS\VISUAL FOXPRO
>
> Connection Name/#: C_DeFediSDATA (3)
> Parameters:
>
> Source Name: RV_ICPRIC
>
> Tables: ICPRIC
> ======================================================================================================================
>
> Send Updates: No Compare Memo: Yes Fetch Size: 100 Use Memo Size: 255
>
> Update Type: Update Fetch As Needed: No Max Records: All Where Type: 3
> Batch Update Cnt: 1 Fetch Memo: Yes Prepared: No
>
> ======================================================================================================================
> SQL Statement: SELECT * FROM ICPRIC
>
>
>
> ======================================================================================================================
>
> F# FieldName Struct Upd UpdateName
>
>
> 39 LASTEXCHDT N(11,0) Yes ICPRIC.LASTEXCHDT
> 40 PREVEXCHRT Y Yes ICPRIC.PREVEXCHRT
>
> 41 ROUNDMETHD I Yes ICPRIC.ROUNDMETHD
>
> 42 ROUNDAMT Y Yes ICPRIC.ROUNDAMT
>
> 43 AMOUNTLVL1 Y Yes ICPRIC.AMOUNTLVL1
> 44 AMOUNTLVL2 Y Yes ICPRIC.AMOUNTLVL2
>
> 45 AMOUNTLVL3 Y Yes ICPRIC.AMOUNTLVL3
>
> 46 AMOUNTLVL4 Y Yes ICPRIC.AMOUNTLVL4
>
> 47 AMOUNTLVL5 Y Yes ICPRIC.AMOUNTLVL5
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> LS 3.1 - John Koziol (5/9/2001)
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform