Is it possible to merge info from 1 database into another using SQL

This forum is meant for questions and discussions about the X# language and tools
FFF
Posts: 1562
Joined: Fri Sep 25, 2015 4:52 pm
Location: Germany

Re: Is it possible to merge info from 1 database into another using SQL

Post by FFF »

Dick,
one last thought: as you come from DBF world, could it be, that addresses.remark is NOT null, but "" ?
Regards
Karl
(on Win8.1/64, Xide32 2.20, X#2.20.0.3)
ic2
Posts: 1851
Joined: Sun Feb 28, 2016 11:30 pm
Location: Holland

Re: Is it possible to merge info from 1 database into another using SQL

Post by ic2 »

Hello Karl,

Interesting thought, but no, that doesn't change it. The problem is the AND after WHEN matched (ADS shows the position where the statement is wrong) and says there: Expected lexical element not found: THEN)

It seems to indicate that WHEN matched should be followed directly by a THEN, so any extra condition (using AND) fails.

Dick
Post Reply