Hi tintinux,
Thanks for your quick reply. I m new to opensource comunity so have patience with me
I ve tried yesterday with new address that you gave me and it couldn't connect. Minute ago, I ve tried to enter the gestinux.mrit.com server and I get the folowing message:
Unable to connect to the server gestinux.mrit.com with username test (SQL Error: Access denied for user 'test'@****.dynamic.isp.telekom.rs' (using password: YES))
No problem, I ve analyized the code and successfully created DB with PostgreSql
I m using 1 05beta version of code and made the folowing changes:
First I ve changed the LONGTEXT to TEXT, i m using Postgres 9.2 and documentation says it uses only TEXT data type.
1 .gdbconnection.pas line 611 - ftMemo: Result := 'TEXT';
Then it made Assert exception
2.gdbconnection.pas line 400 Assert(DbConnection.getDbmstype <> DBMS_MySql) changed from =
EDIT: This is temporary change. Please can you tell me why you used Assert procedure here?
Now I can connect to DB, but I have another problem. When I click to Companies menu item I get the folowing message:
A database query failed (SQL Error: ERROR: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join SELECT CY.FullCompanyName,CY.Address1,CY.Address2,CY.City,CY.PostCode,CT.CountryCode,CT.CountryName, CY.FiscalIdentification1,CY.FiscalIdentification2,CY.Email,CY.Phone,CY.InvoiceEncoding,CY.NextInvoiceNumber FROM Company CY LEFT OUTER JOIN Countries CT ON CT.CountryCode = CY.CountryCode AND UserLanguage = 'en_US')
I read it's a PostgreSql limitation. But an interesting thing is happening, I ve installed Release Candidate 1.0 RC version of Gestinux and from there company query works ok.
Now I m trying to find PostgreSQL profiler to see what SQL text is beign executed, clearly RC works fine
Thank you once again!
EDIT: My computer runs on Win7 64 bit, Lazarus 32 fpc 32 compiler.