Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    3

    Unanswered: FireBird Database

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

    thanks in Advance

    Ajeesh

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    May 2009
    Posts
    3

    Re:Firebird sql err

    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
    Last edited by Ajeeshjos; 05-10-09 at 06:18.

  4. #4
    Join Date
    Jun 2009
    Posts
    3

    Firebird - error with setting up the environment

    Sorry - my mistake
    Last edited by dbStrob; 06-26-09 at 18:06.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •