🚀 go-pugleaf

Um, Did you forget that you must allow an extra space for the end of string
character?
if you need 5 characters for the data you must have a size of 6 for a null
terminated
string or 7 ( I think ) for a "/r" terminated string.

"Builder" <JohnnyHor@hotmail.com> wrote in message news:3c40e850_1@dnews...
> Hello all.
>
>   I'm trying to insert values into an Access 2002 table. Lets assume that
I
> have only one field in the table and call it date
> (represents date in the format mm/yy). My problem is that when I try to
set
> the field's value to a 5 chars value it doesn't do it. If i try to set it
to
> a 4 or less char value everything is ok. What's the problem?
> The field is declared as follows ( In access):
> Field Size:                5
> Required :                No
> Allow Zero Length:  Yes
> Index:                      No
> Unicode compr       Yes
> The rest are blank
>
> Here's my code ( Importing ActiveX Data Objects v2.5 in BCB 4):
>
>     TCOM_Recordset rs = CoRecordset::Create();
>     rs->Open("mytable","DSNName",adOpenDynamic,
>      adLockOptimistic,adCmdTable);
>     rs->AddNew();
>     // This field will stay blank
>     rs->Fields_->get_Item("Date")->set_Value("01/01");
>    // This field will contain 01/0
>    rs->Fields_->get_Item("Date")->set_Value("01/0");
>    rs->Update();
>    delete rs;
>
> What may be the problem?
> Thank you
>    Builder
>
>
>
>