Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2008
    Posts
    2

    Unanswered: string data, right truncated error in parameter 1

    Hi all,
    i want to connect my db use ODBC on Delphi, was program run turn back error General SQL error ODBC string data, right truncated error in parameter 1 any idea pls.
    Code:
    procedure TForm1.FormActivate(Sender: TObject);
    begin
     query2.First;
      while not query2.eof do
      begin
       query2.next;
    
       QUERY1.Active:=false;
       QUERY1.Params[0].Value:=DBEDiT2.Text;
    
       QUERY1.Active:=true;//  Error this command run

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    does your parameter have a data type?
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    This example is not valid SQL Server syntax, nor is it a valid SQL Server procedure.

    How does this relate to SQL Server?

    -- This is all just a Figment of my Imagination --

  4. #4
    Join Date
    Feb 2008
    Posts
    2
    oohh yes i connect to Progress Db and this field have a Turkish character

Posting Permissions

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