Recent content by llz

  1. L

    Oracle.pas Problem

    I find a snap problem in function RemoveSQLComment(const ASQL: string):String; if (c1 = '-') and (c2 = '-') then Mode := '-'; if the '--' is in constant string , It will delete after words include '''' and produce an error :ORA-01756 . I add some codes after "if (c1 = '-') and (c2 = '-') then...
  2. L

    OracleDataset query

    I have an OracleDataSet Query in Delphi: select * from t where field1='asd--sdf'; it is error : ORA-01756 the query is not right end. but when I change: select * from t where field1=:field1; DeclareVariable(Field1,otString); SetVariable(field1,'asd--sdf'); it is right; whether the char '--' is...
  3. L

    How use TOracleQuery.SubstitutedSQL

    when I use TOracleQuery.SubstitutedSQL , I find the retrieve MSG don't be replaced variables. but the parogram used ReplaceSubstVariables(Result); Could anyone can give me any advise?
  4. L

    Using QBE

    I write a query text using TOracleDataSet: select a.uni_no from a,b where a.uni_no=b.uni_no; when I use QBE query Uni_no , it tell me It's ambiguity field name. How should I solve this question?
  5. L

    Open DataBase & DOA

    I set OCIDLL in BDE, but I have to logon OracleSession before open a Database,why? Thanks
  6. L

    Doa & DataBase

    Thanks your help, and I still have a little doubt: I set OCIDLL in BDE, but I have to logon OracleSession before open a Database,why?
  7. L

    Doa & DataBase

    I use DOA & DataBase in the same DataModule of Delphi, it is error when I use query of database after I logon DOA Error Message: Access violation at 0x4d622ee5: read of address 0x388b5708 83 3A 00 74 63 E8 39 10 00 00 64 8B How Should I do? Thanks
Back
Top