Getting error while executing select Query with firebird isql.
returning a null value only

thanks in Advance

Ajeesh

We need a bit more information to help you. What kind of error? What is the exact syntax of your SELECT statement? What is the DDL for all of the tables involved in your query?

-PatP

I m using firebird 1.5 with IBConsole as Client Tool.

when i m executing the select sql for one table ,its generating an error--

'Invalid request BLR at offset 3
function LEFTS is not defined
module name or entrypoint could not be found
Statement: select * from batchmaster

'

and when i tried with IBConsole

i m getting a null value with in the data tab



and i used the simple sql -select * from batchmaster;




and the structure of the table-->


CREATE TABLE "BATCHMASTER"
(
"PRODUCTCODE" CHAR(8) NOT NULL,
"BATCHCODE" CHAR(15) NOT NULL,
"EXPIRYDATE" CHAR(7),
"BATCHSTOPBILLING" CHAR(1) DEFAULT 'N',
"UNIT" NUMERIC(9, 1) DEFAULT 0.0,
"PACKING" NUMERIC(9, 1) DEFAULT 0.0,
"BATCHQUANTITY" NUMERIC(9, 1) DEFAULT 0.0,
"BATCHPURCHASERATE" NUMERIC(9, 2) DEFAULT 0.00,
"BATCHMRP" NUMERIC(9, 2) DEFAULT 0.00,
"BATCHTPS" NUMERIC(6, 2) DEFAULT 0.00,
"BATCHSALETAX" NUMERIC(6, 2) DEFAULT 0.00,
"BATCHADDITIONALCST" NUMERIC(9, 2) DEFAULT 0.00,
"BATCHSELLINGRATE" NUMERIC(9, 2) DEFAULT 0.00,
"BATCHTRANSFERQTY" NUMERIC(9, 1) DEFAULT 0.0,
"BATCHTRANSFERDATE" DATE,
"USERID" CHAR(6) NOT NULL,
"MACHINEID" CHAR(8) NOT NULL,
"BATCHEXPIRY" COMPUTED BY (LEFTS(EXPIRYDATE,4)||RIGHTS(EXPIRYDATE,2)),
"BATCHADDITIONALTPS" NUMERIC(6, 2) DEFAULT 0.00,
"OLDITEMCODE" CHAR(7),
"BILLEDAFTERRETURN" CHAR(1) DEFAULT 'N',
"OLDMACHINE" CHAR(4),
"BATCHPURDISCOUNT" NUMERIC(15, 2) DEFAULT 0.00,
"BATCHEXCISEDUTY" NUMERIC(15, 2) DEFAULT 0.00,
"TAXCODE" CHAR(2),
CONSTRAINT "DBPKBATCHMASTER" PRIMARY KEY ("BATCHCODE", "PRODUCTCODE")
);
ALTER TABLE "BATCHMASTER" ADD CONSTRAINT "DBFKBATCHPRODCODE" FOREIGN KEY ("PRODUCTCODE") REFERENCES PRODUCTMASTER ("PRODUCTCODE");
ALTER TABLE "BATCHMASTER" ADD CONSTRAINT "DBFKBATCHTAXCODE" FOREIGN KEY ("TAXCODE") REFERENCES TAXMASTER ("TAXCODE");
SET TERM ^ ;







the dlls involved are FreeUDFLib.dll and ib_udf




Regards

Ajeesh

Sorry - my mistake