Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unanswered: SQL statement- string to long error

    I was given a template SQL statement that I was able to modify for Copier, Monitor and PC. I was able to run these three without error.
    When I went to memorize the Printer SQL statement I would receive an error “ The return string for the builder was to long.” “The result will be truncated.” Am I limited in the length of characters in the WHERE portion of these SQL statements? Is there anyway I can get around this? I have very little experience with SQL so please be gentle in your explaination.

    Copier
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [copierct], [location]
    FROM tblcopier1
    WHERE copierct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND copierct NOT IN (SELECT pcct FROM tblpc1)
    AND copierct NOT IN (SELECT monCT FROM tblMonitor1);


    Monitor
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [monct], [location]
    FROM tblmonitor1
    WHERE monct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND monct NOT IN (SELECT pcct FROM tblpc1)
    AND monct NOT IN (SELECT copierct FROM tblcopier1);


    PC
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [pcct], [location]
    FROM tblpc1
    WHERE pcct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND pcct NOT IN (SELECT monct FROM tblmonitor1)
    AND pcct NOT IN (SELECT copierct FROM tblcopier1);


    Printer
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [printerct], [location]
    FROM tblprinter1
    WHERE printerct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND pritnerct NOT IN (SELECT monct FROM tblmonitor1)
    AND printerct NOT IN (SELECT copierct FROM tblcopier1);

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734

    Re: SQL statement- string to long error

    Printer
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [printerct], [location]
    FROM tblprinter1
    WHERE printerct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND pritnerct NOT IN (SELECT monct FROM tblmonitor1)
    AND printerct NOT IN (SELECT copierct FROM tblcopier1); [/SIZE][/QUOTE]

    The error you are getting is actually produced when you have mismatched variables. You need to make sure that the fields you are inserting into have the same size as the fields you are inserting from. And if you are doing this insert with variables, you need to make sure your application has the same size as well.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Apr 2004
    Posts
    2

    Re: SQL statement- string to long error

    I found the answer. I appears that there is a string limit of 256 characters, at lest in Access97. I broke down my statements to a smaller size and everything saved and ran fine.

    Originally posted by rfrey
    I was given a template SQL statement that I was able to modify for Copier, Monitor and PC. I was able to run these three without error.
    When I went to memorize the Printer SQL statement I would receive an error “ The return string for the builder was to long.” “The result will be truncated.” Am I limited in the length of characters in the WHERE portion of these SQL statements? Is there anyway I can get around this? I have very little experience with SQL so please be gentle in your explaination.

    Copier
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [copierct], [location]
    FROM tblcopier1
    WHERE copierct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND copierct NOT IN (SELECT pcct FROM tblpc1)
    AND copierct NOT IN (SELECT monCT FROM tblMonitor1);


    Monitor
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [monct], [location]
    FROM tblmonitor1
    WHERE monct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND monct NOT IN (SELECT pcct FROM tblpc1)
    AND monct NOT IN (SELECT copierct FROM tblcopier1);


    PC
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [pcct], [location]
    FROM tblpc1
    WHERE pcct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND pcct NOT IN (SELECT monct FROM tblmonitor1)
    AND pcct NOT IN (SELECT copierct FROM tblcopier1);


    Printer
    INSERT INTO tblAllCT (CTNumber, location )
    SELECT [printerct], [location]
    FROM tblprinter1
    WHERE printerct NOT IN (SELECT CTNumber FROM tblAllCT)
    AND pritnerct NOT IN (SELECT monct FROM tblmonitor1)
    AND printerct NOT IN (SELECT copierct FROM tblcopier1);

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •