|
I have written a class for operating the SQLCE database with OLE DB, it work perfect on INSERT ,UPTDATE and so on, but when I use 'select' statement to get values from database it doesn’t return values properly even though the GetNextRows method succeeds.
HRESULT hr = NOERROR;
m_pIRowset = NULL;
m_prghRows = &m_rghRows[0];
hr = pICmdText->SetCommandText(DBGUID_SQL, pwszQuery);
if(!FAILED(hr))
{
hr = pICmdText->Execute(NULL, IID_IRowset, NULL, NULL, (IUnknown **)&m_pIRowset);
if (FAILED(hr)){
AfxMessageBox(_T("failed"));
m_pIRowset = NULL;
}
// Get IColumnsInfo interface
hr = m_pIRowset->QueryInterface(IID_IColumnsInfo, (void**)&m_pIColumnsInfo);
if(FAILED(hr)){
AfxMessageBox(_T("failed"));
}
// Get the column metadata m_ulNumCols//m_pDBColumnInfo
hr = m_pIColumnsInfo->GetColumnInfo(&m_ulNumCols, &m_pDBColumnInfo,&m_pStringsBuffer);
if(FAILED(hr) || 0 == m_ulNumCols){
AfxMessageBox(_T("failed"));
}
// Create a DBBINDING array.
m_dwBindingSize = m_ulNumCols;
m_prgBinding = (DBBINDING*)CoTaskMemAlloc(sizeof(DBBINDING)*m_dwBindingSize);
if (NULL == m_prgBinding){
hr = E_OUTOFMEMORY;
AfxMessageBox(_T("Memory allocation failure"));
}
// Set initial offset for binding position
m_dwOffset = 0;
// Prepare structures to create the accessor
UINT lCount;
ULONG dwOrdinal;
for (lCount = 0; lCount< m_ulNumCols; lCount++)
{
dwOrdinal = m_pDBColumnInfo[lCount].iOrdinal;
m_prgBinding[lCount].iOrdinal = dwOrdinal;
m_prgBinding[lCount].dwPart = DBPART_VALUE | DBPART_STATUS | DBPART_LENGTH;
m_prgBinding[lCount].obLength = m_dwOffset;
m_prgBinding[lCount].obStatus = m_prgBinding[lCount].obLength + sizeof(ULONG);
m_prgBinding[lCount].obValue = m_prgBinding[lCount].obStatus + sizeof(DBSTATUS);
m_prgBinding[lCount].wType = m_pDBColumnInfo[lCount].wType;
m_prgBinding[lCount].pTypeInfo = NULL;
m_prgBinding[lCount].pObject = NULL;
m_prgBinding[lCount].pBindExt = NULL;
m_prgBinding[lCount].dwMemOwner = DBMEMOWNER_CLIENTOWNED;
m_prgBinding[lCount].dwFlags = 0;
m_prgBinding[lCount].bPrecision = m_pDBColumnInfo[lCount].bPrecision;
m_prgBinding[lCount].bScale = m_pDBColumnInfo[lCount].bScale;
switch(m_prgBinding[lCount].wType){
case DBTYPE_WSTR:
m_prgBinding[lCount].cbMaxLen = sizeof(WCHAR)*(m_pDBColumnInfo[lCount].ulColumnSize + 1); // Extra buffer for null terminator
break;
default:
m_prgBinding[lCount].cbMaxLen = m_pDBColumnInfo[lCount].ulColumnSize;
break;
}
// Calculate the offset, and properly align it
m_dwOffset = m_prgBinding[lCount].obValue + m_prgBinding[lCount].cbMaxLen;
m_dwOffset = ROUND_UP(m_dwOffset, 8);
}
// Get IAccessor interface
hr = m_pIRowset->QueryInterface(IID_IAccessor, (void**)&m_pIAccessor);
if(FAILED(hr))
{
AfxMessageBox(_T("failed"));
}
// Create the accessor
//
hr = m_pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA, m_dwBindingSize,
m_prgBinding, 0, &m_hAccessor,NULL);
if(FAILED(hr))
{
AfxMessageBox(_T("failed"));
}
// Allocate data buffer.
//
m_pData = (BYTE*)CoTaskMemAlloc(m_dwOffset);
if (NULL == m_pData)
{
hr = E_OUTOFMEMORY;
CString errors;
errors.Format(_T("%d"),m_pDBColumnInfo[2].ulColumnSize);
MessageBox(NULL,errors,NULL,MB_OK);
AfxMessageBox(_T("failed"));
}
// Retrive a row
//
hr = m_pIRowset->GetNextRows(DB_NULL_HCHAPTER, 0, 1, &m_cRowsObtained,&m_prghRows);
if (SUCCEEDED(hr) && hr != DB_S_ENDOFROWSET)
{
// Set data buffer to zero
//
memset(m_pData, 0, m_dwOffset);
// Fetch actual data
hr = m_pIRowset->GetData(m_prghRows[0], m_hAccessor, m_pData);
if (FAILED(hr))
{
m_pIRowset->ReleaseRows(1, m_prghRows, NULL, NULL, NULL);
AfxMessageBox(_T("failed"));
}
}
if (hr == DB_S_ENDOFROWSET)
{
m_bIsEOF = TRUE;
}
}
venkat
|
|
|
|
|
Hi,
I tried to create a SmartDevice MFC application using VS 2005. I have
installed Windows Mobile 6 Professional SDK. I have created an MFC
smartDevice application(Dialog based). When I tried to compile the
application, I am getting an error. #error Must define a target
architecture.
Please let me know how to fix this issue.
Thanks
Sri
|
|
|
|
|
I m jay & I m doin a project for which I required a SMS Gateway. I used NowSMS for sending & recieving SMS through my cell phone connected via USB. But NowSMS cannot read the msgs that I sent to the connected mobile. I hve tried some settings but I m not a Network Specialist, so I dont know some of the settings like SMPP server, POP3, SMSC & other such stuff. Can anybody plz help me in this. Can somebody gve me the general settings for the NowSMS. Plz reply
|
|
|
|
|
Hi
i have developed a Mobile web application in which i have made to display few data in ObjectList control.I have a template column as Link and on clicking,it'll move to a detail page.
And below that control am having another control mobile:Command to navigate to next page...I have made the Format property of Command control to 'Link'...
Am facing two problems when am trying to view this app in a Blackberry Simulator. One is when i try to click the template column's link,its throwing 'Javascript Error'. Another one is,the Command control is always displayed as Button even if the Format is made to 'Link'..But these two works fine if i view this app thro' Internet Explorer..
Can anyone help me in resloving these problems,please?
Thanks
~Vsree
|
|
|
|
|
 i am not able to use ::CommandLineToArgvW in EVC while the samething worked in VC . I have included the necessary shellapi.h and shell32.lib ,but am still getting errors like ,
