Thanks AndrĂ¡s. I see it now, the constraint is on the field that mirrors the
non zero values and has NULL instead of zeros, yet I can still use my present
field the way it always works in the software, that's great
Kind regards
Bhavbhuti
Hi all
I have a transaction table that has an integer FK field. This FK field can be
either a 0 (no master record selected) or an integer that is a FK value from
the master PKs. If I put in a FK Constraint then it will not allow me a 0 in
the transaction table's FK field. I know NULL is
Thanks a lot Set. Yes, I guess I was not able to explain my requirements
clearly.
I think because the underlying is a view, vwPriceListHistory, the query you
suggested is taking very long to run. I will try your suggestion where there
is a table rather than derived data
Kind regards
Thanks Mark. I went back to the cID as you suggested. I added a 0 padded
iItemID before the date and also padded the rest of the cID with 0 just like
you wanted (though expanded) and your query works lightening fast. I will be
able to make practical use of it I am sure.
Thanks again for
Hi Mark
I have updated the original post with the new cID column values
I have a view and the following query which returns multiple records from the
view (see below) for each iItemID
SELECT iItemID
, cID
, bRate
FROM vwPriceListHistory
ORDER by iItemID, cID DESC
What
Hi all
I have a view and the following query which returns multiple records from the
view (see below) for each iItemID
SELECT iItemID
, cID
, dDt
, bRate
FROM vwPriceListHistory
ORDER by iItemID, dDt DESC, cID DESC
What I want is one first record of each
I have confirmed that the part
, COALESCE((SELECT SUM(PurchaseBillItemInner.bQty)
If I remove the SUM() I get an error that there are multiple records returned
in a singleton select. There is an iID field on each row of each table (I have
tried to use it to no avail) that can distinguish both
Hi all
Sorry for resurrecting this very old thread but I have come across a situation
(hopefully Jose would be able to answer). I have found a bug in the bQty
column it was not able to reduce itself to the current stock, eg. 3, and still
it returns two row with a qty of 3+2 = 5 qty is valued
Dear all
Happy New Year!
Maybe there is already something out there but my requirements was that I need
Age as a string 4y 5m 8d. Maybe for calculation purposes I would want the
components separately as integers. Most of the functions I found was giving me
the difference in years, months,
Hi all
My application allows users to create a database and it's entry in aliases.conf
is created by the application. This essentially is fine and works well in
Admin mode, as soon as the same is tried to be done using the normal non-admin
mode I am not able to update aliases.conf
Question
Hi all
I was wondering if there was a way to get a portion of a string based on a
separator character. What I needed to do was want to bring out a part of the
version number.
1.23.456.789
I want to get just the third portion, 456. So I could query on strings that
have a version number with
Hi all
Learning from one of the replies from Set on my other thread I tried to replace
my SP with an improved one. One that would return two results (date range) in
one row instead of two calls to the older SP.
I can't use CTEs in the Remote Views where the final query is used, so that is
Actually an index on tSupport.tDt I think made both the queries slower
Hi all
I have a SELECT statement which needs to have a WHERE clause adapt if a
variable has a value or not:
WHERE CASE WHEN 72 0 THEN tDevelopment.iID = 72
ELSE (CAST(tDevelopment.tDT AS DATE) BETWEEN (SELECT US1.dValue
FROM dSetValue('Current Year', 'From') US1)
AND
Dear all
Please see the attached screen shot of the query and the output. I am almost
there but I have run out of ideas on what I can do to post process further.
My final output I want something like this:
1Haemogram Report 1Routine
Haemogram
The screen shot was stripped please bear with me I will paste the original
query and the original output now:
WITH cteTestGroups AS (SELECT MIN(A.iSrNo) AS iGroupSrNo
, B.cTitle
, MIN(C.iSrNo) AS iSubGroupSrNo
, C.cSubGroup
FROM sReqSlipTestGroup A
Hi all
I tried to search this possibility but I think not. I have multiple apps
getting to the data in FireBird, I wanted to use GTT but as data cannot be seen
between transactions or connections, I have not been able to use them because
my software would create the temporary data in it's own
Hi all
I would have attached a screen shot of the sample data but I guess that is not
possible. What I am trying to achieve right now is get the time difference in
hh:mm format to the user
tStartTime and tEndTime field values
26.08.2014, 08:38:00.00026.08.2014, 09:45:00.000
Hi all
I found that on my 64 bit i5, 64 bit Win7 that there were both 32 and 64 bit
installations of FireBird. So I uninstalled the 32 bit. Now I cannot load the
database via ODBC, it raises the error:
Connectivity error: [ODBC Firebird Driver]Unable to connect to data source:
library
Hi all
My application in 32 bit which stopped getting to the registry of FireBird
HKLM\Software\FireBird Project\FireBird Server\Instances DefaultInstance
which the WinAPI RegOpenKey() fails and returns a value of 2 Path Not Found
Please advise on what I need to keep in mind with the
Sorry forgot to mention FireBird version, it is 2.5.2.26540 on WinXP Prof
53 matches
Mail list logo