Please help me with the following problem:

update Probe set runde = 0;

select runde into Test from probe order by runde;
optimize table Test;
alter table Test last autoinc  0;
alter table Test add myautoinc autoinc;


update probe set runde = myautoinc from Test;

I get the error:  #11949 SQL parsing errror - Missing UPDATE table name in UPDATE SQL statement at kine 9, column 41

What do I wrong?

TIA
Dieter Nagy

"Dieter Nagy" <dieter.nagy@tele2.at> wrote in message
news:06A3D35D-14F3-482C-AA66-856437D3A7AA@news.elevatesoft.com...
>
>
> update probe set runde = myautoinc from Test;
>
> I get the error:  #11949 SQL parsing errror - Missing UPDATE table name in
> UPDATE SQL statement at kine 9, column 41
>
> What do I wrong?
>

update probe set runde = myautoinc from probe
join test on ... whatever they have in common

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote:


"Dieter Nagy" <dieter.nagy@tele2.at> wrote in message
news:06A3D35D-14F3-482C-AA66-856437D3A7AA@news.elevatesoft.com...
>
>
> update probe set runde = myautoinc from Test;
>
> I get the error:  #11949 SQL parsing errror - Missing UPDATE table name in
> UPDATE SQL statement at kine 9, column 41
>
> What do I wrong?
>

update probe set runde = myautoinc from probe
join test on ... whatever they have in common


Robert are you sure that myautoinc from probe is correct, or shold I use Test. Anyway it dont work.....

TIA
Dieter

"Dieter Nagy" <dieter.nagy@tele2.at> wrote in message
news:73AC6704-8915-4199-AD21-ADFABFC839D1@news.elevatesoft.com...
>
>
> Robert are you sure that myautoinc from probe is correct, or shold I use
> Test.

It is correct. See the manual.


> Anyway it dont work.....

And this means what? What are the symptoms of the query not working?

Robert

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote:


"Dieter Nagy" <dieter.nagy@tele2.at> wrote in message
news:73AC6704-8915-4199-AD21-ADFABFC839D1@news.elevatesoft.com...
>
>
> Robert are you sure that myautoinc from probe is correct, or shold I use
> Test.

It is correct. See the manual.


> Anyway it dont work.....

And this means what? What are the symptoms of the query not working?

Robert

Robert, I get the same error as above.
Thanks for your help.

Dieter

Dieter,

<< Robert, I get the same error as above. >>

Robert's code is correct.  Could you post the complete UPDATE statement that
you're using now with the changes that Robert indicated ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Dieter,

<< Robert, I get the same error as above. >>

Robert's code is correct.  Could you post the complete UPDATE statement that
you're using now with the changes that Robert indicated ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello,

update probe set runde = myautoinc from probe
join test on probe.runde = test.myautoinc;

TIA
Dieter

Dieter,

That looks fine.   This is DBISAM V4, correct ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Dieter,

That looks fine.   This is DBISAM V4, correct ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim, yes DBISAM V4.

Dieter

Dieter,

<< Hello Tim, yes DBISAM V4. >>

Could you send me the tables that you're using along with the SQL ?  I'm
obviously missing something here, because it looks fine to me.

--
Tim Young
Elevate Software
www.elevatesoft.com