Recent content by Vents Lauva

  1. V

    Another question about Floats

    1. Can i assume that MyQuery['MYFIELD'].AsFloat =d allways returns true ? Only if MyQuery return 1 row or you update 1st record of result set; 2. Can i use a number(14) as key field for a table ? Of course, YES, if value for field is unique for each record
  2. V

    Checking for privileges

    Try select privilege from user_tab_privs where owner = :table_schnema and table_name = :table_name if logged_in_user is schema owner, then table have all privileges Best regards
  3. V

    Passing an expression list to a bind variable

    Try DeclareVariable('cty',otSubst); ------------------
  4. V

    How select fields from 2 tables with the identicel name

    if You try to select like example table1 nr number status varchar2(1) after query select * from table1 a, table1 b where a.nr = b.nr You get cursor with fields nr,status,nr_1,status_1 because each column must be unique identified by name and there is more then 1 column with this name...
  5. V

    DOA 3.4 beta problem

    I had the same problem
  6. V

    Dates: 0 vs. NULL

    I think, You have 3 solutions with "smallest" date in column. 1st - declare column as DATECOLUMN date default to_date('18991230','YYYYMMDD') 2nd - define variable in delphi like ZeroDate := StrToDateTime('31.12.1899') (one day greatest then 0) and use this Zerovalue to assign date to date...
  7. V

    FULL OUTER JOIN

    This can be done with union (example from scott schema) select a.*,b.* from emp a, dept b where a.deptno(+) = b.deptno union select a.*,b.* from emp a, dept b where a.deptno = b.deptno(+); Vents Lauva Member
See more
Back
Top