update error

Results 1 to 2 of 2

Thread: update error

  1. #1
    Join Date
    Dec 1969

    Default update error

    I want to convert a table from oracle to foxpro for a particular reason. But it gives error at &#039;fprs.update&#039;<BR><BR>"Query cannot update because the FROM clause is not a single simple table name" <BR><BR>can any body help me out please<BR><BR>My code is as :<BR><BR>wdate = Format(Date, "dd-mm-yyyy")<BR>abc = "select * from cashbk0203 where TO_CHAR(DVRDT,&#039;DD-MM-YYYY&#039;)=&#039;" & wdate & "&#039; order by dvrdt,nvrno"<BR>cashbkrs.Open abc, orclcon<BR><BR>fprs.Open "DELETE from h:hohomctemp", fpcon, adOpenDynamic, adLockOptimistic<BR>fprs.Open "h:hohomctemp", fpcon, adOpenDynamic, adLockOptimistic, adCmdTable<BR>Do While Not cashbkrs.EOF<BR>fprs.AddNew<BR>fprs!tc = cashbkrs!npayrec<BR>fprs!tp = cashbkrs!CTYPE<BR>fprs!ADVNO = cashbkrs!nadvno<BR>fprs!Status = "P"<BR>fprs.Update <BR>cashbkrs.MoveNext<BR>Loop<BR>fprs.Close<BR>cas hbkrs.Close<BR><BR><BR>thanq<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: update error

    Why a DELETE statement? Shouldn&#039;t that be?<BR><BR>fprs.Open "select * from h:hohomctemp", fpcon, adOpenDynamic, adLockOptimistic

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts