Scribd
Upload
43 views5 pages

Jdegt - Fetchdata/Jdegt - Fetchdataex: Syntax

This function retrieves one record from the Media Object table (F00165) using the table handle and returns the data in an allocated MODATA structure. It takes a table handle and MODATA pointer as input and returns a status. The function can also be used to repeatedly fetch records by calling it in a loop. The MODATA structure defines the format of the retrieved data.

Uploaded by

RaveRave
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
43 views5 pages

Jdegt - Fetchdata/Jdegt - Fetchdataex: Syntax

This function retrieves one record from the Media Object table (F00165) using the table handle and returns the data in an allocated MODATA structure. It takes a table handle and MODATA pointer as input and returns a status. The function can also be used to repeatedly fetch records by calling it in a loop. The MODATA structure defines the format of the retrieved data.

Uploaded by

RaveRave
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 5

jdeGT_FetchData/jdeGT_FetchDataEx

Last Modified: B9 | October 2, 2020

This function will retrieve one record from the Media Object table (F00165).

Syntax

JDERTN(JDEDB_RESULT) JDEWINAPI jdeGT_FetchData(


HREQUEST hRequestGT,
LPMODATA *lpMOData
BOOL bConvRTFText);

JDERTN(JDEDB_RESULT) JDEWINAPI jdeGT_FetchDataEx(


HREQUEST hRequestGT,
JCHAR *szObjectName,
JCHAR *szGTKey,
LPMODATA *lpMOData
BOOL bConvRTFText);

Parameters
Parameter Notes Usage
hRequestGT Input/Required GT table handle to be closed
and released.
szObjectName Output Object name (OBNM) -
Character array
szGTKey Output Generic Text Key in the string
format (TXKY) – character
array.
*lpMOData Output Allocated memory for data
bConvRTFText Input TRUE = Convert any RTF text
to plain text.

Return Value
Return Value Description
JDEDB_PASSED Return value if this API succeeds
JDEDB_FAILED Return value if this API fails

Example
Example #1:

JDEDB_RESULT JDBReturn = JDEDB_PASSED;


HREQUEST hRequestGT = NULL;
HUSER hUser = NULL;
JCHAR szFromDatasource[51] = _J(“Business Data – Adev733o”);
JCHAR szObjectName[11] = _J(“ABGT”);

493192510.doc 1
jdeGT_FetchData

JCHAR szFormatKey[255] = _J(“1”);


JCHAR szLang[3] = _J(“”);
LPMODATA lpGTData = NULL;

JDBReturn = JDB_InitBhvr(.., &hUser);

JDBReturn = jdeGT_OpenTable (hUser, szFromDatasource, szObjectName, &hRequestGT);


if (JDBReturn == JDEDB_PASSED)
{
JDBReturn = jdeGT_SelectDataKeyStr (hRequest, szObjectName, szFormatKey, szLang,
OBJ_JDEOLE);
}

