Dick,
one last thought: as you come from DBF world, could it be, that addresses.remark is NOT null, but "" ?
Search found 930 matches
- Tue Jul 16, 2024 1:02 pm
- Forum: Product
- Topic: Is it possible to merge info from 1 database into another using SQL
- Replies: 11
- Views: 436
- Tue Jul 16, 2024 8:03 am
- Forum: Product
- Topic: Is it possible to merge info from 1 database into another using SQL
- Replies: 11
- Views: 436
Re: Is it possible to merge info from 1 database into another using SQL
DIck,
looks like this is something in ADS - just tried it with PG and it works flawless.
looks like this is something in ADS - just tried it with PG and it works flawless.
- Mon Jul 15, 2024 2:43 pm
- Forum: Product
- Topic: Is it possible to merge info from 1 database into another using SQL
- Replies: 11
- Views: 436
Re: Is it possible to merge info from 1 database into another using SQL
Dick,
i think:
should do the trick.
i think:
Code: Select all
MERGE INTO addresses USING export ON export.clientkey = addresses.clientkey WHEN matched AND addresses.remark IS NULL THEN UPDATE SET remark = export.remark
- Fri Jul 12, 2024 5:33 pm
- Forum: Product
- Topic: Is it possible to merge info from 1 database into another using SQL
- Replies: 11
- Views: 436
Re: Is it possible to merge info from 1 database into another using SQL
In PG, this would be, i think:
Code: Select all
MERGE INTO addresses USING export ON export.clientkey = addresses.clientkey
WHEN matched THEN UPDATE SET remark = export.remark
- Fri Jul 12, 2024 5:14 pm
- Forum: Product
- Topic: Is it possible to merge info from 1 database into another using SQL
- Replies: 11
- Views: 436
Re: Is it possible to merge info from 1 database into another using SQL
What should happen, if there's already content in the target field?
- Wed Jul 10, 2024 5:18 pm
- Forum: Chit-Chat
- Topic: Datamodelling beyond 1:N ...
- Replies: 3
- Views: 311
Datamodelling beyond 1:N ...
Not sure, if the following is approriate here, but i tend to think clearer, when i have to write down a problem, so bear with me ;-) I'm building an app to manage musical events, strictly inhouse use and for our times, "miniature" table sizes and almost no need for super performance . The ...
- Wed Jul 10, 2024 12:02 pm
- Forum: Product
- Topic: SLE Background?
- Replies: 16
- Views: 632
Re: SLE Background?
Guys, this is an interesting discussion and probably way more relevant for other folks, as my initial "background" question - so, i'd suggest moving the posts to another thread? On the OT side: i just checked and found, that my main machine now has more than 11 years under its belt - i wou...
- Tue Jul 09, 2024 2:26 pm
- Forum: Product
- Topic: SLE Background?
- Replies: 16
- Views: 632
Re: SLE Background?
Chris, Arne, thx for explaining. Indeed it works backwards, too, ie, a background set by the designer dissappears, when the property is set to Null. Another pit i stumbled into was this: SELF:oBG :=Brush{Colorred} which produced neither warning nor error. After some thinking, i now understand: a def...
- Mon Jul 08, 2024 4:35 pm
- Forum: Product
- Topic: SLE Background?
- Replies: 16
- Views: 632
SLE Background?
Strangely, i never used the background property of SLE... - now i want to change it and fail at securing the "old" Background prior to any action. On a Vo-style datawindow, in my sle class' constructor, i added a SELF:oOldBrush:= SELF:Background Debugging, i get SELF:Background is NULL - w...
- Mon Jun 03, 2024 3:44 pm
- Forum: Deutsches Forum
- Topic: Verwenden polnischer Zeichen in einer Dbf-Datei mit DBServer
- Replies: 20
- Views: 1030