Alright i sended you the attachment by mail.

Thanks in advance

R. Timmermanws

Ralf

All you need to do is take the brackets out.


INSERT INTO RFCDossier

SELECT 11 AS RfcID, td.DossierID
FROM "TicketDossier" td
WHERE (td.TicketID = 16) AND
      NOT EXISTS
     (
       SELECT * FROM "RfcDossier" rd
       WHERE (rd.RfcID = 11) AND (rd.DossierID = td.DossierID)
     )

Now I've seen the problem I remember it

Roy Lambert [Team Elevate]

Roy

I tested your solution, and it works like a charm.
Thanks a lot for your time and efford.

To think it was something this small and i couldn´t figure it out.

Thanks again, you have been a great help.

R. Timmermans

Ralf


It wasn't until I had the thing in front of me I could figure out the problem. After 2+ years I'm still tripping over some of the differences between DBISAM and ElevateDB. I'm sure that at some point the new syntax will seep into my tired old brain.

Roy Lambert

Ralf,

<< Apparently if i try to upload my attachment in the Binaries the website
crashes. >>

Ahh, so that's what was taking it down yesterday.  Thank you for not
continuing to try it.

Could you please email me that upload so I can can fix the issue with the
web site ?  Also, if you could tell me what browser you're using in the
email, that would be great.

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Whilst you're working on the website. I use Maxthon and the bits that say you'll be redirected never work. I always end up clicking the click here if it doesn't work link.

Roy Lambert

Roy,

<< Whilst you're working on the website. I use Maxthon and the bits that say
you'll be redirected never work. I always end up clicking the click here if
it doesn't work link. >>

The web server uses a standard redirect on the post, and if the web browser
doesn't support it, then there isn't much I can do.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


fair enough - its not a great hardship.

Roy Lambert