Some values may have been changed" error when I try to update from visual basic with ado.
This is rather drastic, but ultimately self defeating.I was on the phone with Sage and their support and they informed me to run the following SQL command - "delete from activity where activity.activityid in (select activity.activityid from activity, history where activity.activityid = history.activityid and activity.recurring='F')" Which I did, but it did not resolve the problem.When they go to complete them, they receive the following error message: An error occurred in the Complete Activity function. : Cannot insert duplicate key row in object 'HISTORY' with unique index 'XPKHISTORY'.While we cannot "Complete" the activity, we have no problems whatsoever deleting the activity. Some values may have been changed since it was last read Help File C: WINDOWSHelp VBENLR98.
: Visual Basic Recommended style: Private rst Order As ADODB. REcordset UPDATE DBF- Recordset ADO Visual Basic Data1.
Text; //additional fields here Post; end; end; end; procedure Tfrm Edit Click(Sender: TObject); begin with frm Coin, tbl Main do begin if Show Modal = mr OK then begin Edit; Field By Name('Title')String:= edt Title. If yes, set the Cursor Location=cl Use Server With best regards, Mike Shkolnik Mike, That works..only if I comment this line out //tbl Main.
Text; //additional fields here Post; end; end; end; Sorry, this is the code for the add procedure procedure Tfrm Add Click(Sender: TObject); begin //************************* with frm Coin, tbl Main do //************************* begin if Show Modal = mr OK then begin Insert; Field By Name('Title')String:= edt Title. Sort := 'Title, Year, Version, Finish'; using sort and or Index Field Names to sort the table, wont work on Server Side Cursors Anyway to sort my table in my grid using your suggestion? procedure Tfrm Main After Open(Data Set: TData Set); begin tbl Main.
We are running v126.96.36.1992 and are still in the process of manually re-syncing remotes.
We are down to about our last 12 on that count thank goodness!!
(или почему не работает программа на другом компьютере). atb Questions связан по ключевому полю Question ID c первичныйм ключем ID другой таблицы Subcathegories.