Search found 930 matches

by FFF
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

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

Dick,
one last thought: as you come from DBF world, could it be, that addresses.remark is NOT null, but "" ?
by FFF
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.
by FFF
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:

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
should do the trick.
by FFF
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
by FFF
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?
by FFF
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 ...
by FFF
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...
by FFF
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...
by FFF
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...
by FFF
Mon Jun 03, 2024 3:44 pm
Forum: Deutsches Forum
Topic: Verwenden polnischer Zeichen in einer Dbf-Datei mit DBServer
Replies: 20
Views: 1030

Re: Verwenden polnischer Zeichen in einer Dbf-Datei mit DBServer

robert wrote: Mon Jun 03, 2024 8:48 am Karl,
If you own that product, maybe you can create a Unicode DBF and send that to me for inspection?
I do, and here is a simple sample with 5 records, using the values you posted earlier for Peter.
DBF_UTF.7z
(472 Bytes) Downloaded 19 times