Very Computer

Hello

I'm having problem with inserting a shape into a child......... here's
the error I get:

MSDataShape error '80040e14'

The data shape command contains a syntax error at or near position 196
in the command. The command text near the error is: " relate picid to
pid)".

And here's the stmt:

shape{select id,katid,pid from prod_kat where katid=1}
append((shape{select id,pid,picid from wwwsehcc_bilder}
append({select id,filename from bildbank} as fil relate picid to pid)

it doesn't matter how many ) I put at the end, still the same err......

/Lasse

It looks like the clauses are not grouped properly, try moving the alias
name.  Try this.
 shape{select id,katid,pid from prod_kat where katid=1} as fil append
( shape{select id,pid,picid from wwwsehcc_bilder} append
( {select id,filename from bildbank} )
relate picid to pid )

Not sure if that helps or not.  I think this is a question for a different
newsgroup - ADO

Quote:> Hello

> I'm having problem with inserting a shape into a child......... here's
> the error I get:

> MSDataShape error '80040e14'

> The data shape command contains a syntax error at or near position 196
> in the command. The command text near the error is: " relate picid to
> pid)".

> And here's the stmt:

> shape{select id,katid,pid from prod_kat where katid=1}
> append((shape{select id,pid,picid from wwwsehcc_bilder}
> append({select id,filename from bildbank} as fil relate picid to pid)

> it doesn't matter how many ) I put at the end, still the same err......

> /Lasse