C / C++ / MFC

   CFieldExchange fieldX;
   LPCTSTR szName[256];
   LPSTR prgStrVals;
   long* prgLengths;
   int nMaxLength = 255;

RFX_Text_Bulk(&fieldX, szName, &prgStrVals, &prgLengths, nMaxLength);

CFieldExchange fieldX;
LPCTSTR pszName = "ColName";
LPSTR prgStrVals[nRows];
long prgLengths[nRows];
for (int i = 0; i < nRows; ++i)
{
    prgStrVals[i] = (LPSTR)new char[256];
}
int nMaxLength = 256;

RFX_Text_Bulk(&fieldX, pszName, &prgStrVals, &prgLengths, nMaxLength);

Larry Mills Sr wrote:

Please excuse my ignorance

CFieldExchange fieldX;       // this will probably be defined elsewhere
LPCTSTR pszName = "Recipe";  // column name [ or should it be "m_Instructions" ? ]
int nRows = ?;               // set this to the number of rows in the data source
int nMaxLength = 1024;       // max length of each row of data returned
LPSTR prgStrVals[nRows];     // the rows of data will be stored in these fields
long prgLengths[nRows];      // the length of the data stored in prgStrVals goes in these fields
// initialise the strings for storing the data
for (int i = 0; i < nRows; ++i)
{
    prgStrVals[i] = (LPSTR)new char[nMaxLength];
}

RFX_Text_Bulk(&fieldX, pszName, &prgStrVals, &prgLengths, nMaxLength);

Larry Mills Sr wrote:

RFX_Text_Bulk(pFX, _T("[Instructions]"), (LPSTR *)&m_Instructions,(long**)prgLengths,nMaxLength);//doesn't work

RFX_Text(pFX, _T("[Instructions]"), m_Instructions, 1024);

Larry Mills Sr wrote:

I tried that, and while it gave me no errors; it also DID NOT put all the data from m_Instructions into the database (It has the data in the varable before calling Update();)

Larry Mills Sr wrote:

it also DID NOT put all the data from m_Instructions into the database (It has the data in the varable before calling Update();)

int CMainFrame::OnCreate(LPCREATESTRUCT lpCreateStruct)
{	
	if (CFrameWnd::OnCreate(lpCreateStruct) == -1) //crash position
		return -1;

	return 0;
}

DavidBrother wrote:

Give me a hand please!

DavidBrother wrote:

sm.Format(_T("%x"),pAddresses->PhysicalAddress);