Here is the code when i create the table. The fields are filled with values from a text file.

Maybe there is something wrong when I create the table ?

CREATE...

Jeff:

How does this so called "anchor" field works ?

Here are a helpful link about statements in SQL Anywhere Studio 9.0.2

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/index.html

Regards

Magnus

Hi, i tried this one but i got some syntax errors again. It´s complaining about the "=" in row 4. Maybe beacuse this is written in Sybase (interactive sql) instead...

I get back to you all in a couple of hours with an repply, have some work to do now 🙂 .....

Thx

Thx a lot Mr or Mrs. 500!

It worked like a charm 😀

Many thx

// Regards

Lowell: Thx a lot! It worked perfekt! 😀

Regards

Magnus

Now i want to update one table depending on values in a other table.

Or there is three tables involved. Tables below.

table1

****

mi_seq

obj_num

mgrp

table2

*****

mi_seq

obj_num

maj_grp_seq

table3

*****

maj_grp_seq

name

I want to update table2.maj_grp_seq with the table3.maj_grp_seq where table1.mgrp...

Lowell or anyone: 🙂 See my attached files, I have put in some screen shots and writing what i´m trying to accomplish.

Regards

Magnus

Lowell:

I´ll get back to later today, thx for the post 🙂

/Magnus

So basically i´m looking for some function that generates numbers into the obj_num column depending of what values you get from the brand column. The must be some way to...

This solves the problem but it´s not quite what I want. The AUTOINCREMENT counts and thats good, but I want to modify the obj_num (AUTOINCREMENT) in table2 when I´m reading...

rbarryyoung:

I not using sql server 2005 for this, i´m using interactive sql in sybase actually.

/Magnus

I actually got this to work. But i´m sure I can optimize or write the code in a different way. I didn´t got the (2) INSERT to work so the...

Tommy:

Yes that´s right, (2) insert statements. But how does it work in my case ?

Well basically i want to split up my

table into my two other tables...