I'm working with MySQL and Delphi. I created the following table: Create table Ligacoes (
Lig_cod INTEGER NOT NULL, Lig_codate INTEGER NOT NULL, Lig_nomeat VARCHAR(20), Lig_data DATE NOT NULL, Lig_duv TEXT, Lig_resp TEXT, Lig_penden CHAR(1), Lig_codcli INTEGER, Lig_erro CHAR(1), Lig_os CHAR(1), Lig_orca CHAR(1), Lig_dura DATETIME, Lig_hora CHAR(8), Lig_versao CHAR(20), Lig_codmotivo INTEGER NOT NULL, Lig_duv_so CHAR(1), Lig_prob_rede CHAR(1), Lig_contat CHAR(20) , CONSTRAINT Ligacoes_pk PRIMARY KEY (Lig_cod) )TYPE=INNODB; But when I try to open in a TQuery the recordcount result -1. Note: This problem(-1) normally happen when the result set is so large. What is the solution? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php