mysql55 problem with mysql_fetch_row
lazarus / 16-Databases

----------------------------------------------------------------------
nadavvin · 2018-11-27 19:13

Hello

I am porting HeidiSQl to Lazarus and my project is here:
https://github.com/nadavvin/HeidiLazarusSQL

I got error on mysql_fetch_row: Error: Incompatible types: got
"PPChar" expected "PMYSQL_ROW"

I did example project for this issue and it failed on the same
problem.

It failed on compile and without the mysql_fetch_row it run and
connected to the database.

row is PMYSQL_ROW defined in mysql.inc and it defined as:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i PMYSQL_ROW
= ^MYSQL_ROW;       // return data as array of stringsMYSQL_ROW =
ppchar;
The example code:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i program
project1; {$mode objfpc}{$H+} uses  mysql55; var  mysql: PMYSQL;  s:
PMYSQL;  ClientFlags: qword;  sql: AnsiString;  status: Integer; 
result: PMYSQL_RES;  row: PMYSQL_ROW;begin   ClientFlags :=
CLIENT_LOCAL_FILES or CLIENT_INTERACTIVE or CLIENT_PROTOCOL_41 or
CLIENT_MULTI_STATEMENTS or CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS; 
WriteLn(ClientFlags);  mysql := mysql_init(nil); 
s:=mysql_real_connect(mysql, 'localhost', 'root', 'root', nil,
3306,nil,ClientFlags);   if s <> nil then begin   
WriteLn('Success');  end else begin    WriteLn('Failed');  end;   sql
:= 'show databases';  status := mysql_real_query(mysql,PAnsiChar(sql),
Length(sql));  result := mysql_store_result(mysql);  row :=
mysql_fetch_row(result);end. 
Thanks for your help

----------------------------------------------------------------------
Leledumbo · 2018-11-27 20:29

This is the signature of mysql_fetch_row:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i function
mysql_fetch_row(result:PMYSQL_RES):MYSQL_ROW;extdecl;external mysqllib
name 'mysql_fetch_row'; So now you should what row's type should be.

----------------------------------------------------------------------
nadavvin · 2018-11-28 04:43

Thanks, I confused because in the heidisql project the signature is in
with PMYSQL_ROW:
mysql_fetch_row: function(Result: PMYSQL_RES): PMYSQL_ROW; stdcall;