You may consider
WITH TMP(My72, cFrom, cTo, dValueFrom, dValueTo) as
(SELECT CAST(:My72 as integer), US1.dValue, US2. dValue FROM RDB$DATABASE
LEFT JOIN dSetValue('Current Year', 'From') US1 ON (1=1)
LEFT JOIN dSetValue('Current Year', 'To') US2 ON (1=1))
SELECT whatever
FROM TMP t
CROSS JOIN
Hi,Greetings For The Day.
I am using vb.net which has a grid of 100,000 records and 30 columns have to
insert in a firebird table. The insertion will take place if product id does
not exist else record to be update.But inside the loop while executing
ExecuteNonQuery control does not come back
Bhavbhuti,
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)
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
Hi,Greetings For The Day.
I am using vb.net which has a grid of 100,000 records and 30 columns have to
insert in a firebird table. The insertion will take place if product id does
not exist else record to be update.But inside the loop while executing
ExecuteNonQuery control does not come back