Welcome, Guest
Username: Password: Remember me
General discussions, feature requests for CodeTyphon Project and discussions that don't fit in any of the other specific CodeTyphon forum categories.
  • Page:
  • 1

TOPIC:

Error in open SQLQuery 3 months 2 weeks ago #18199

  • Ramon Retamar
  • Ramon Retamar's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 32
  • Thank you received: 0
Hi.
I migrate a code from CT 7.0 to last version 8.2 without changes. The code is simple, and compile without problems in CT 7.0, but cause a SIGSEGV error en Open line:
Function TFDatos.Cantidad_de_informes_previos(DNI: String): Integer; // Contar la cantidad de estudios con observaciones
Begin
  With TSQLQuery.Create(Nil) Do
    Begin
      Try
        Screen.Cursor := crHourGlass;
        DataBase :=IBConnection2;
        Transaction := SQLTransaction4;
        SQL.Add('Select Count(DNI_PACIENTE) From ESTUDIOS Where (DNI_PACIENTE = ' + QuotedStr( DNI ) + ')' );
        Open;                                                                                                               /// ERROR !!!!
        Result := FieldByName('COUNT').AsInteger;
        Close;
      finally
        Free;
        Screen.Cursor := crDefault;
      end;
    End;
end;

Strange, very strange. I try to rebuid project, clean and rebuid....and get the same error....only with CT 8.2

Thanks, Ramon
 

Please Log in or Create an account to join the conversation.

Last edit: by Ramon Retamar.

Error in open SQLQuery 3 months 2 weeks ago #18201

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1061
  • Thank you received: 149
Check "Client Libraries" location.
From CT 7.0 to 8.2 after 4 years, many things have changed...
PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

Error in open SQLQuery 3 months 2 weeks ago #18204

  • Ramon Retamar
  • Ramon Retamar's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 32
  • Thank you received: 0
Thank you very much for answering. Where can I verify this option in the new version?

Ramon

Please Log in or Create an account to join the conversation.

Error in open SQLQuery 3 months 2 weeks ago #18205

  • Matis A.
  • Matis A.'s Avatar
  • Away
  • Moderator
  • Moderator
  • Posts: 1061
  • Thank you received: 149
Many SQL databases need more than one file to load and work.
So we added to ALL SQL databases the
Property ClientLibrary

 


Give then Client library (DLL for Win)

Test if ALL Options are OK (user name, pass, CharSet, etc)
 
PilotLogic Core Programmer
Attachments:

Please Log in or Create an account to join the conversation.

Error in open SQLQuery 3 months 2 weeks ago #18206

  • Ramon Retamar
  • Ramon Retamar's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 32
  • Thank you received: 0
Thanks !!!!

I use the Firebiord 3.0 database, and client library is the fbclient.dll file located into executable folder. I check all database properties. Thanks !!!    

Please Log in or Create an account to join the conversation.

Last edit: by Ramon Retamar.
  • Page:
  • 1