Search results for query: *

Maybe convert it to a string before passing it to SQL? That might stop your program from doing conversions it may be doing.

I figured this out. The inner needs a name in order to succeed. SELECT ( SELECT MAX(J) FROM (SELECT MIN(K) AS J FROM @TEMP B GROUP BY I) as whatever) FROM @TEMP A

Can you debug your program and get the exact sql string that the program is running? A simple example like this one below shows how the float column isn't set to null when updated to a 0 value. Perhaps your program is converting the value somewhere? declare @temp table (i float) insert into...

I'm trying to put a select within a select within a select. Here's an example of what I'm trying to do. DECLARE @TEMP TABLE (I INT, K INT) INSERT INTO @TEMP SELECT 1, 2 UNION SELECT 1, 3 UNION SELECT 1, 5 UNION SELECT 2, 1 UNION SELECT 2, 3 UNION SELECT 2, 7 UNION SELECT 3, 3 UNION SELECT 3...

What's the fastest way to do a view lookup in a macro or while using the COMAPI? Right now I have used either the .Browse or .FilterSelect functions followed by a Fetch or a GoTop and sometimes it can take an outlandish amount of time to perform depending on where the record is and whether I'm...

Hi, This query makes sure that it does not include any details that have he same ACCTID as the parent queries ACCTID. So in this case, GLPOST_SQ would be the parent, GLPOST_1 is the child. I added in the acctdesc to the other glpost query so you can see both now. I hope this better suits...

I didn't have too much time to look into this but I do like query problems. Does this query work better to suit your needs? SELECT top 100 GLPOST_1.ACCTID, GLPOST_1.FISCALYR, GLPOST_1.FISCALPERD, GLPOST_1.SRCECURN, GLPOST_1.SRCELEDGER, GLPOST_1.SRCETYPE, GLPOST_1.CNTDETAIL, GLPOST_SQ.JRNLDATE...

Excellent tip czinck. That fully resolved the issue using editbin.exe with /NXCOMPAT:NO It's good to know why it happens so I can prevent similar problems in the future. Thanks

The problem appears to be with Windows 2008 & Windows 7. The code seems to work on Windows XP and Windows 2003. I tried it once before on Windows 2003 and it didn't work. I must have changed the code since then as it works fine now. Thanks for your help on this.

When the program errors in Debug mode and I take a look at my watch list, I can see that the view finder creates a datasource from the session. What puzzles me is that the viewid on the datasource is CS0100. I would think it should be IC0160. Here's all the objects within the datasource...

Thanks for your Reply Bluejay07. -The session object is open and valid. I've created IC Transfers with it. -When I use the try catch, the error is a generic unmanaged COMException. One thing that is odd, is when I use a messagebox to display the error, the entire program crashes, even in debug...

I am using Accpac 5.6A.

Hi, I'm trying to use the AccpacFinder.ViewFinder I get an unhandled exception once I get to af.Finder(). No errors show up in af.Session.Errors. I'm using the AccpacCOMAPI on Windows 7 64bit with the program running in 32bit. I've tried everything I can think of but I can't seem to get this...