Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. apexearth

    Set to zero sets it to NULL

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

    SELECT IN A SELECT IN A SELECT (possible?)

    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
  3. apexearth

    Set to zero sets it to NULL

    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...
  4. apexearth

    SELECT IN A SELECT IN A SELECT (possible?)

    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...
  5. apexearth

    Optimizing Macro Record Lookups

    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...
  6. apexearth

    view GLPost inner join GLPost

    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...
  7. apexearth

    view GLPost inner join GLPost

    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...
  8. apexearth

    COMException using AccpacFinder.ViewFinder in VB.NET

    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
  9. apexearth

    COMException using AccpacFinder.ViewFinder in VB.NET

    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.
  10. apexearth

    COMException using AccpacFinder.ViewFinder in VB.NET

    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...
  11. apexearth

    COMException using AccpacFinder.ViewFinder in VB.NET

    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...
  12. apexearth

    COMException using AccpacFinder.ViewFinder in VB.NET

    I am using Accpac 5.6A.
  13. apexearth

    COMException using AccpacFinder.ViewFinder in VB.NET

    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...

Part and Inventory Search

Back
Top