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

2009/6/28 César Espinoza :

Is there enough space allocated for consulta to take length(consultastr)+1? Why don't you just use:

mysql_query(sock,PChar(consultastr))?

Henry

But I can't (may be I dont know :-( ) insert data in a table

If you can query, but not insert, there are a few things to check:

- Is the syntax of your insert correct? I mean, does column 'lugar' exist, and is it a varchar column, etc.?
- Are you allowed to insert? (Check the privileges for the person as who you log in. Insert, update, select, all have separate 'enables')
- What is the message returned by mysql_error?

John