Search found 30 matches

by Dali
24.03.2015, 14:50
Forum: ADO
Topic: TDateTime and Access MDB
Replies: 1
Views: 3188

Re: TDateTime and Access MDB

Another thread, this one even older, depicting the same situation: http://zeoslib.sourceforge.net/viewtopic.php?f=33&t=2818&p=13439 This solution of changing ZDBCADOUtils in this way: function ConvertAdoToSqlType(FieldType: SmallInt): TZSQLType; begin case FieldType of ... adDate : Result :=...
by Dali
24.03.2015, 14:24
Forum: ADO
Topic: TDateTime and Access MDB
Replies: 1
Views: 3188

TDateTime and Access MDB

Hello! Sorry for bringing this back to life but I'd like to know if there is a solution. I'm facing exactly this issue, now closed because it was related to a previous beta version of the Zeos components: http://zeoslib.sourceforge.net/viewtopic.php?f=33&t=3596 Example: zquery.fieldByName('CREAT...
by Dali
17.03.2015, 19:59
Forum: ZeosLib 7.1 stable Forum
Topic: Unknown function TRIM: firebird 1.5
Replies: 12
Views: 4728

Re: Unknown function TRIM: firebird 1.5

I'm very sorry for not having said anything before, but I had to be away for a couple of months because of huge changes at my office which required all my attention. (...) I was thinking about use the "old" code for FB<2.0 and for Interbase i can't judge it. Dali seems to be happy without ...
by Dali
11.11.2014, 14:39
Forum: Interbase
Topic: Read-only?
Replies: 6
Views: 3588

Re: Read-only?

Thank you guys for your replies. I have not your expertise and I barely can follow your explanations to understand what's happening here, but I did check the RDB$FIELD_NAME type into RDB$FIELDS system table as advised and, yes, it is actually a fixed lenght string, char(31) to be accurate. I don't k...
by Dali
07.11.2014, 10:49
Forum: Interbase
Topic: Read-only?
Replies: 6
Views: 3588

Re: Read-only?

OK, so I tried with latest stable version, 7.1.4, from svn, revision 3477. Everything compiled and I saw there's still support for Interbase 6, but now it's even worse, I can't even connect. The exception I get is caused by some metadata SELECT which uses the function TRIM, which is unknown in Inter...
by Dali
06.11.2014, 14:26
Forum: Interbase
Topic: Read-only?
Replies: 6
Views: 3588

Re: Read-only?

More info on this issue: I'm using latest Lazarus 1.3 and FPC 2.6.4.

My current revision of 6.6-patches is 3472. The previous one was revision 903 (as I said, very old, and hosted by an older repository).
by Dali
06.11.2014, 14:19
Forum: Interbase
Topic: Read-only?
Replies: 6
Views: 3588

Read-only?

Hello! It's been a while since my last visit here, sorry about that. Now, back to business, I have an application which interacts with a very old Interbase 6.0 database. Upgrading that database to any other version of Interbase or Firebird is not an option. If I recall right, Zeos 7 won't support In...
by Dali
08.07.2011, 11:10
Forum: 6.6 - stable
Topic: ExecSQL doesn't commit
Replies: 1
Views: 531

Have you checked the RowsAffected property afterwards?
by Dali
29.06.2011, 23:50
Forum: Interbase
Topic: Active users in Interbase 6
Replies: 6
Views: 4418

Of course I can wait, but please don't feel forced to do anything if you can spend your time doing any other thing which would benefit more people (or you, BTW). Though it'd be cool to have an easy way to accomplish this, you have been extremely kind already, the thing is already running, and the us...
by Dali
29.06.2011, 18:55
Forum: Interbase
Topic: Active users in Interbase 6
Replies: 6
Views: 4418

Yes, mine is set to serializable, but, as I said, I still don't know what their old app's isolation level is set to (I guess it is set to "none", if their access component even allows any setting, which I ignore). Quick example: The last time I dared to run a batch process using my app wit...
by Dali
29.06.2011, 16:48
Forum: Interbase
Topic: Active users in Interbase 6
Replies: 6
Views: 4418

Thanks for dropping by so quickly, seawolf. I'm stuck with this one and I really appreciate any help. I searched everywhere, but I can't find a method, dirty or not, which can tell me the number of current attachments to the underlying database. Maybe some of the libraries or command-line tools bund...
by Dali
29.06.2011, 13:39
Forum: Interbase
Topic: Active users in Interbase 6
Replies: 6
Views: 4418

Active users in Interbase 6

Hello. I'm developing a small application which must be run against a pre-existent Interbase 6 database. At this time, the app works fine (Lazarus+Zeos 6.6.6), but I'd like to have controlled the active connections to avoid data corruption if my customer's old app tries to access any data while modi...
by Dali
21.06.2011, 15:25
Forum: User Patches
Topic: [patch_done] Fix incorrect loCaseInsensitive in Lazarus
Replies: 11
Views: 3448

ism wrote:I do not think that the patch does is worse. Wait, the word of mdaems

To Lazarus, this patch is very needed
Couldn't agree more.
by Dali
23.05.2011, 18:25
Forum: 6.6 - stable
Topic: So UTF-8 WORKS or NOT?
Replies: 1
Views: 518

Well, I use Zeos for postgresql, and it works fine in version 6.6.6 with patches from svn simply adding the property "codepage=utf8". With version 7 alpha it does NOT work yet (as for svn 903). At least, not in Lazarus. There are many changes to be made in many places using compiler condit...
by Dali
20.05.2011, 15:19
Forum: ZeosLib 7.0 Beta Forum
Topic: Lazarus 0.9.31+MySql server 5.5+windows 7 "Access Viola
Replies: 16
Views: 2439

OK, I'm on it. Thanks.