zeos_开发者

Zeoslib: How to tell if query is still processing?

I am using Zeoslib in Delphi to access a local MySQL database. I call a stored procedure with the TZQuery object:[详细]

2023-04-02 22:58 分类：问答

How to transfer a multidimensional array to a MySQL table (through Zeoslib)?

I am using the Zeoslib library in Delphi. I have a large multidimensional static array that I need to transfer to an empt开发者_StackOverflowy table in a local MySQL database. How can I do this effici[详细]

2023-04-02 12:27 分类：问答

Zeoslib: How to tell when query execution is complete?

I am using ZeosLib within Delphi to call a MySQL stored procedure through the TZQuery object. Immediately after MySQL finishes execution of the stored procedure I need to initiate my next block of cod[详细]

2023-04-02 02:32 分类：问答

Zeoslib - loop over calculated fields

I have a Delphi 7 project using Zeoslib 6.6.6 and Sqlite3. On the form I have a Zquery selecting everything out of a 开发者_开发技巧sample database table along with a bunch of calcuated fields (TFloat[详细]

2023-03-21 00:56 分类：问答

How can I delete the SQLite DLL when I'm finished with it if the OS thinks it's still in use?

How can I unlock or delete a file that is in use, so that I can delete it? The file in question is used by my own application.[详细]

2023-03-06 12:30 分类：问答

Keep RichEdit Formatting as a String?

I am assigning a string to a custom type I have declared, which I Read/Write using the TTreeViews Node.Data property. I read and write to and from the node, something like this:[详细]

2023-03-06 06:12 分类：问答

Using @variables:= in delphi query does not work

I have the following problem. ZQuery1.SQL.Text:= \' SELECT\'+ \'IF(q.rank2 = 1, @rank:= 1, @rank:= @rank + 1) AS rank \'+[详细]

2023-02-24 11:47 分类：问答

How to write LONG RAW data using OCI and Lob locator?

I want to fix zeoslib bug in writing long raw data bug description: Memo1.Lines.LoadFromFile(\'c:\\t\\ZDbcMetadata.pas\'); // file size ~ 170Kb[详细]

2023-02-19 02:04 分类：问答

Delphi: how to create Firebird database programmatically

I\'m using D2K9, Zeos 7Alpha, and Firebird 2.1 I had this working before I added the autoinc field. Although I\'m not sure I was doing it 100% correctly. I don\' know what order to do the SQL code, w[详细]

2022-12-29 07:49 分类：问答