Search results

  1. A

    Question Abl: Send Email With Query Results Concatenated In Body

    I had the following query working with the "first" result showing up. The issue is there can be multiple rows returned. I was trying to concatenate each row (just 1 field) into a comma separated character variable and put it in the email body. The code complies but I never get an email. This...
  2. A

    Question Sql Join _file And _field Search For Fieldname

    I'm using Epicor 9 with OpenEdge 10.1B drivers and SQuirrel SQL. I was attempting to locate what table contains a field called FailedBin. I wrote the following query but its seems to have some issues. SELECT F."_Field-Name" AS "FieldName", T."_File-Name" AS "TableName" FROM...
  3. A

    Error Report Builder Error: Promsgs Msgopen

    Background I have 2 terminals servers that have the same GPO polices enforced on them. One is a 2003 server 32 Bit and the other is a 2008 server 32 bit. There are running Vantage 6.1 with Progress 9.1D. The 2003 server is an all-in-one test server that has the application, and database on...
  4. A

    Question Progress 9.1d Nested Query & Field Names

    I am running Vantage 6.1 with a Progress 9.1D back end. Vantage uses something called Business Activity Query as a front end GUI for writing database queries. 1) If I do a calculated field, the field name displays as Field1. The "AS" command does not seem to rename the field. I also tried...
  5. A

    Error [MM - No data block] (7631)

    We are running Vantage 6.1 with a Progress 9.1D back end. The database is kept on a Windows 2000 SP 4 server. I query the database on my Windows 7 64 Bit machine using DataDirect Connect for ODBC 5.1. This works great and has for a while. I recently encountered an issue with some of my BIG...
  6. A

    MERANT 3.60 32Bit Progress SQL92 v9.1D on 64Bit Winows 7

    I'm using the MERANT 3.60 32Bit Progress SQL92 v9.1D system DSN to make a connection to progress for my VB.NET 2010 application. Before I run the app on a new client I add the following reg entry to create the ODBC connection. Windows Registry Editor Version 5.00...
  7. A

    VB.NET 2010 & ODBC SQL92 LEN() Function

    I have successfully queried Progress from VB.NET 2010 express using a system DSN (MERANT 3.60 32 BIT Progress SQL92 V9.1D) connection. I also have a linked database in Access 2007 in which I can run similar queries as well. There is on function LEN() which I can run in access to Progress with...
Top