error C2039: 'CommandLineToArgvW' : is not a member of '`global namespace''
error C2065: 'CommandLineToArgvW' : undeclared identifier
error C2440: 'initializing' : cannot convert from 'int' to 'unsigned short ** '
|
|
|
|
|
Not implemented on Windows CE.
When implementing the first version of Windows CE, the developers stripped out everything that wasn't essential. Where there were multiple overlapping implementations of a concept, that could be implemented in terms of each other, they selected one of them. This was done to reduce the footprint of the operating system - early CE devices only had a couple of megs of ROM available. Over time, some have been added back in, but in general it's still a much-reduced feature set.
You'll have to implement it yourself.
|
|
|
|
|
I am unable to run sub-query in my pocket pc application.
Do I have to install any ServicePack or any pathc for SQL Server Comapact Edition or what should I do to be able running my SQL query inside dsf file?
I have tested query in SQ Server 2000 and it works perfectlly but inside sdf file doesn't.
Regards
I Love SQL
|
|
|
|
|
SQL Server CE has an extremely restricted query language compared to SQL Server 2000. If you have MSDN Library for Visual Studio 2005, go to the Contents tab, then in the tree go to Enterprise Servers and Development, SQL Server, SQL Server 2005 Documentation, SQL Server 2005 Mobile Edition Books Online, SQL Server Mobile Programming, SQL Reference for SQL Server Mobile, or look online here[^].
If you run a project referencing SQL Server Mobile/SQL Server CE from Visual Studio, it will deploy a package containing a CE version of Query Analyzer. You can try out queries from here. Best used on the emulator because you can use your real computer keyboard to enter the query.
SQL Server 2005 Management Studio can load SQL Server 2005 Mobile Edition/SQL Server Compact Edition 3.1 .sdf files and query them. At the 'Connect to Server' prompt, select 'SQL Server Mobile' from the Server Type drop-down list.
|
|
|
|
|
 Hi everyone.
