Search found 1891 matches
- 16.01.2024, 16:00
- Forum: Firebird
- Topic: DROP DATABASE implementation
- Replies: 1
- Views: 275
Re: DROP DATABASE implementation
Hello eversun, The DROP DATABASE statement deletes the current database. Before deleting a database, you have to connect to it. So - if you have to connect to the database you could do something like this: ZConnection.Connect; ZConnection.ExecuteDirect('DROP DATABASE'); ZConnection.Disconnect; I am ...
- 16.01.2024, 15:51
- Forum: Firebird
- Topic: check On-Disk-Structure (Version) of fdb-file
- Replies: 1
- Views: 270
Re: check On-Disk-Structure (Version) of fdb-file
Hello Siegbert, In embedded Version of firebird 4 it is possible, to open a Database-File that has Version 2.5. No - this is not possible at all. Are you sure, your program is loading the correct fbclient.dll? I use the following code to determine the ODS version, where the ODS version gets saved in...
- 16.01.2024, 10:30
- Forum: SQLite
- Topic: SQLite on iOS
- Replies: 3
- Views: 352
Re: SQLite on iOS
Hello Alan - I tried SQLite on Android. It works. Let me know if you have any problems.
- 15.01.2024, 09:55
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Sorting by calculated field does not work
- Replies: 9
- Views: 783
Re: Sorting by calculated field does not work
Hello,
which version of Zeos do you use? I seem to remember thios was a problem in Zeos 7.2. But I thought it was fixed for Zeos 8.
Which error message do you get?
Which version of Delphi or Lazarus / Freepascal do you use?
Can you provide a small sample application?
With best regards,
Jan
which version of Zeos do you use? I seem to remember thios was a problem in Zeos 7.2. But I thought it was fixed for Zeos 8.
Which error message do you get?
Which version of Delphi or Lazarus / Freepascal do you use?
Can you provide a small sample application?
With best regards,
Jan
- 15.01.2024, 09:50
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Sorting by calculated field does not work
- Replies: 1
- Views: 294
Re: Sorting by calculated field does not work
Locked in favor of viewtopic.php?f=50&t=191559
- 15.01.2024, 09:48
- Forum: SQLite
- Topic: SQLite on iOS
- Replies: 3
- Views: 352
Re: SQLite on iOS
Hello Alan, in general it should be possible to use SQLite with Zeos 8 on iOS. The driver compiles just fine. But I don't know of anybody who tested this. Plese checkoud the current version of Zeos 8 from our SVN. Basically the steps should be: Find an SQLite 3 library for iOS (I couldn't find one o...
- 15.01.2024, 09:35
- Forum: Firebird
- Topic: FireBird 4 and 5
- Replies: 4
- Views: 473
Re: FireBird 4 and 5
No - please use the "firebird" protocol. Protocol names with version numbers are deprecated and are not supported with Zeos 8.
With best regards,
Jan
With best regards,
Jan
- 15.01.2024, 09:33
- Forum: ZeosLib 7.2 Forum
- Topic: Compile-Error on ZDbcAdoUtils (D7)
- Replies: 2
- Views: 357
Re: Compile-Error on ZDbcAdoUtils (D7)
Hello DieterWo, I am sorry - it took some time to test this. On my Test computer the DBC package of Zeos 7.2.14 compiles just fine. Maybe there are some old DCU files around or something like this? Please clean up the build directory in the Delphi 7 package directory. Also check "C:\Program Fil...
- 13.01.2024, 15:58
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
- Replies: 8
- Views: 588
Re: Lazarus - TZUpdateSQL not bringing its update fields selected
Hello singlesis,
unfortunately there is no patch yet.
With best regards,
Jan
unfortunately there is no patch yet.
With best regards,
Jan
- 12.01.2024, 17:29
- Forum: Firebird
- Topic: FireBird 4 and 5
- Replies: 4
- Views: 473
Re: FireBird 4 and 5
Hello Al-Eid,
Zeos 8 and Zeos 7.2 support Firebird 4 and 5.
With best regards,
Jan
Zeos 8 and Zeos 7.2 support Firebird 4 and 5.
With best regards,
Jan
- 11.01.2024, 15:39
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: [zeos8] Wrong statement does noy triiger an exception when prepare, Why?
- Replies: 6
- Views: 531
Re: [zeos8] Wrong statement does noy triiger an exception when prepare, Why?
Prepare queries need to submit sql code to a server previously and returning true of false from server to proceed. Some times, we do manually: if not query1.prepared then query1.prepare; Why would you do that? Just remove these lines and do error handling when you open the query. Because another in...
- 02.01.2024, 09:39
- Forum: User Patches
- Topic: I got rid of recent hints and warnings
- Replies: 1
- Views: 332
Re: I got rid of recent hints and warnings
Hello aehimself,
I applied the patch. Thank you and a happy new year![Smile :)](./images/smilies/icon_smile.gif)
Jan
I applied the patch. Thank you and a happy new year
![Smile :)](./images/smilies/icon_smile.gif)
Jan
- 29.12.2023, 22:24
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: LargeInt like FMTBcdField Size 0
- Replies: 3
- Views: 501
Re: LargeInt like FMTBcdField Size 0
Hello amonteiro, In the FIB exists a property in the dataset (PrepareOptions) called psSQLINT64toBCD, when i check this the BIGINT in the Firebird is treated like type BCD size 0. Is there something like this in the ZEOS? No - there is no property like that in Zeos. Why would you want to treat an IN...
- 19.12.2023, 11:22
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Compilation problems [D7]
- Replies: 1
- Views: 378
Re: Compilation problems [D7]
Hello bodenseematze, the following worked for me some minutes ago on Delphi 7 Professional: make sure that only the path to Zeos-trunk\packages\delphi7\build is in the library path. make sure that no old compiled zeos units (Z*.dcu) or old Zeos files (*.pas) can be found by Delphi - even in the dire...
- 15.12.2023, 16:18
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: How to migrate TDateTimeField to TZDateTimeField?
- Replies: 1
- Views: 305
Re: How to migrate TDateTimeField to TZDateTimeField?
Hello shmorsecode, Zeos now allows to use much more detailed settings than were available with Delphi. The DisplayFormat equivalent of TZDateTimeField is DisplayFormat.Format. The following are lines from an application that we develop: (DataSet.FieldByName('VON') as TZTimeField).DisplayFormat.Forma...