Field length problem 2!

2001-06-13 Thread Simon Abolnar
Hello! I would like to specify my problem once again! I have a field type: VARCHAR(100) NOT NULL When I add new record in database everything works OK! When I want to modify data in a field using ADO with: RS.Fields(0).Value="Value" function everything works OK again when I use the same or les

Re: Field length problem!

2001-06-11 Thread MikeBlezien
On Mon, 11 Jun 2001 17:15:09 +0200, "Simon Abolnar" <[EMAIL PROTECTED]> wrote: What kind of data type is the column in questions?? VAR, CHAR,...etc.?? >>Hello! >> >>When I add record in database everything works OK. When I modify data in database >using >>RS.Update >>function everything work

Re: Field length problem!

2001-06-11 Thread Hasan Niyaz
hi, what did you assign the col type and what is the length... - Original Message - From: "Simon Abolnar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 8:15 PM Subject: Field length problem! Hello! When I add record in database every

Field length problem!

2001-06-11 Thread Simon Abolnar
Hello! When I add record in database everything works OK. When I modify data in database using RS.Update function everything works OK again when I use the same or less length field that it was before. (lets say "123" to "456" or "45" o "4") The problem is when I use greater field length (my sql