I am trying to build a file system filter on Windows 5.0 pocket PC Emulator.
I am using sample code of FSDSPY which i got from following path
%_WINCEROOT%\public\common\oak\drivers\fsd\fsdspy\
I have created a MyFilter.dll.
Then I created another application which register, and copy DLL in
/Windows directory.
I put the registry key as
HKEY_LOCAL_MACHINE\System\StorageManager\Filters\MyFilter
Given two value as MyFilter.dll and order value 4.
After executing this application, I had soft reset my emulator,
But my file system filter has not been loaded.
In Remote Process viewer, I can't see my MyFilter.dll used by filesys.exe.
Does fsdmgr.dll exist on Windows 5.0 pocket PC Emulator?
If any one have idea about this then please reply.
Pocket PC Development
|
|
|
|
|
Hello,
I have problems with cabwiz.exe and .inf file.
When my program is installed in Smartphone, it is absent in add/remove
programs list. But in PocketPC it is.
I think there is something with cabwiz.exe and .inf file.
Can anybody help me?
Thanks.
a_sklyar
|
|
|
|
|
Hi,
I have a palm Pc (Looket G8) and I want to install a program in it.But I cannot see the Setup File of the program that I want to install in G8.Because when I open the G8 I see
only "IMAGE VIEWER","NAVIGATION","MUSIC","SETUP" buttons as the
interface.And none of them shows me the setup file.How can I install the program.Someone can help me?
Thanks
ibrahim
|
|
|
|
|
i am Surjeet Singh Sidhu.
any can help simple application create for nokia 7610 and codes of simple application. please please----------
surjeet_sidhu2007@hotmail.com
surjeet singh
|
|
|
|
|
I am working on a project that requires customization of a mobile device (a smart phone seems logical) to run a simple program. The program only needs to prompt the user (Enter a number btw 0-9) and then send a message that contains information about the user (pre-stored on the phone) as well as the value just entered. The message could be simple SMS messaging to another mobile user or an email account. This application DOES NOT have to be portable to other devices. I'm looking for advice on the choice of particular devices and programming environemnts to do the above. I don't know JAVA and it has been over a decade since I did any C or C++ programming so I would prefer the simplest programming environemnt possibe (VB?). Any suggestions are most welcome.
|
|
|
|
|
I have a multithreaded COM object I want to convert to Pocket PC. I have added the build type and appropriate build options but I find that there is no _beginthread function.
Does the pocketPC support multiple threads and if so, can you point me to an example.
Hell I thought it was funny .....
|
|
|
|
|
_beginthread is a function in the desktop C runtime which wraps up the underlying CreateThread operating system function. On the desktop, you should always use _beginthread or _beginthreadex to ensure that the C runtime is properly initialised.
On Windows CE, the C runtime is integrated into the OS, as part of the core system DLL coredll.dll. CreateThread handles initialising the C runtime for the new thread in addition to its other tasks. Therefore _beginthread is not necessary and is omitted. You should use CreateThread.
|
|
|
|
|
Thank you, and of course.
Hell I thought it was funny .....
|
|
|
|
|
Is it possible, from within a desktop application, to force activesync not to run?
I have a desktop application that will have problems if a handheld device is cradled and synchronized while the desktop application is running.
|
|
|
|
|
I'm finding how to set password and lock a folder in Win CE?
Can someone show me which book I should read or where to start?
Nothing Is Impossible !
|
|
|
|
|
Hello,
My program in not in Add/Remove Programs list on Smartphone, but in Pocket PC is.
So I can't uninstall it.
I think it is something with .inf file while creating a .cab file.
I use CabWiz.exe tool.
Can somebody help me?
Windows Mobile 5.
Thanks.
a_sklyar
|
|
|
|
|
Dear All,
I need to create an application for folder selection dialog.
Can anyone give me a sample code for Cfolderdialog inherited from Cfiledialog in embedded vc++ or pls suggest me a method to create a folder selection dialog in Embedded VC++ Thanks in Advance.
-- modified at 8:09 Tuesday 20th March, 2007
|
|
|
|
|
Hi, in order to test my application on some other device I have created a .CAB to pass to some friend… but I have had some difficulty because if the PDA of the friend does not have the runtime installed and tries to install it from my PC, comes given the already present message of version in the system. What's the corrected procedure to execute? Naturally excluding the deploy from VS…
Alex
Alex
|
|
|
|
|
Best practice is probably to use Microsoft's end-user redistributable. Download .NET CF 2.0 SP1 from here[^].
If required you can simply grab the CAB from the install folder. The filename to use depends on the exact device you're installing on. For Windows Mobile 2003 and 2003 SE Pocket PCs, use NETCFv2.ppc.armv4.CAB. For Windows Mobile 5.0, use NETCFv2.wm.armv4i.CAB. These are also part of the Visual Studio 2005 install, under C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\CompactFramework\2.0\v2.0\WindowsCE, wce400\armv4 and wce500\armv4i respectively. If you installed Visual Studio to a different folder, you'll need to change that path appropriately.
|
|
|
|
|
Perfect! Thanks a lot!
Alex
|
|
|
|
|
Hi
I'm developing a program based on Client-Server porgramming in embedded VC++ 3.0 with pocket PC 2000 emulator. I'm using Winsock API's. Client and Server both are running on different Pocket PC emulator. But i'm not able to estabilsh a connection between the Server and Client. Server program is blocking at "accept" API. Client program is waiting for some time and its showing 10060 error.
When i checked the status of the particular PORT which i'm using in the Server program, in command window using "netstat -n" command, it's not listed in the LISTENING PORT list.
Can anybody help me to resolve this?
|
|
|
|
|
Dear All,
We need to create an application for folder selection dialog and we have creted using SHBrowseForFolder concept.Using this concept we were able to compile and run the application in Emulator.Whereas when we are trying to run the application in CEPC(x86 processor), it just hangs and shows the message as "Unknown: DEBUGCHK failed in file C:\WINCE500\PUBLIC\SHELL\OAK\HPC\CESHELL\API\.\api.cpp at line 385".It happens when the application issues the api SHBrowseForFolder.Can anyone suggest an idea to solve this problem.
Thanks in Advance.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
