Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert records in a view
Message
 
To
29/10/1999 04:12:25
Marco Beuk
Innovero Software Solutions
The Hague, Netherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00283021
Message ID:
00283672
Views:
21
Marco,

In order to understand what really happens, you might want to update row by row, like in the following construct:
llToast = .F.
lnNext = GETNEXTMODIFIED(0)

BEGIN TRANSACTION
DO WHILE lnNext # 0
  GO (lnNext)
  IF ! TABLEUPDATE()
    llToast = .T.
    EXIT
  ENDIF
  lnNext = GETNEXTMODIFIED(lnNext)
ENDDO

IF llToast
  ROLLBACK
  TABLEREVERT(.T.)
  ErrorMsg(this.cMsgUpdateFailed )
  RETURN .F.
ELSE
  END TRANSACTION
ENDIF
José
Previous
Reply
Map
View

Click here to load this message in the networking platform