>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
What happens if you try:
INSERT INTO Vo (nSequence, npartid, dtissuedate, cIssuer, dValidfrom, dValidTo, cPackage, nInstrument,;
nMaxAmount, nAmount, cStatus, bprovrd, dLastupdate, bupload, cLastuser, cPriority);
VALUES;
(lnSeq, lcPartid, DATE(), lcUserid, ldValidFrom, ldValidTo, lcPack, i, lnPay * 100, lnAmnt * 100,;
"I", lbOver, DATE(), .t., lcUserid, lcPri)
FLUSH IN Vo
This is ONE command and update indexes AFTER the insert, also I use FLUSH to save to disk all changes made to Vo table.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.