"Optik Bacik Scheibbs" <[EMAIL PROTECTED]> wrote:
>
> So this is my first time here...
>
> I am using myODBC 3.51 Server 4.0.14
>
> So I created a table with one columm called "GebDat" - format Date
>
> I connect to this DB using VB6 (SP5) with ADO.
> OK - So when I add a new data it works fine
Hi,
What is the table definition? Have you got a primary index?
I work with date fields without problems in this way:
Update table set Date_Field = '2003-08-01' Where Date_Field = '2003-01-19'
Lourdes.
Optik Bacik Scheibbs escribió:
Hey!
So this is my first time here...
I am using myODBC 3.
Hey!
So this is my first time here...
I am using myODBC 3.51 Server 4.0.14
So I created a table with one columm called "GebDat" - format Date
I connect to this DB using VB6 (SP5) with ADO.
OK - So when I add a new data it works fine. But when I will update any one data I
always get an error!
UPDATE your_table SET your_col = CONCAT(your_col, "fff");
nut sss wrote:
ns: can i do this?
ns:content in field="aaa,bbb,ccc,hhh"
ns:new content="aaa,bbb,ccc,hhh,fff"
ns:can i append new word "fff" into the old field .by
ns: use update command in 1 quer
On Thu, 29 Nov 2001, nut sss wrote:
> can i do this?
>content in field="aaa,bbb,ccc,hhh"
>new content="aaa,bbb,ccc,hhh,fff"
>can i append new word "fff" into the old field .by
> use update command in 1 query :)
> it's like
> "UPDATE persondata SET age=age+1"
> but i want to appe
can i do this?
content in field="aaa,bbb,ccc,hhh"
new content="aaa,bbb,ccc,hhh,fff"
can i append new word "fff" into the old field .by
use update command in 1 query :)
it's like
"UPDATE persondata SET age=age+1"
but i want to append new value into old field...
what should i do