[fpc-pascal] Insert into ... mysql

César Espinoza cesarespinozasoto at gmail.com
Sun Jun 28 22:42:04 CEST 2009


Hi all  !!

I did! I can now connect and query to mysql

fpc 2.2.4, console, Macosx 10.5 leopard, Mac book Intel

But I can't (may be I dont know :-( ) insert data in a table
------------
 connect mysql  ... ok
  select db ... ok
.....
  new(consulta);
  consultastr:='INSERT INTO lugares (lugar) values (''Sala'')';
  strPCopy(consulta,consultastr);
  writeln ('Executing query : ',Consulta,'...');
    if (mysql_query(sock,consulta) < 0) then
      begin
      Writeln (stderr,'Query failed ');
      writeln (stderr,mysql_error(sock));
      Halt(1);
      end;
----------

What is wrong?
Thanks in advance


-- 
-------
César Espinoza Soto
---------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20090628/5f789eef/attachment.html>


More information about the fpc-pascal mailing list