Zeoslib Portal

Actually, I expect that the implementation of MariaDB complies with what other databases do. See https://mariadb.com/kb/en/uuid-data-type/. As UUID is not a real datatype (in any programming language), I assume they are all treated similarly. In my code, I did not experience issues as the field is a...

Yes, the field is treated as a string in Lazarus. When applied, the format must comply with the uuid specs. As UUid is an existing datatype for oracle, postgres and sqlserver, I guess they will be treated the same way.

Recent versions of Maria support the uuid datatype. I could not find a way to implement it, so I dove into the code. In ZDbcMySqlUtils.pas I added: end else if TypeName = 'uuid' then begin FieldType := stGUID; ColumnSize := 16; around line 668 Not sure how to implement it in a way that it is verifie...

Is it possible to extract this info from the metadata component? It is not reported as an autoinc field, fieldtype is 7 which can be int and int-identity.

The docs say "2.5.8 TZSQLMetadata With this special TDataSet component it is possible to access the metadata of a database like tables, columns, etc. (This chapter is still to be expanded!)" So that is still work in progress. Using the Metadata component works fine. However I was not able ...

Yep, found it. Replacing the dll did the job. Tnx again.

Tnx Jan. I have 64bits wamp but since Lazarus runs 32bits I use the 32 bits dll. I was not complete in my question appearantly as I'm not using Delphi (any more) but lazarus. However. Since it's working with you it's something in finding the right dll I guess. The dll from 32 bits mysql generates a ...

I have an issue which is most likely due to a wrong mysql dll. If I use an old dll from 2006 all work quite well, except that the metadata component does not report autoinc fields. I tried to replace the mysqllib from my wamp mysqlpackage (32 bits) but it refuses to load. I wonder what is wrong, I'm...

And I thought I was an experienced developer *g*.

Tnx, sooooo obvious.

I must be seeing things wrong but I have the following two events: procedure TFDBView.ToolButton2Click(Sender: TObject); begin ZQ.Close; ZQ.Connection := ZT.Connection; ZQ.SQL.Text := SQLEdit.Text; ZQ.Open; DS.Dataset := ZQ; end; procedure TFDBView.ToolButton3Click(Sender: TObject); var vs : string;...

I will try to find out. My own components for delphi generates the correct errormessage. The current errormessage was putting me on the wrong leg. But it's because I know a bit about the sqlite dll stuf. It could be that the errormessage is correctly generated, but then overriden somehow. I stepped ...

You are right, and the cause is mine. The errormessage was putting me on the wrong leg. The problem is that my select statement contained a small error in a fieldname. So I would expect a sql syntax error, but i did not get that. So the problem is that it is generating a wrong errormessage. I manage...

Using another connection does not work. I tried that too. It's because sqlite is not suitable for multiconnections afaik. I wrote my own components for sqlite a long time ago which had similar issues then. It had to do with finalizing the connection. I am not giving up, still working on it. My probl...

I haven't been able to put the finger on it, but it looks like it's going wrong if you combine execsql where no cursor is needed and selects where a cursor is needed. This error occurs when the dll is not finalized correctly, but it's been a while since I worked with the code. In other words, couln'...

This error occurs when: Each invocation of sqlite_step returns an integer code that indicates what happened during that step. This code may be SQLITE_BUSY, SQLITE_ROW, SQLITE_DONE, SQLITE_ERROR, or SQLITE_MISUSE. Useually things get messed up if some kind of nesting occurs. I think that the create t...