Recent content by Anatoliy

  1. A

    Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run

    Wau. Thank you. Is it possible to pin more than 1 result?
  2. A

    Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run

    Yes, I see your point. I saw at the right side. But in many cases it useful to see result of query to write new one. And when there is one file with many queries -and pl\sql blocks to investigate some issue - to see on the right side - it's good idea - but than maybe it's possible to somehow...
  3. A

    Run previous sql or pl\sql block in sql file with many sqls instead sql which I would like to run

    Hello Team. 1. Sometimes in sql file with many SQLs, pl\sql blocks - when I try run particular query (even if it selected) - previous query is run. (queries separated by ";" or "/" (even for sqls) 2. Is it possible to add option to run sql always in read-only mode for the grid (result dataset)...
  4. A

    I need to use a file with specification or body without slash at the end.

    In PL/SQL Developer 11.0 this option is absent
  5. A

    I need to use a file with specification or body without slash at the end.

    PL\SQL Developer 11 When I save only package specification or body in program window - "/" is automatically added at the end. Can I somehow eliminate it? I need to use a file with specification or body without slash at the end. Could you please help us with this? Thank you!
  6. A

    Edit view in data grid with instead of trigger

    Edit view in data grid with instead of trigger Hello! Can I Edit view in data grid with instead of trigger. I want run query in editor Example: select * from v_view for update; and edit result in data grid. View v_view has "instead of" trigger on insert or update or delete Thanks
  7. A

    v 4.1.1 Issue on delphi 2009 (record changes by another user)

    I use Database and Client Oracle 11.1.0.7.0 + Patch8 on Windows
  8. A

    v 4.1.1 Issue on delphi 2009 (record changes by another user)

    OracleData CompareFieldToVariant I think this block have error in Equal := (Length(s) = l) and CompareMem(p, @s[1], l); In Delphi 2007 if CompareOld then vd := AField.OldValue else vd := AField.Value; VarType(AField.OldValue) = 256 In Delphi 2009 if CompareOld then vd := AField.OldValue...
  9. A

    v 4.1.1 Delphi 2009 Date parameter as String

    I use parameter ForceWideStringFields in TOracleSession I get error, when I use Date parameter as String in TOracleDataSet In OracleTypes TVariableData.SetValue in block add or (VarType(AValue) and VarTypeMask = VarUString) to if (VarType(AValue) and VarTypeMask = VarString) then otDate...
  10. A

    v 4.1.1 Issue on delphi 2009 (record changes by another user)

    What I do in this situation?
  11. A

    OutOfMemory, when I use TOracleDataSet with query which have 20 field NVARCHAR2(2000) and 3000 rec

    if I set this property (UniDirection) or use TOracleQuery I won't use TDBGrid :(((
  12. A

    OutOfMemory, when I use TOracleDataSet with query which have 20 field NVARCHAR2(2000) and 3000 rec

    OutOfMemory, when I use TOracleDataSet with query which have 20 field NVARCHAR2(2000) and 3000 records. BufferSize set on 100. What shall I do? DOA 4.1.1 Oracle 10gR2 (Unicode CodePage) Patch 4 Delphi(2007,2009)
  13. A

    Connect one module(Delphi 2009) to databases with different codepage - unicode and win1251

    I want to use one module (Delphi 2009 DOA 4.1.1), which has TOracleSession and TOracleDataSet where FieldEditor filled with TStringField for varchar2 table
See more
Back
Top