Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Update statement using two joined tables

Sat, Oct 22 2011 5:35 AM	Permanent Link
Jan Groenen MB-Lingerie	Hi, I am using the following update statement which is failing with the error " expected ) but instead found JVID_FOUT_DET" update jvdet set jvdet.glamount = (select jvid_fout_det.verschil from jvid_fout_det where jvdet.jvid = jvid_fout_det.jvid and jvdet.seq = jvid_fout_det.seq) Hope somebody can help me!
Sat, Oct 22 2011 8:51 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Jan DBISAM doesn't support sun-selects. You need to use the JOIN syntax. Check out the manual http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=5&topic=UPDATE_Statement Roy Lambert [Team Elevate]
Sat, Oct 22 2011 3:46 PM	Permanent Link
Malcolm Taylor	Roy Lambert wrote: > Jan > > > DBISAM doesn't support sun-selects. You need to use the JOIN syntax. > Check out the manual > ...but I'm sure that if we were part of a binary star system, Tim would have included that!
Sun, Oct 23 2011 3:56 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Malcolm >> DBISAM doesn't support sun-selects. You need to use the JOIN syntax. >> Check out the manual >> >..but I'm sure that if we were part of a binary star system, Tim would >have included that! Isn't it needed for galactic empire purposes? Roy Lambert
Sun, Oct 23 2011 1:43 PM	Permanent Link
Malcolm Taylor	Roy Lambert wrote: > > Isn't it needed for galactic empire purposes? > Definitely. Never having met Tim I can only go by his posts, but I have not detected any Galactic ambitions. Global is quite another thing!