Using Win32 functions in Visual FoxPro Image Gallery
Extensible Storage Engine (ESE, Jet Blue)
JetAddColumn
JetBeginSession
JetBeginTransaction
JetCloseDatabase
JetCloseTable
JetCommitTransaction
JetCreateDatabase
JetCreateInstance
JetCreateTable
JetDeleteTable
JetDetachDatabase
JetEndSession
JetGetColumnInfo
JetGotoBookmark
JetInit
JetMove
JetOpenTable
JetPrepareUpdate
JetRetrieveColumn
JetRollback
JetSetColumn
JetTerm
JetUpdate
Code examples:
Extensible Storage Engine class library
JetUpdate
..msdn    Add comment     W32 Constants      Translate this page
Performs an update operation including inserting a new row into a table or updating an existing row.
Code examples:
Extensible Storage Engine class library
Declaration:
JET_ERR JET_API JetUpdate(
  __in          JET_SESID sesid,
  __in          JET_TABLEID tableid,
  __out_opt     void* pvBookmark,
  __in          unsigned long cbBookmark,
  __out_opt     unsigned long* pcbActual
);
FoxPro declaration:
DECLARE INTEGER JetUpdate IN esent;
    INTEGER sesid,;
    INTEGER tableid,;
    INTEGER @pvBookmark,;
    LONG cbBookmark,;
    LONG @pcbActual
Parameters:
sesid
The session to use for this call.

tableid
The cursor to use for this call.

pvBookmark
Pointer to a returned bookmark for an inserted row.

cbBookmark
Size of the buffer pointed to by pvBookmark.

pcbActual
The returned size of the bookmark for the inserted row returned in pvBookmark.
Return value:
Returns the JET_ERR datatype with a predefined return code.
Usage:
LOCAL nBookmark, nBookmarkSize
nBookmarkSize=4

THIS.errorno = JetUpdate(THIS.jetsessionid, THIS.jettableid,;
    @nBookmark, m.nBookmarkSize, @nBookmarkSize)
My comment:
The function is the final step in performing an insert or an update. The update is begun by calling JetPrepareUpdate and then by calling JetSetColumn or JetSetColumns one or more times to set the record state.

Finally, JetUpdate is called to complete the update operation. Indexes are updated only by JetUpdate or JetUpdate2, and not during JetSetColumn or JetSetColumns.
Translate this page:
  Spanish    Portuguese    German    French    Italian  
FreeTranslation.com offers instant, free translations of text or web pages.
Created: 2008-01-12 21:17:10
Modified: 2008-01-12 21:19:44
Visited in last 7 days: 9
User Contributed Notes:
There are no notes on this subject.


Copyright 2001-2017 News2News, Inc. Before reproducing or distributing any data from this site please ask for an approval from its owner. Unless otherwise specified, this page is for your personal and non-commercial use. The information on this page is presented AS IS, meaning that you may use it at your own risk. Microsoft Visual FoxPro and Windows are trade marks of Microsoft Corp. All other trademarks are the property of their respective owners. 

Privacy policy
Credits: PHP (4.4.9), an HTML-embedded scripting language, MySQL (5.6.37), the Open Source standard SQL database, AceHTML Freeware Version 4, freeware HTML Editor of choice.   Hosted by Korax Online Inc.
Last Topics Visited (54.81.79.128)
11 sec.Function: 'SHFormatDrive'
22 sec.
Function group: 'Simple MAPI'
34 sec.Function: 'QueryPerformanceCounter'
45 sec.Function: 'CreateSemaphore'
55 sec.Function: 'GlobalReAlloc'
1.1 min.Function: 'GetQueueStatus'
1.28 min.Function: 'LsaOpenPolicy'
1.5 min.Function: 'CeGetVersionEx'
1.7 min.Function: 'SCardGetProviderId'
1.88 min.Function: 'GetLengthSid'
Google
Advertise here!