Database - Mobile Discussion Boards

Access Table some problem with new columns

Rassul Yunussov20-Jan-04 19:55

20-Jan-04 19:55

Why My pocket PC makes new columns with counter???
For example i have the table with columns:
PointID - counter;
X int;
Y int;
and when i copy this database to pocket and get it back to Desktop PC i got this:
Point ID - int;
X -int;
Y -int;
ID1 - counter;
Where is the problem???

Re: Access Table some problem with new columns

João Paulo Figueira20-Jan-04 22:27

João Paulo Figueira

20-Jan-04 22:27

Try using the Pocket Access option on ActiveSync to synchronize your databases.

What is happening is that when you copy the Access file to the Pocket, it will lose all unique indexes and counter fileds. They will become integer fileds with a non-unique index (read the ActiveSync help on this). When you copy it back to the desktop, the conversion mechanism seems to automatically create a unique ID field for the table.

When synchronizing databases through ActiveSync, this problem never happened to me.

Regards,
João Paulo

installer?

slomoman20-Jan-04 3:01

slomoman

20-Jan-04 3:01

How can I create a Installer for my evc-PPC2002-MFC-Program? Most programms come with installers that you start on the desktop and that copy all required filed to the device via ActiveSync.
Are there tools for doing that? Maybe free tools? Or is it include in eVC somewhere? thx..

thx, Daniel

Re: installer?

João Paulo Figueira20-Jan-04 3:49

João Paulo Figueira

20-Jan-04 3:49

You install applications on a pocket PC using a two step approach.

First, you have to create a setup cab file. Information for this is available on the SDK help, but you can find a sample here:

QA: How can I install ADOCE 3.1?[^]

Next, you have to copy the cab file to the Pocket PC and execute it. You can do this manually or through ActiveSync's Application Manager. Search the "Registering with Application Manager" item on the SDK help.

Regards,
João Paulo

Re: Wireless Communication

misha_grewal18-Jan-04 23:50

misha_grewal

18-Jan-04 23:50

you can sync data using wireless or wired options. In either ways you can get connected to the server.
Types of options you can have
1. Wireless
2. Wired - via Modem to internet, or LAN

It works fine with all these options..

Re: Wireless Communication

Mahesh Varma20-Jan-04 22:01

Mahesh Varma

20-Jan-04 22:01

Hi,

Can you please explain more about wireless communication, and how it can be done using .NET compact framework.

Mahesh

Re: Wireless Communication

annum22-Jan-04 16:55

annum

22-Jan-04 16:55

Mahesh,

Look into Bluetooth, as it already supports Active sync over Bluetooth.
And many PDA's like iPAQs come preintalled with bluetooth and Windows CE supports bluetooth API as well that you can use.

Database

Rassul Yunussov18-Jan-04 19:37

Rassul Yunussov

18-Jan-04 19:37

I have some question about CADORecordset.
I've got the code like this:

void CAccessLayer::Repaint()
{
	CADORecordset rs(&g_db);
	CString Query;
	Query = "SELECT * FROM Points WHERE LayerID = "+m_LayerID;
	int X;
	int Y;
	if(rs.Open(Query,CADORecordset::openQuery))
	{
		rs.MoveFirst();
		for(int i = 0; !rs.IsEof(); rs.MoveNext(), ++i)
		{
			rs.GetFieldValue(_T("X"),X);
			rs.GetFieldValue(_T("Y"),Y);
			X=(_BitmapWidth*(_rotate*X - _ViewLeft))/_WR;
			Y=(_BitmapHeight*(_rotate*Y - _ViewTop))/_HR;
			_BitmapCanvas->Ellipse(X-100,Y-100,X+100,Y+100);
		}
	}
	rs.Close();

}

but i use this function very often, and i'd like to place the query in the constructor of the class. And i want to call in the function only this:

void CAccessLayer::Repaint()
{
                rs->MoveFirst();
		for(int i = 0; !rs->IsEof(); rs->MoveNext(), ++i)
		{
			rs->GetFieldValue(_T("X"),X);
			rs->GetFieldValue(_T("Y"),Y);
			X=(_BitmapWidth*(_rotate*X - _ViewLeft))/_WR;
			Y=(_BitmapHeight*(_rotate*Y - _ViewTop))/_HR;
			_BitmapCanvas->Ellipse(X-100,Y-100,X+100,Y+100);
		}
}

And in constructor i have this :

rs = new CADORecordset(&g_db);
CString Query;
Query = "SELECT * FROM Points WHERE LayerID = "+m_LayerID;
rs->Open(Query,CADORecordset::openQuery));

But my programm doesn't work. Is it necessery to have CADORecordset locally???
Thaks.

Re: Database

João Paulo Figueira19-Jan-04 4:45

João Paulo Figueira

19-Jan-04 4:45

Is g_db initialized when the constructor is called?

Regards,
João Paulo

Wireless Communication

Mahesh Varma16-Jan-04 21:36

Mahesh Varma

16-Jan-04 21:36

Hi All,

I have an Inventory application running on the desktop(Developed using C#). I'm planning to write one for PDA( Using C# & .NET Compact Framework). But the issue is that, i want to synchronize data between the destop application and the handheld application.IR communication is not possible, as it is limited for a very short distance.
Can any one throw light on other communication options available( like GPRS, wireless etc..).

Thanks in advance
Mahesh Varma

eMbedded Visual C++ 3.0

dhdhaha16-Jan-04 21:12

dhdhaha

16-Jan-04 21:12

How to create a Console Application in eMbedded Visual C++ 3.0 for Pocket PC emulation

Thanks.

Re: eMbedded Visual C++ 3.0

João Paulo Figueira18-Jan-04 5:07

João Paulo Figueira

18-Jan-04 5:07

The Pocket PC does not support native console applications. You have download a third party console.

Regards,
João Paulo

Re: eMbedded Visual C++ 3.0

P_JAYAPRAKASH23-Jan-04 3:10

P_JAYAPRAKASH

23-Jan-04 3:10

u select WCE application as ur project type!

class for uuencode/uudecode on pocket pc

bryce16-Jan-04 18:05

bryce

16-Jan-04 18:05

Hi i'm looking for a mime encoder/decoder class for the pocket pc (am using evc++ 3.0)
does anyone have any useful suggestions for a class to use that they know works?
regards
Bryce

---
Publitor, making Pubmed easy.
http://www.sohocode.com/publitor

More weirdness

#realJSOP16-Jan-04 6:27

#realJSOP

16-Jan-04 6:27

I use the File Open dialog from an article on CP, and it works fine when used form my app class.

Weirdness, Part 1 - In our app, we have a listview. One of the contxt menu items needs to call up this dialog box also. However, the dialog box displays, but locks up when called from the listview.

Weirdness, Part 2 - If I put a call to AfxMessageBox in the dialog's OnInitDlg() function, the dialog box works fine after I dismiss the message dialog. If I don't display the message dialog, the dialog box locks up.

Weirdness, Part 3 - The "X" button in the titlebar doesn't work, but the SIP does, and I can dismiss the dialog box by clicking the ENTER key in the SIP.

Anyone have any hints?

------- signature starts

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

"You won't like me when I'm angry..." - Dr. Bruce Banner

Please review the Legal Disclaimer in my bio.

------- signature ends

Re: More weirdness

cmk17-Jan-04 9:10

cmk

17-Jan-04 9:10

Are you using property sheet/pages and dialogs, or just dialogs ?

They all sound like the same problem - the new dialog isn't getting the focus when it should.

I've had something similar happen when, for instance, i created a dialog resource as a property page, then changed my mind and used as a CDialog without changing the resource properties from child to popup. Also make sure the new dialog isn't overlapped, i think that only the main app dialog can safely be overlapped (cound be wrong - have't checked).

For Part 3 : the X is part of the dialog/page, the SIP isn't, hitting enter in the SIP just acts as if you hit the default button on the dialog/page - usually IDOK.

On an unrelated note, here are some other things i've found :

There is a bug in MFC CPropertySheet::ContinueModal(), so in any PS derived class' override with :
class CkDlgEdit : public CPropertySheet
...
BOOL CkDlgEdit::ContinueModal()
{
if( !CWnd::ContinueModal() ) return(FALSE);
return(TRUE);
}

There is a resource leak when displaying a dialog box. The following methodology evidently prevents this :
void CJsoFldCeDlg::OnDblclkList( NMHDR *pNMHDR, LRESULT *pResult )
{
...
{
CkDlgEdit dlg(this, L"Edit Observation");
dlg.DoModal();
}
AfxGetApp()->OnIdle(1);
...
}

...cmk

Save the whales - collect the whole set

Re: More weirdness

João Paulo Figueira20-Jan-04 3:54

João Paulo Figueira

20-Jan-04 3:54

John Simmons / outlaw programmer wrote:
Weirdness, Part 1

Try inserting this on the OnInitDialog handler right after the call to the base class' handler:

if(::GetCapture())
    ::ReleaseCapture();

Regards,
João Paulo

Web Services on the Pocket PC with .NET Compact Framework

Colin Angus Mackay16-Jan-04 3:19

Colin Angus Mackay

16-Jan-04 3:19

I've had a search around and I'm at a bit of a loss... So here goes...

Background: I have a Pocket PC application that creates XML files. The PPC application reads and writes them using XmlTextReader/Writer. These files can be synchronised through ActiveSync and a desktop application allows the data to be reviewed before going in to the database.

Situation: Now, the data is to communicate with a Web Service. Since I already have the XML structure defined is there anyway I can put that across to the server without ending up with lots of > and < etc.? At the moment I define the data type in the Web Service as a string and copy the contents of the file into the string and send it across.

--Colin Mackay--

EuroCPian Spring 2004 Get Together[^]

access the pda's addressbook

slomoman15-Jan-04 3:01

slomoman

15-Jan-04 3:01

Is it possible on pocketPC 2002 with evc++ to access the pda's address book. I wanna search for a certain address and read the fields of it like phone-number, street, city etc.
Any samples? Thx alot

thx, Daniel

Re: access the pda's addressbook

João Paulo Figueira15-Jan-04 4:49

João Paulo Figueira

15-Jan-04 4:49

You have to use the POOM. Check here:

http://www.pocketpcdn.com/sections/mail.html[^]

Regards,
João Paulo

TMobile ROM Upgrade to WM2003

alaa_m15-Jan-04 0:22

alaa_m

15-Jan-04 0:22

Hi All,

Have any of you tried to upgrade their ROM in www.yorch.net site?
I tried to burn a ROM but the site doesn't seem to be working. Does any of you know a good place for download a ROM upgrade to WM2003 for the XDA TMobile Pocket PC? Confused | :confused:

Thanks,
Alaa

Can I Use AT Commands for CDMA

misha_grewal14-Jan-04 3:08

misha_grewal

14-Jan-04 3:08

Hi,
I read Daniel's article for communicating between a PDA and a phone. Can I use these AT commands with a CDMA phone.

.inf How to create new folder

Rassul Yunussov13-Jan-04 4:41

Rassul Yunussov

13-Jan-04 4:41

I want to install programm on my pocket PC.
But i'd like to create new directory and install files into it.
What to write in .inf file to create new folder???
I tried this expression:

InstallDir = %ce1%\SomeFolder

and i had an error message on my pocket PC.
It says that CAB file is wrong.
Thanks.

Re: .inf How to create new folder

João Paulo Figueira13-Jan-04 5:21

João Paulo Figueira

13-Jan-04 5:21

Try like this:

[CEStrings]
AppName="MyApp"
InstallDir=%CE1%\%AppName%

Regards,
João Paulo

How to know the default Documents folder

Cedric Moonen12-Jan-04 20:48

Cedric Moonen

12-Jan-04 20:48

The documents folder (My Documents) change with the user language of the Pocket PC. I need to know this name. How can I do this?

Thanks

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.