I am beginner with Docker Containers and looking for an Image for have a containerized instance of SQL Anyhwhere 17.I found one in Docker Hub and tried it, it is running, but it has the version 16, where can I find the 17 version, and is it possible ...
I have such a table with bidirectional synchronisation (using shadow tables) (MLSRV17.exe & DBMLSYNC.exe)
create or replace table mytable(
col1 varchar(10),
col2 int,
primary key ("col1")
);
I have problem when executing such a statement on Cons.:
u...
Is it possible to sort a distinct statement based on another column (rather than the distinced one)?
For Example I have this table:
create or replace table mycities (cityid int, cityname varchar(40));
insert into mycities values
(4, 'Vienna'),
(2, 'C...
Is it possible to make a subquery and keep the same order without the need to explitly ordering it outside the subquery?
For Example, I have this block and want to have an alphabetical ordered products:
create or replace table mytable (idnr int, prod...
I can't solve this "simple" problem, can maybe someone help?
What I have is:
create or replace table mytable (whichamount int, whichdate date)
insert into mytable values
(100, '2024-01-01'),
(200, '2024-01-01'),
(300, '2024-02-01'),
(400, '2024-03-01...
I can't do this:
1- On the Cons. it is the user who executes the update statement, and the database allows him to do so, I can only avoid this from happening via a trigger.
2- On the Remote it is the dbmlsync.exe who executes the update statement, so...
It is really sad to know that this place will not be available anymore, even if the contents will be available somewhere else.
I was used during the last 7 years always to write my problems here, and with the help of some super helpful people I got a...
BTW, it is not related to Mobilink or dbmlsync.exe!
I tried to execute the update statement in the Remote database (from dbisql), and got the same error message:
In other words the protection mechanism of "prevent_article_pkey_update" is case sensit...
The database itself is case insensitive.
resetting the option "prevent_article_pkey_update" was the only way for me to find the error (in my test setup), I cant risk and reset it in the prod.
Given the facts in your answer I can imagine that the only...
Using city/country names is always dangerous and it leads to another discussions
I dont know why I used City names in my example, but I liked the first solution of Volker because it is simple and applies to my case.
