SqlCE Debugging/Troubleshooting

  • Thread starter Thread starter Jerod Houghtelling
  • Start date Start date
J

Jerod Houghtelling

Hi all,

I'm having an issue when executing an RDA pull and then creating a
secondary key from certain situations. Does anybody know of a good
tool that might help me track down this issue?

Pocket PC 2003 SE
C# Compact Framework 2.0
SQL Server 2005 CE

The issue occurs after an RDA pull does not finish successfully. One
way I get this to happen is if the device is rebooted in the middle of
the RDA pull. The next time the program is ran the RDA pull finishes
successfully, but then the program crashes when I alter the table to
add a secondary key. The crash is uncatchable neither a
catch(Exception) or generic catch seems to do any good. The weird
thing is that if I change from applying a secondary key to any kind of
data modifying sql statement the program still silently blows up. It
doesn't even matter if I use the same table that was being pulled!!!

Thanks in advance,
Jerod
 
I'm not sure what you mean by "secondary key" you can only have one key in
SQL CE.
 
I'm not sure what you mean by "secondary key" you can only have one key in
SQL CE.
Click to expand...

Sorry, "Secondary INDEX", but that's beside the point because any
INSERT, UPDATE, DELETE, or ALTER statement completely kills the
program.
 
Simon,

Sorry for my ignorance, but is it possible to trace the SQL statements
on a Pocket PC 2003 SE device? Is there a special program that I need
to do this?

Thanks in advance,
Jerod
 
Back
Top