 |
 |
 |
|
|  |  |
 |
JetSetColumn ..msdn Add comment W32 Constants Translate this page |
 |
 |
|
Modifies a single column value in a modified record to be inserted or to update the current record. |
 |  | | Code examples: |  | |
|
 |  | | Declaration: |  |  |
JET_ERR JET_API JetSetColumn(
__in JET_SESID sesid,
__in JET_TABLEID tableid,
__in JET_COLUMNID columnid,
__in_opt const void* pvData,
__in unsigned long cbData,
__in JET_GRBIT grbit,
__in_opt JET_SETINFO* psetinfo
);
|
 |  |  | | FoxPro declaration: |  |  |
DECLARE INTEGER JetSetColumn IN esent;
INTEGER sesid,;
INTEGER tableid,;
INTEGER columnid,;
INTEGER pvData,;
LONG cbData,;
INTEGER grbit,;
INTEGER psetinfo
|
 |  |  | | Parameters: |  | sesid
The session to use for this call.
tableid
The cursor to use for this call.
columnid
The JET_COLUMNID of the column to be retrieved.
pvData
Input buffer containing data to use for column value.
cbData
Size in bytes of the input buffer.
grbit
A group of bits that contain the options to be used for this call.
psetinfo
Pointer to optional input parameters that can be set for this function using the JET_SETINFO structure. |
 |  | | Return value: |  | | Returns the JET_ERR datatype with a predefined return code. |
 |  | | Usage: |  |
LOCAL oData As PChar, nDataLen
oData = CREATEOBJECT("PChar", m.vValue)
nDataLen = LEN(m.vValue)
THIS.errorno = JetSetColumn(THIS.jetsessionid,;
THIS.jettableid, m.nColumnId,;
oData.GetAddr(), m.nDataLen,;
JET_bitSetOverwriteLV, 0)
|
 |  | | My comment: |  | The function can overwrite an existing value, add a new value to a sequence of values in a multi-valued column, remove a value from a sequence of values in a multi-valued column, or update all or part of a long value, a column of type JET_coltypLongText or JET_coltypeLongBinary.
See also: JetPrepareUpdate. JetSetColumns, JetUpdate |
 |  | | Translate this page: |  | |  |  | | • |  | | Created: | 2008-01-12 21:12:31 | | Modified: | 2008-01-12 21:16:47 | Visited in last 7 days: 10 |
|
 |
 |
 |
 |
Copyright © 2001-2013
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.1.55-log), the Open Source standard SQL database,
AceHTML Freeware
Version 4, freeware HTML Editor of choice. Hosted by Korax Online Inc. |
 |
 |
|
 |
 |
|
|