Zeoslib Portal

EgonHugeist , Tested the 'NULL' string. It just write as a normal string. What is weird is the error happens even when passing a bit (boolean) parameter. Sending a value as false (0) throws the exception, while if the value is true, the value is passed normally. In the integer case, any number diff...

Ok, with this issue solved, i am just struggling against the "empty parameter error", but i verified it happens when setting any parameter to the type's "default" as: string = '' integer = 0 boolean = false s i tested the procedure with this 3 types of fields and it just don't us...

EgonHugeist , i don't know exactly, but any provider (mysql, firebird, postgreSql,...) need some characters to be escaped on the procedure name (not taking the parameter values on account)? As on the links you give, this escaping is necessary in the LIKE section of a SELECT statement. For me, it's ...

EgonHugeist , i have read about FreeTDS and i think this is a good idea to replace zeos's method of accessing MS SQL server using the current dll, because i just using the ado protocol because of said MSSql dll not work in x64 enviroments. I tried to understand how the ado protocol get the metadata...

EgonHugeist , I have tested the SPs with SQL Server Management Studio and they are running like they should. The database have Latin1_General_CI_AS collation. The zero return value don't matter for my needs, my SPs will execute something internally or retrieve data which is used opening and navigat...

I was able to execute the procedure. The solution is to add a Result parameter before the input parameters: (putting it after the input ones causes the same exception) ... xsp := TZStoredProc.Create(Self); xsp.Connection := conn; xsp.StoredProcName := 'xp_addtest'; // *** AND THIS IS THE MAGIC LINE ...

Hello Michael and thanks for the reply. I am glad Zeoslib have always someone to improve it. Now, for the question list: 1) Used SQL Server 2008 R2 Express; 2) Using ado protocol; (not using mssql because of the 64-bit limitation) 3) Used double @ on the CreateParam, i will test more tomorrow; 4) I'...

Hello everyone, i am trying to execute a stored procedure on a local MS SQL Server instance, but it seems that i am not able to set the SP parameter. On the ExecProc line i got this exception: Project Project1.exe raised exception class EOleException with message 'Procedure or function 'xp_addtest' ...