|
Hi guys,
Here is my situation, I have a program that creates a database, and as long as you do not sync it to the desktop it is fine and works great, you can also export it to the desktop without any negetive side effects, the problem comes when you sync the db back from the desktop to the handheld. Even if you don't edit it on the desktop, the program that I have can't write to some of the tables. It still reads to them but can't edit or add to them. I have not at all changed the tables, just synced to desktop and then brought back to the handheld. Any ideas, I am using active sync ver 3.7 (build 3083). I am wondering if anyone knows where to get something to compare the databases (before sync and after sync). Something is happening during the syncing and conversion process. I am really stuck on this one mad: PLEASE HELP!!!
Thanks for the help guys,
Rod
|
|
|
|
|
If you are using Pocket Access databases (cdb) on the Pocket PC, check if, when they are copied to the desktop, a new key column with an autonumber type is added.
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
No there doesn't seem to be a new key column. The only thing that I notice is that some of the indexes disappear. Having the databases missing the indexes doesn't seem to effect the program in any way, as I have created the tables without the indexes and the program still works fine until you bring them across to the desktop and then back to the ppc.Any other ideas??? Thanks every bit helps, I appericiate your suggestions.
Thanks,
Rod
|
|
|
|
|
Can you please send me a sample database so that I can test it?
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
Did you get the database that I sent you? I was wondering if there are reserved words such as maybe "Field" or something like that. Any other ideas?
Again,
Thank you very much,
Rod
|
|
|
|
|
Hi Rod,
Sorry! I've been busy and and got a cold on top of my usual spring allergies... The mdb was blocked. Can you zip it and send it again?
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
|
Yes: I found that you are using an older version of Access. What is it by the way?
I cannot replicate you problem because I'm running Access 2003.
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
I am using access 2002. should this make a diference since I am having the problem on the hand held side? I am not having a problem openning it on the desktop, The problem comes when the database is synced back into the handheld. Then I can't add to the database on the hand held. Did you install the version I sent you on your handheld? It works fine on there and you can add a visit after syncing back to the handheld from the desktop? Again, Thanks for your help on this, I appriciate it greatly.
Thanks,
Rod
|
|
|
|
|
I figured it out!!!!! Active sync doesn't know how to convert OLE objects so it just discards them. I took these out of the pocket version of the program and it works like a charm. Thanks so much for the help and the time that you put into this João, I really do appriciate it.
Till next time,
Thanks again,
Rod
|
|
|
|
|
This may be a silly question but how do you associate files with an executable on Pocket PC either 2002 or 2003 flavours?
Any help would be appreciated.
Ant.
|
|
|
|
|
Never mind I have found it in MSDN, some days I just dont seem to find anything in there! 
Ant.
|
|
|
|
|
I encountered an SQL exception when I load the following codes. The exception "SQL server does not exist or access denied, Line 0 .NET sqlclient data provider". I used the .NET smart device application and run it with its emulator or with a PDA the above exception occurred but if I run it using the compiled exe application on my computer it works. Can anyone help or is there a website meant for compact framework?? Thanks alots for ur attention.
string tempStr = "SELECT CountryCode " +
"FROM Inventory_Dept_Mapping " +
"WHERE (DeptCode = @DeptCode) " +
"GROUP BY CountryCode";
DataSet tempDS = new DataSet();
SqlCommand sqlCom = new SqlCommand(tempStr, new SqlConnection(DataBaseConnectionString));
sqlCom.Parameters.Add("@DeptCode", SqlDbType.VarChar);
sqlCom.Parameters["@DeptCode"].Value = this.DeptCode;
SqlDataAdapter sAdapter = new SqlDataAdapter(sqlCom);
try
{
sAdapter.Fill(tempDS, "ctrycode");
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message + "\nLine " + ex.LineNumber + "\n" + ex.Source);
}
|
|
|
|
|
How do I associate an icon with an application so explorer displays my icon?
|
|
|
|
|
What is youd development environment?
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
If u r using eVC++, u could paste your app icon in Resources->Icon as bitmap.
|
|
|
|
|
Hi,
I've derived my View Class from CScrollView so I could use the scroll bars when displaying images. But I seem to be having a few problems.
When calling a method from the CScrollView in the View Class I've tried stuff like
CScrollView::SetScaleToFitSize(p);
SetScaleToFitSize(p);
this->SetScaleToFitSize(p);
everything compiles and runs but the changes don't take affect in the emulator or the device. I’ve also tried methods like
SetScrollRange(0, 0, FALSE);//SB_VERT & SB_HORZ
SetScrollRange(SB_VERT, 0, 0, FALSE);
SetScrollRange(SB_HORZ, 0, 0, FALSE);
but again these have no affect. Everything else is working grand, I can move about using the scroll bars etc.. but the idea was to have them hidden but be able to use their functionality.
Any input would be very helpful.
ar
|
|
|
|
|
Ok, I did some more reading and I'm guessing the function (SetScrollRange())is not available for the Pocket PC, but an overloaded one is, but I need to pass the handle of the scroll bar into the function call.
How can I get the handle of a scrollbar from a class that is derived form the CScrollView class so that I might be able to pass it into it?
Thanks again,
ar
|
|
|
|
|
Dear All..
I am going to work on build an SMSC (Short Message Service Centers) application (SMS Connector to GSM Server) and i am new with dealing this subject in vc++, i make my own research on this field but i had good idea about the hole process of SMSC but i still need technical information so if there is any one had been worked on something like that to help me with this application or if anyone know web site i can use to guide me in that i will be grateful..
Best Regards,
Rasha
|
|
|
|
|
Is there any way, programmatically, for preventing lost data whenever I
hard-reset PocketPC2002 and PocketPC2003?
In the other word, I need to run a specific .exe file after my PocketPC2002 and PocketPC2003 boot-up
(power-up) .
Any Answer is most welcome.
Regards
Patra
|
|
|
|
|
Storage:
Internal flash rom (such as the iPAQ file store) or external storage devices (CF, SD, etc) if your device offers such capabilities.
Running an exe after a cold boot:
If you use an external storage device, the os will look for \[storage device]\[processor type]\autorun.exe when it boots (or when a card is reinserted). As for internal flash rom, I dont know.
[Edit: removed < and >]
/Jonas
---
"Man will never be free until the last king is strangled with the entrails of the last priest". -- Denis Diderot
|
|
|
|
|
Thanks for your reply.
How can i know storage device folder name programmatically for different device like IPAQ,TOSHIBA,Imate,Dell etc .
Regards
Patra
|
|
|
|
|
Im not sure you can do this with 100% certainty on all possible pda + external devices combinations. SHGetSpecialFolderLocation/Path might help you.
---
"Man will never be free until the last king is strangled with the entrails of the last priest". -- Denis Diderot
|
|
|
|
|
I have already done this on the past with an iPAQ 5450 and 3850. The iPAQ File Store folder operates as a flash card when the device is cold booted, so placing an autorun.exe under a \iPAQ File Store\2577 folder will achieve the effect you desire. Beware of removable cards because if any of these is inserted upon cold boot, it will receive higher priority: the autorun.exe on the \iPAQ File Store\2577 folder will not be run.
Regards,
João Paulo Figueira
Embedded MVP
|
|
|
|
|
What are my options if I want to use SOAP for an application developed using eVC++ 4?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
