Search results

  1. A

    DUMP SQL-View with DataAdmin

    Hello, after spending a lot of time for googling I found a way to export the SQL-Views - but without the data-admin. There is a SQLSCHEMA-Utility to export the View-Definition. But there is no tool to import the view-definition. The way I do this now is to translate all the Tab and CR and to...
  2. A

    DUMP SQL-View with DataAdmin

    Hello, I have a 10.1 Openedge Database - with some SQL-Views. The Views are valid - and I can connect from SQL-Server via openquery. My problem is, that I can not DUMP & LOAD the VIEW-Definition within the DataAdmin. With Dump Data and Definitions -> SQL Views I only get the message, that...
  3. A

    Linked Server

    Hello, I had (YESS PAST :biggrin:) the same problem - with OpenEdge 101b SP3 Fix17, and the SQL-Server ManagementStudio - for a linked server. I read several threads in the internet - without any hint or solution - but my luck was, that I made a link to an openedge-database - about 2 years...
  4. A

    Different format of a column for each browse row

    Hi RealHeavyDude, thanks for your reply. I already abuse the character-field as a SQL-variant - but I can not modify the display format different for each row of a browse widget. I want that the user can input all the production-data within one browser - not horizontal but verical. Each line is...
  5. A

    Different format of a column for each browse row

    Hello, I need to know, if there is any possibility to have a different format for each row of the same column within ONE browse-widget. I need a browser, where the user have to key in different type of data for each row - f.i. one row an integer, the next row a decimal and the next row a...
  6. A

    DELETE Trigger - as database-procedore or within procedur

    Hello progress-talker, I developed several application within adm 1 - and there I used the database-triggers. The usual delete-triggers for keeping consitency produces a message "...can not be deleted - because records available...". So within adm2 there is an other structure - making the...
  7. A

    foreignkey in smartdataviewer

    Hello, I have to update a record with the actual "Username" - within the smart-viewer (not the sdo). I do this within the updateRecord-procedure - but the only way to to this is to put the username field into the viewer and make it "hidden". Within updateRecord I assign the necessary...
  8. A

    different Versions Client/Server (642)

    Hello, I know, that it is not supported, connecting from a progress 9.1d environment to a 10.1b database - But are there any possibilities (maybe some parameters), to get these different versions connected. I have to load some data from one DB into the other - and i don´t want use triggers or...
  9. A

    UNION within a SmartDataObject

    Hello, where can I find the "multiple data Source" feature within the browser. I tried to find some information in the pdf-manual but without success. Is it necessary to make a "manual" browser-object, or is the multiple feature a standard-object? Thank You andi
  10. A

    UNION within a SmartDataObject

    Hello, Is there a possibility to make a "UNION" - equivalent within a progress SmartDataSource. I have two different tables with user-information. And for an application I need a browser which shows both table-informations within this one browser. So I searched for UNION within the forum - but I...
  11. A

    Hello

    Hello everyone, are there any persons from austria or german within this board? Greetings andi
Top