Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data not being written to the table
Message
From
14/09/2006 14:05:12
Jeff Mckay
Utah Department of Health
Salt Lake City, Utah, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Novell 5.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153779
Message ID:
01153781
Views:
16
here is the code, if you need more let me know

SELECT VO
APPEND blank
replace nSequence WITH lnSeq
replace npartid with lcPartid
replace dtissuedate WITH DATE()
IF !EMPTY(lcUserid)
replace cIssuer WITH lcUserid
ENDIF
replace dValidfrom WITH ldValidFrom
replace dValidTo WITH ldValidTo
replace cPackage with lcPack
replace nInstrument WITH i
replace nMaxAmount WITH lnPay * 100
replace nAmount WITH lnAmnt * 100
replace cStatus WITH "I"
replace bprovrd WITH lbOver
replace dLastupdate WITH DATE()
replace bupload WITH .T.
replace cLastuser WITH lcuserid
replace cPriority WITH lcPri
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform