Mobile

Re: How to scroll text in an edit control box in a dialog ?

21-Jun-04 9:56

You have to go into the resource editor and tell set the correct properties for the edit control. I believe if you want it to wrap and scroll, you have to set the "wants returns" property.

------- sig starts

"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt

"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

glweid21-Jun-04 10:12

glweid

21-Jun-04 10:12

John

Thanks but I have the want return, vertical scroll and AutoVScroll set and the text does not scroll.

I snapshot the text already in the Edit Box (if any) with GetDlgItemText(hWnd, IDC_EDIT3,textBuff,1024), then add the new text to it and use SetWindowText(hWnd,IDC_EDIT3 ,textBuff) to display the text to IDC_EDIT3.

The Vertical Scroll Bar is being updated (it changes size) but I cannot move it and the text is not scrolling down.

Any other ideas ?

Thx
G. Weideman

Processing rowsets

Member 105289920-Jun-04 23:20

Member 1052899

20-Jun-04 23:20

Hi all,

I am using SQLCE 2.0 with embedded VC 3.0. Application hangs after 67th use of the IRowset object. How should IRowset be used? The error thrown is
"No enough space to perform this command". Please advise on how the rowset be used? How should the memory be handled in this case?

Thank you in advance

Mallee

Processing rowset in SQL CE

Member 105289920-Jun-04 18:26

Member 1052899

20-Jun-04 18:26

Hi all,

Kindly suggest me an efficient way of handling rowsets in SQL CE. My dialog class is bit heavy and I am using the IRowset interface for SQLCE data retrieval. The application hangs when it reaches this method after few test runs. Not able to find where does the problem lie. Please suggest me the necessary resolution.

Thanks in advance,
Mallee

Error:Not enough storage space to perform this command

Member 105289920-Jun-04 0:43

Member 1052899

20-Jun-04 0:43

Hi all,

I am a newbie to SQLCE development . I am using embedded VC++ 3.0 with SQLCE 2.0 on PocketpC 2002 emulator. I am using IRowset and other associated interfaces for fetching records and iterating the rowset from SQLCE .sdf file. It works fine only for 2 to 3 times only. The application hangs when the processrowset method is invoked for repeated no. of times. The error caused is "Not enough storage space to perform this command" . This error occurs at the ICommandText:: Execute method. Following is the processrowset method used. Please help. Very urgent. Thanks in advance, Mallee

void CMyDB::ProcessRowset(int nSkipRecordsValue)
{
HRESULT hr = NOERROR;
LVITEM pitem;
long idx=0;
long lTotalRows = 0;
static long lTotalCols = 0;
long t1=0;
long t2=0;
long elapse=0;
ULONG lColumn = 0;
ULONG lNumCols = 0;
ULONG lCount = 0;
ULONG lNumRowsRetrieved = 0;
ULONG ConsumerBufColOffset = 0;

IAccessor *pIAccessor = NULL;
IColumnsInfo *pIColumnsInfo = NULL;
DBCOLUMNINFO *pDBColumnInfo = NULL;
DBBINDING *pBindings = NULL;

HACCESSOR hAccessor = NULL;
HROW hRows[100];
HROW *pRows = &hRows[0];
BYTE *pBuffer = NULL;

WCHAR *pStringsBuffer = NULL;

CStringArray szFields;
int intIndex=0;
t1 = GetTickCount();
//arrCustom1->RemoveAll();

// Obtain access to the IColumnInfo interface, from the Rowset object.

hr = m_pIRowset->QueryInterface(IID_IColumnsInfo,
(void **)&pIColumnsInfo);

if(FAILED(hr)) {
AfxMessageBox(_T("Failed to query IColumnsInfo interface!"));
}
else {
m_pIRowset->AddRef();
}

// Retrieve the column information.
pIColumnsInfo->GetColumnInfo(&lNumCols,
&pDBColumnInfo,
&pStringsBuffer);

// Free the column information interface.
pIColumnsInfo->Release();

// Create a DBBINDING array.
pBindings = new DBBINDING[lNumCols];

// Using the ColumnInfo structure, fill out the pBindings array.
for(lCount=0; lCount<lnumcols; lcount++)="" {
="" pbindings[lcount].iordinal="lCount+1;
" pbindings[lcount].obvalue="ConsumerBufColOffset;
" pbindings[lcount].ptypeinfo="NULL;
" pbindings[lcount].pobject="NULL;
" pbindings[lcount].pbindext="NULL;
" pbindings[lcount].dwpart="DBPART_VALUE;
" pbindings[lcount].dwmemowner="DBMEMOWNER_CLIENTOWNED;
" pbindings[lcount].eparamio="DBPARAMIO_NOTPARAM;
" pbindings[lcount].cbmaxlen="48;
" pbindings[lcount].dwflags="0;
" pbindings[lcount].wtype="DBTYPE_WSTR;
" pbindings[lcount].bprecision="pDBColumnInfo[lCount].bPrecision;
" pbindings[lcount].bscale="pDBColumnInfo[lCount].bScale;
" consumerbufcoloffset="" +="48;" pdbcolumninfo[lcount].ulcolumnsize;
="" }
=""
="" get="" the="" iaccessor="" interface.
="" hr="m_pIRowset-">QueryInterface(IID_IAccessor,
(void **)&pIAccessor);

// Validation
if(FAILED(hr)) {
AfxMessageBox(_T("Failed to query IAccessor interface!"));
}
else
m_pIRowset->AddRef();

// Create an accessor from the set of bindings (pBindings).
pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA,
lNumCols,
pBindings,
0,
&hAccessor,
NULL);
lTotalCols = lNumCols;

// Get a record
m_pIRowset->GetNextRows(NULL,
0,
0,
&lNumRowsRetrieved,
&pRows);

// Allocate space for the row buffer.
pBuffer = new BYTE[ConsumerBufColOffset];

// Display the rows.

while(lNumRowsRetrieved > 0)
{

//For each row, print the column data.
for(lCount=0; lCount<lnumrowsretrieved; lcount++)="" {
=""
="" initialize...
="" memset(pbuffer,="" 0,="" consumerbufcoloffset);
="" get="" the="" row="" data="" values.
="" m_pirowset-="">GetData(hRows[lCount], hAccessor, pBuffer);

// -- Item

pitem.mask = LVIF_TEXT;
pitem.pszText = (LPTSTR)&pBuffer[pBindings[0].obValue];
pitem.iSubItem = 0;
//AfxMessageBox(pitem.pszText);
CString mFieldValue = pitem.pszText;
//arrCustom1->SetAt(intIndex++,mFieldValue);
arrCustom1->Add(mFieldValue);

}

// Release the rows retrieved.
// Release the rows retrieved.
m_pIRowset->ReleaseRows(lNumRowsRetrieved,
hRows,
NULL,
NULL,
NULL);

// Get the next set of 10 rows.
m_pIRowset->GetNextRows(NULL,
0,
0,
&lNumRowsRetrieved,
&pRows);

};

hr = S_OK;
if (NULL != pBuffer) {
CoTaskMemFree(pBuffer);
//pBuffer = NULL;
}
if (NULL != pIColumnsInfo) {
CoTaskMemFree(pIColumnsInfo);

pIColumnsInfo = NULL;
}
if (NULL != pBindings) {
CoTaskMemFree(pBindings);
pBindings = NULL;
}
pIAccessor->ReleaseAccessor(hAccessor,NULL);
pIAccessor->Release();
if (NULL != pIAccessor) {
CoTaskMemFree(pIAccessor);
pIAccessor = NULL;
}

if (NULL != m_pIRowset) {
CoTaskMemFree(m_pIRowset);
m_pIRowset = NULL;
}

return ;
}

ADO Database

#realJSOP18-Jun-04 10:15

18-Jun-04 10:15

I'm trying to port some ADO db code for use on PocketPC 2003. Is there a definitive explanation about what you need to do to make this a viable effort?

I have a machine with EVC3 installed, and was trying to use Joao's article, and it was importing the adoce31.tlb file, but I can't seem to find that file on my evc3 installation anywhere.

Thanks in advance.

------- sig starts

"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt

"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

João Paulo Figueira18-Jun-04 23:36

18-Jun-04 23:36

Instead of adoce31.tlb, use adoce31.dll - it has all the type library info you need.

Regards,
João Paulo Figueira
Embedded MVP

#realJSOP21-Jun-04 2:41

21-Jun-04 2:41

Well, I tried that, and the compiler is complaining about _NewEnum. Here are the error messages:

<br />
adoce31.tlh(372) : error C2146: syntax error : missing ';' before identifier '_NewEnum'<br />
adoce31.tlh(372) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers<br />
adoce31.tli(16) : error C2065: '_com_issue_errorex' : undeclared identifier<br />
adoce31.tli(340) : error C2143: syntax error : missing ';' before 'tag::id'<br />
adoce31.tli(340) : error C2433: 'IUnknownPtr' : 'inline' not permitted on data declarations<br />
adoce31.tli(340) : error C2501: 'IUnknownPtr' : missing storage-class or type specifiers<br />
adoce31.tli(340) : fatal error C1004: unexpected end of file found<br />

Am I missing a step?

------- sig starts

"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt

"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

João Paulo Figueira21-Jun-04 3:48

21-Jun-04 3:48

Here's how I do it:

#include <wceatl.h>
#include <comdef.h>

_COM_SMARTPTR_TYPEDEF(IUnknown, __uuidof(IUnknown));

void __stdcall _com_issue_error(HRESULT m_hr);
void __stdcall _com_issue_errorex(HRESULT hr, IUnknown *pUnkn, REFIID riid);

#import "C:\Windows CE Tools\wce300\Pocket PC 2002\dataaccess31\target\arm\adoce31.dll" rename_namespace("ADO") rename("EOF", "EndOfFile")
using namespace ADO;

You will have to define your own error handler in _com_issue_errorex.

Regards,
João Paulo Figueira
Embedded MVP

#realJSOP21-Jun-04 4:18

Re: Connecting to COM port

21-Jun-04 4:18

Many thanks, that cleared up that particular set of issues. Now, I'm in a proprietary file form of hell. If I find my way out, I'll let you know. Smile | :)

------- sig starts

"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt

"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Connecting to COM port

Member 1697718-Jun-04 3:44

Member 16977

18-Jun-04 3:44

Hi all,

I want to write the data to COM Port using embeddedVC++ 4.0 .But nothing comes on COM port, code is as follows.
If i debug the application it shows COM port is opened successfully,number of Bytes written is also correct
Do i need to do some settings in emulator to make it connect to com port??

same code works fine in VC++6.0.

////
wchar_t rightString[80];
wcscpy(rightString,_T("Hello"));
DCB m_DCB;

m_DCB.DCBlength = sizeof(m_DCB);
m_DCB.BaudRate = 9600;
m_DCB.ByteSize = 8;
m_DCB.fBinary = TRUE;
m_DCB.Parity = NOPARITY;
m_DCB.StopBits = ONESTOPBIT;
m_DCB.fParity = TRUE;
m_DCB.fNull = FALSE;
m_DCB.XonChar = 0x11;
m_DCB.XoffChar = 0x13;
m_DCB.XonLim = 80;
m_DCB.XoffLim = 200;
m_DCB.fAbortOnError = TRUE;
m_DCB.fOutX = false;
m_DCB.fInX = false;

HANDLE m_hPort = CreateFile(_T("COM1:"), GENERIC_READ |
GENERIC_WRITE, 0,NULL, OPEN_EXISTING, 0, NULL);
SetCommState(m_hPort,&m_DCB);
if(m_hPort == NULL)
AfxMessageBox(_T("Can not open port"));
else
if(WriteFile(m_hPort, rightString, 10, &BytesWritten, NULL))
AfxMessageBox(_T("Successfully written"));

CloseHandle(m_hPort);
///

Thanks in Advance
Tushar Mahajan

glweid21-Jun-04 10:34

glweid

21-Jun-04 10:34

HI
My experience is that the emulators do not connect to the COM ports, you must test on a real device. Make sure you get a device that supports RS232 serial connections !! I found out the hard way that some do not ! Dell Axim X5 does and the HP IPAQ 4000 series and above should also.

G. Weideman

Problem in using Composite index in Seek method on OLEDB/SQL CE

AKSIVAKUMAR17-Jun-04 21:37

AKSIVAKUMAR

17-Jun-04 21:37

HI,

I use the OLEDB method to seek the record:

...
TableID.eKind = DBKIND_NAME;
TableID.uName.pwszName = (WCHAR*)TABLE_TBL1;
IndexID.eKind = DBKIND_NAME;
IndexID.uName.pwszName = L"idx_Key";
...
// Set the Fld1 and Fld2 data to the pData
//
...
// Seek for the first row where the value of the selected column
// is dwEmployeeID.
hr = pIRowsetIndex->Seek(hAccessor, 1, pData, DBSEEK_FIRSTEQ);
if(FAILED(hr))
{
goto Exit;
}

However the Seek function does not working properly.
....

From the calling palce the client will pass like index, value1, value 2 and value3...based on it i need to seek and get the data.

Anyone know how to seek using composite index?

Thanks
AKS

Out of memory

group716-Jun-04 20:15

group7

16-Jun-04 20:15

Hi all,
I need to write application in Pocket PC. It is about using showing video on screen from web cam. I had free the buffer, but the "out of memory" dialog still pop up after 2 minutes....

unsigned char *pbuffer=(unsigned char *)malloc(m_Width * m_Height*6);
unsigned char *rpbuffer=(unsigned char *)malloc(m_Width * m_Height*6);
//this is allocation of memory
free(pbuffer);
pbuffer = NULL;
free(rpbuffer);
rpbuffer = NULL;
//this is the code of free memory

please help....................... D'Oh! | :doh:

p.s. I am using eVC++ 4.0 on PPC 2003....

menubar problem in eVC4.0

group716-Jun-04 18:07

group7

16-Jun-04 18:07

I use embedded visual c++ to write a video cam software, so that the pocket PC show the screen of the cam. But my menubar does not work.(I tick the top up box) When I click the top up button in menubar, the menubar hangs. But the screen still can show the video.

void CGroup7Dlg::OnPreview()
{
unsigned char *pbuffer = (unsigned char *)malloc(m_PrvWidth * m_PrvHeight * 3);
unsigned char *rpbuffer = (unsigned char *)malloc(m_PrvWidth * m_PrvHeight * 3);

if ((PreviewFrame((unsigned char*) pbuffer)) == false)
AfxMessageBox(_T("Preview Frame Fail!"), MB_OK);

Rectify(pbuffer, rpbuffer); //<----- a
CBitmap bitmap;
bitmap.CreateBitmap(m_PrvWidth, m_PrvHeight, 1, 24, rpbuffer);

CVOImage image;
RECT pic_rect;
m_picture_window.GetWindowRect(&pic_rect);
HDC picDC = ::GetDC(m_picture_window.m_hWnd );
CString path_fname;

::WriteBitmapIntoJpegFile(TEXT("\\pic1.jpg"), 80, (HBITMAP)bitmap);

UpdateData(true);
path_fname ="\\My Documents\\pic1.jpg";
image.Load (picDC ,path_fname );
image.Draw (picDC ,2,13 );
free(pbuffer);
pbuffer = NULL;
free(rpbuffer); //<-------b
rpbuffer = NULL;
}

There will be out of memory if I comment out line b but menubar works. There will be no problem but the screen pixel is in wrong order of course. I don't know how to fix this bug. Please help... Frown | :(

EVC++ 4.0 Emulator

#realJSOP16-Jun-04 10:16

16-Jun-04 10:16

Developing apps for PPC2003 using EVC++ 4.0...

What happened to the old emulator. The 4.2 emulator doesn't resemble a PDA at all.

Is there a way to get the old emulator? Will it work?

Thanks in advance.

------- sig starts

"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt

"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

João Paulo Figueira16-Jun-04 11:43

16-Jun-04 11:43

Are you targeting the POCKETPC 2003 or the STANDARDSDK? The PPC 2003 emulator rocks!

Regards,
João Paulo Figueira
Embedded MVP

#realJSOP17-Jun-04 3:07

17-Jun-04 3:07

Well, it's set to standardsdk_420, but I haven't found a way to change it, and I didn't see anything during install about pocketpc2003...

------- sig starts

"I've heard some drivers saying, 'We're going too fast here...'. If you're not here to race, go the hell home - don't come here and grumble about going too fast. Why don't you tie a kerosene rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt

"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

João Paulo Figueira17-Jun-04 3:37

17-Jun-04 3:37

Download it from here:

Developer Downloads[^]

Regards,
João Paulo Figueira
Embedded MVP

#realJSOP21-Jun-04 2:45