Questions tagged [hints]
93 questions
1
vote
1 answer
any way to fix delphi to always show compiler hints?
All of a sudden, my Delphi 10.3 stopped showing compiler hints in some (but not all) procedures of one project (but not others - and may I add that I have far more complex ones). MadDebug stopped working with this error:
[madExcept Warning] Mapping…
miodrag
- 99
- 10
1
vote
1 answer
Oracle select execution plan, how to remove FILTER
I have remote connection to not oracle database.
And I try to execute two sql's .
Column day on remote database is char.
this works ok
select * from tab
where day='2021-11-11'
execution plan
PLAN_TABLE_OUTPUT
Plan hash value: 1788691278
| Id |…
Robert S
- 11
- 2
1
vote
1 answer
SQL join hints affect row count?
I have an SQL view on SQL 2016 SP2 that joins on 14 tables with no predicate.
WHEN dsp.DimSourceSystemID=2 THEN edsp.CyberExposureGroup
WHEN dsp.DimSourceSystemID=4 THEN vdsp.CyberExposureGroup
ELSE…
Roger Allen
- 49
- 3
1
vote
1 answer
Previews in delphi?
I am creating a project in Delphi and was wondering if it was is possible to create a preview of a tab. My idea is for a person to hover over the panel that takes you to the page and then it shows a preview in the hint, like when you hover over an…
Déjan Venter
- 81
- 8
1
vote
0 answers
where to use parallel hint in oracle
I have a technical question about parallel hint.
let's suppose I have complex statement with several WITH clauses or maybe some subquery.
where shoud I place the hint if it is on statement level or table level
with a1 as (
select ....
),
a2 as…
Pato
- 153
- 6
1
vote
1 answer
Bootstrap upgrade to latest version
I'm creating website for the first time with latest (twitter) Bootstrap (v4.5).
I'm wondering what the best way is to update when a newer version is released. Also, is it better to implement Bootstrap by downloading the framework or just implement…
Igor
- 13
- 1
- 6
1
vote
1 answer
CASSANDRA: Unable to open /var/lib/cassandra/hints
I'm trying to setup cassandra 3.11.6.1 (and tried with 3.11.4.1) but failed to make it works. In the yaml configuration I set directories values for commitlog, hints, data and saved_cache to another root dir but in the logs it seems that cassandra…
Matthieu Feron
- 51
- 1
- 4
1
vote
0 answers
Object.prototype hints in VS Code
I use Visual Studio Code to JavaScript programming. And when I create some simple object, I want to see the hints about properties of it's prototype.
let o = {};
I want to use method from it's prototype (Object.prototype), but there are no hints…
Sergei Martianov
- 301
- 1
- 9
1
vote
1 answer
Type Hints not working for strings in function in php 7
Type hints doesn't work in case of strings.
function def_arg(int $name, int $address, string $test){
return $name . $address . $test;
}
echo def_arg(3, 4, 10) ;
// It doesn't throws an error as expected.
On the other hand. if you give string…
Sitepose
- 304
- 1
- 13
1
vote
2 answers
removenode coordinator, and its hints data will be lost
There are four nodes in cluster. assume them are node A, B, C, D. enabled hinted handoff.
1) create a keyspace with RF=2, and create a table.
2) make node B, C down(nodetool stopdaemon),
3) login in node A with cqlsh，set CONSISTENCY ANY, insert into…
haihong sun
- 11
- 2
1
vote
1 answer
How to conveniently force CMAKE to use a particular build of static library file?
I current have an open source 3rd party library A installed in \usr\local. Now I want to experiment some code change on this library but I want to do this test in a local folder so it won't affect the system library. Let us call the local build A'.…
Hairuo Zhuang
- 11
- 3
1
vote
1 answer
SQL Server: using table lock hint in select for ensuring correctness?
I've got a project that is trying to apply DDD (Domain Driven Design). Currently, we've got something like this:
begin tran
try
_manager.CreateNewEmployee(newEmployeeCmd);
tran.Commit();
catch
rollback tran
Internally, the CreateNewEmployee…
Luis Abreu
- 4,008
- 9
- 34
- 63
1
vote
0 answers
How to determine records being removed in another transaction in SQL Server?
I have a table in SQL Server having ID column, which is also set as unique clustered index.
I need to determine which records among given IDs are locked as being removed in another transaction.
If I use READPAST I get only those which are not…
Rauf
- 312
- 3
- 16
1
vote
1 answer
TextInputLayout and EditText hint visible
I am facing a very weird issue after updating my Android Support Libraries, particularly 'com.android.support:design:25.1.0'. Take a look at the following screenshots:
______
Note that the same code is working fine for email, country and phone…
Bugs Happen
- 2,169
- 4
- 33
- 59
1
vote
1 answer
Oracle join using Hint USE_NL USE_HASH
What is the best way to Force execution plan to do only nested loop joins for all tables using Hint USE_NL in once case,
And in other case to do only Hash Join using USE_HASH hint for all tables
I want to run both query and see which has low cost in…
User332772
- 11
- 1
- 1
- 3