if (JDBReturn == JDEDB_PASSED)
{
JDBReturn = jdeGT_FetchData(hRequest, lpGTData, FALSE;
while (JDBReturn = JDEDB_PASSED)
{
jdeGT_DeleteDataKeyStr(hRequest, szObjectName, szFormatKey, lpGTData->nSeq);
jdeGTFreeMOData(lpGTData, 1);
JDBReturn = jdeGT_FetchData(hRequest, lpGTData, FALSE;
}
}

jdeGTFreeMOData(lpGTData, 1);
jdeGT_CloseTable(hRequestGT);
JDB_FreeBhvr(hUser);

return;

Example #2:

JDEDB_RESULT JDBReturn = JDEDB_PASSED;


HREQUEST hRequestGT = NULL;
HUSER hUser = NULL;
JCHAR szFromDatasource[51] = _J(“Business Data – Adev733o”);
JCHAR szObjectName[11] = _J(“ABGT”);
DSABGT dsAbGT = {0};
JCHAR szLang[3] = _J(“”);
LPMODATA lpGTData = NULL;

JDBReturn = JDB_InitBhvr(.., &hUser);

ParseNumericString(dsAbGT.mnAddressNumber, _J(“1”));

JDBReturn = jdeGT_OpenTable (hUser, szFromDatasource, szObjectName, &hRequestGT);


if (JDBReturn == JDEDB_PASSED)
{
JDBReturn = jdeGT_SelectData(hRequest, szObjectName, &dsAbGT, szLang, OBJ_JDEOLE);
}

if (JDBReturn == JDEDB_PASSED)
{
JDBReturn = jdeGT_FetchData(hRequest, lpGTData, FALSE;
while (JDBReturn = JDEDB_PASSED)

B9 January, 2002 2
jdeGT_FetchData

{
jdeGT_DeleteData(hRequest, szObjectName, &dsAbGT, lpGTData->nSeq);
jdeGTFreeMOData(lpGTData, 1);
JDBReturn = jdeGT_FetchData(hRequest, lpGTData, FALSE;
}
}

jdeGTFreeMOData(lpGTData, 1);
jdeGT_CloseTable(hRequestGT);
JDB_FreeBhvr(hUser);

return;

Example #2:

JDEDB_RESULT JDBReturn = JDEDB_PASSED;


HREQUEST hRequestGT = NULL;
HUSER hUser = NULL;
LPMODATA lpGTData = NULL;
JCHAR szGTKey[256] = _J("");
JCHAR szObjName[11] = _J("");
JDBReturn = JDB_InitBhvr(lpBhvrCom, &hUser,(JCHAR *) NULL,
JDEDB_COMMIT_AUTO
);
if (lpDS->idHRequestGT == NULL)
{
JDBReturn = jdeGT_OpenTable (hUser, lpDS->szFromDatasource,
lpDS->szObjectName, &hRequestGT);
lpDS->idHRequestGT = (ID) jdeStoreDataPtr(hUser, hRequestGT);
else
{
hRequestGT = (HREQUEST) jdeRetrieveDataPtr(hUser, lpDS->idHRequestGT);
if (hRequstGT)
{
JDBReturn = jdeGT_SelectData(hRequest, lpDS->szObjectName,
NULL, lpDS->szLang, OBJ_JDEOLE);
if (JDBReturn == JDEDB_PASSED)
{
JDBReturn = jdeGT_FetchDataEx(hRequest, szObjName, szGTKey, lpGTData, TRUE);
if (JDBReturn = JDEDB_PASSED)
{
jdeStrncpy(lpDS->szGTKeyData, szGTKey, 255);
jdeStrncpy(lpDS->szTextData, lpGTData->pData, 255);
jdeGTFreeMOData(lpGTData, 1);
else
{
jdeRemoveDataPtr(hUser, lpDS->idHRequestGT);
lpDS->idHRequestGT = 0L;
}
}
else
{
jdeRemoveDataPtr(hUser, lpDS->idHRequestGT);
lpDS->idHRequestGT = 0L;
}

B9 January, 2002 3
jdeGT_FetchData

if (hRequestGT && lpDS->idHRequestGT == 0)


{
jdeGT_CloseTable(hRequestGT);
}

JDB_FreeBhvr(hUser);
return;

Additional Notes
 This API must be invoke after jdeGT_OpenTable() api is used.
 This API is used for multiple access of the table within one function scope.
 MODATA (or LPMODATA) Data Structure definition:

MODATA, *LPMODATA

Data Type Data Description Note


int nSeq Sequence number from
MOSEQN
MOTYPE nMOType Media Object Type
JCHAR szUser[11] User name
JDEDATE jdDate Date updated
MATH_NUMERIC mnTime Time updated
BOOL bRTFData TRUE = RTF Text
FALSE = Plain Text or others
JCHAR szItemName[GT_ITNM Item name
SIZE]
JCHAR szQueueName[GT_Q
UESIZE]
JCHAR szFileName[GT_FILES
IZE]
PJSTR pData Allocate memory for text and
shortcut media object type.

 MOTYPE definition:

DEFINE TYPE NOTE


OBJ_JDEALL All Media Object Types
OBJ_RTFTEXT Text Media Object
OBJ_JDEIMAGE Image Media Object
OBJ_JDEOLE OLE Media Object
OBJ_MISCJDESHORTCUT Shortcut Media Object
OBJ_MISCIMAGEVENDOR Third party vendor
OBJ_MISCHTML HTML/URL/File Media Object

B9 January, 2002 4
jdeGT_FetchData

See Also

Function Name Description


jdeGT_OpenTable Open F00165 and return the table handle
jdeGT_CloseTable Close F00165 and release table handle
jdeGT_SelectData Select data from F00165 table
jdeGT_SelectDataKeyStr Select data from F00165 table with formatted string
(TXKY)
jdeGT_FetchData Retrieve record from F00165
jdeGT_UpdateData Update record to F00165
jdeGT_UpdateDataKeyStr Update record to F00165 with formatted string (TXKY)
jdeGT_InsertData Insert record to F00165
jdeGT_InsertDataKeyStr Insert record to F00165 with formatted string (TXKY)
jdeGT_DeleteData Delete record from F00165
jdeGT_DeleteDataKeyStr Delete record from F00165 with formatted string
(TXKY)

B9 January, 2002 5

You might also like