Recent content by AlexTheDroog

  1. A

    Question Abl: Send Email With Query Results Concatenated In Body

    So I finally got it working. It was just one thing after another. I didn't realize the Character was limiting to 8 as well as the fact I could not get the complete concatenation until Ending the block.....in any event this is what ended up working. Thanks for your help. Hopefully this will...
  2. A

    Question Abl: Send Email With Query Results Concatenated In Body

    So I was able to get it to show 2 SerilNumbers with your help. I think there is an issue with the loop. It only returns the 1st 2 SerialNumbers added. I think its exiting the loop after the second iteration or the SN variable is not concatenating and overwriting the data. define query email...
  3. 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...
  4. A

    Question Sql Join _file And _field Search For Fieldname

    Thanks guys! Saved me a lot of time looking for a field the didn't exist!
  5. 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...
  6. 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...
  7. A

    Error [MM - No data block] (7631)

    BTW I finally got it working. Your input and advice was more helpful and knowledgeable then Progress and Epicor combined! Thanks
  8. A

    Error [MM - No data block] (7631)

    I actually was able to get Epicor proxy a call with Progress. They basically said exactly what you did, but were not very confident in their response. I was told to put the change -SQLTempDisk 1500000 in the Progress Explorer...
  9. 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...
  10. A

    Error [MM - No data block] (7631)

    I reached out to the ERP service department and they told me its out of their scope talk to Progress. I emailed Progress and they said go talk to your ERP provider (Epicor). So, in any event is there a little HowTo to preform this -SQLTempDisk size increase? I don't even know where to start...
  11. A

    Error [MM - No data block] (7631)

    PROGRESS Version 9.1D0920 as of Tue Oct 19 20:04:28 EDT 2004 I actually watched the space on the server get consumed when I ran the query. It looks like it took just shy of 500mb when it threw the error. I'm guessing that means that it reached the max size of the swap/temp table which is 500 mb?
  12. A

    Error [MM - No data block] (7631)

    How can I find the version? This is running an ERP system and our corporate office has mandated that if we change anything we have to move to different ERP.....so we haven't changed for years.
  13. 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...
  14. A

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

    I located the 32Bit utility for the ODBC drivers you mentioned but the option to configure MERANT 3.60...does not exist. I looked around online to download it but cant seem to find anything. Can I copy some DLLs from an XP machine to get it to show up in Windows 7?
  15. 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...
Top