Zeoslib Portal

Hi Jan

Problem solved. I dropped the table and recreated without the collation.
As these are small tables and i have not noticed a speed drop when connecting with the mormot server.

Thanks very much

Thanks Jan I use the zeos component in a tiny app that updates data daily from a variety of XLS spreadsheets. The app was previously connected to a firebird database and i am changing it to SQLite. The irony is that the error only occurs with a delete with condition. The full delete works and the in...

Hi marsupilami

The extended error message is

SQL Error: Error: SQL logic error or missing database

Message: no such collation sequence: SYSTEMNOCASE.

The table was generated by a Mormot server with this Collation. Is there a way to add support for this collation

Thanks

Hi marsupilami

Thanks for that. Yes its SQLite. Ill upgrade and see what happens. Much appreciated.

Hi All Im using 7.2.4-stable with Delphi Berlin starter 10.1 Code: DM.ZConnection1.Connected := true; DM.InfoSQL.SQL.Clear; DM.InfoSQL.SQL.Add('DELETE FROM aInfo WHERE SUPPLIER_NAME = ''Lovato'''); DM.InfoSQL.ExecSQL; // DM.InfoSQL.Active := true; If i leave out the WHERE condition the delete works ...

Hi Egon Through a Delphi client talking to mormot HTTP Rest Server, ServiceFactoryServer and common Interface. Iv also run direct from a delphi client with SQLMonitor. I dont see any error but the delay is the same. Results below: The result is returned after 30 seconds with below fro SQLMonitor. Wh...

Hi All I have a situation i don't understand. I hope someone can throw some light on. The code below query's an OLEDB provider for a small, little known business database. After initiating the query from inside a mormot SOA server, there is about a 10 second delay. The server log throws an error, &q...

Hi marsupilami, thanks for the reply i am using it in a mormot soa server as the database only has an odbc connection for it that i could not find a odbc driver for it in mormot (perhaps i should add there is probably away but yours was easier). I found that your component connected and retrieved th...

Hi Newbie first question posting again Hi All Any help will be appreciated Im running a SOA server which functions perfectly with authentication and a SQLite database. I needed to extract data from a propitiatory database. initial tests where positive. However when I extract many records I get an ou...