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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.