Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. somarina

    how do you show data from table in a block

    Enter_Query is procedure and form go to enter-query mode. If you want set a query you must set block property DEFAULT_WHERE DECLARE sWhere VARCHAR2(1000); sOrder VARCHAR2(1000); BEGIN sWhere := 'ID_TAB = 1234'; sOrder := 'ID_TAB'; set_block_property(id_block,DEFAULT_WHERE,sWhere)...
  2. somarina

    OLE MailMerge

    Hi, I have problem with passing parameters to method OpenDataSource. I need set connection string and SqlStatement. OpenDataSource(Name, Format, ConfirmConversions, ReadOnly, LinkToSource, AddToRecentFiles, PasswordDocument, PasswordTemplate, Revert, WritePasswordDocument...
  3. somarina

    Using OLE2 + Word 97

    Hi, I have rewriten exampl of creating WordTable. Code is from testing package. It works fine. And what about mail merge ? I tried it but it works only with data in text file. I cant`t set connection string and SqlStatement through method OpenDataSource. Have you used MailMerge object ...
  4. somarina

    how do you show data from table in a block

    in when-new-form-instance trigger --Enter_query; Execute_query;
  5. somarina

    insert records

    Try FORMS_DDL(statement) if you want make insert yourself or Commit_form if you want commit changes on form.
  6. somarina

    OLE add_arg

    Hi, I have problem with passing parameters to method OpenDataSource. I need set connection string and SqlStatement. OpenDataSource(Name, Format, ConfirmConversions, ReadOnly, LinkToSource, AddToRecentFiles, PasswordDocument, PasswordTemplate, Revert, WritePasswordDocument...

Part and Inventory Search

Back
Top