Strange String Truncation Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: BradO <BradO@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 20 May 2009 08:55:01 -0700

Using Visual Studio 2005, SQLCE, compact framework, Windows Mobile 5

I'm receiving a "String Truncation, Max=0, Len=1, value='P' error. The field
in question has a max len of 1, and is populated with a "P" or "F" value.

I don't understand why the database would indicate the the maximum value
would be '0'. If I ignore the error and then attempt another update, it
successfully saves the record.

I feel like I'm missing something here, or possibly a bug in the SQLCE engine?

Thanks,

BradO
.

Follow-Ups:
- Re: Strange String Truncation Error
  - From: Chris Tacke, eMVP

Prev by Date: Testing
Next by Date: Re: My application does not work from Windows folder!!
Previous by thread: Testing
Next by thread: Re: Strange String Truncation Error
Index(es):
- Date
- Thread

Relevant Pages

SQLCE performance from .NET CF v2.0
... development on primarily Pocket PC 2003 and (now with the emergance of ... As part of evaluating a switch to C# development on the Compact Framework ... local database functionality. ... database technology and I am considering switching to SQLCE at the same time ...
(microsoft.public.dotnet.framework.compactframework)
(SqLite || other database) && CompactFramework?
... I was looking for some database to be used in pocket application ... (Windows Mobile 2003). ... I have tried SqlCe, ...
(microsoft.public.dotnet.framework.compactframework)
Re: SQLCE performance from .NET CF v2.0
... Please remember when bulk inserting is being executed against SQL CE, ... > local database functionality. ... > database technology and I am considering switching to SQLCE at the same ... > execute the prepared statement again. ...
(microsoft.public.dotnet.framework.compactframework)
Re: custom insert for databound datagridview
... gets put into the database until you hit the save button on the navigation ... CTP you can download that handles syncing with a mobile device, ... the desktop piece is SQL Server so you'd still need to write a custom sync ... I am syncing between a PDA SQLCE ...
(microsoft.public.sqlserver.ce)
Re: custom insert for databound datagridview
... soon as syncing supports SQLCE without having to have SQL Server and IIS I ... install SQL Server and IIS just to sync. ... The method I have taken is that I will use RAPI to copy the mobile database ...
(microsoft.public.sqlserver.ce)