Hello Pavel,
thank you for fix, I can wait to final version ...
Best wishes
Search found 15 matches
- Mon 14 Feb 2022 09:10
- Forum: InterBase Data Access Components
- Topic: Error "Too many Contexts of Relation/Procedures/Views" in IBDAC 8.0.2
- Replies: 8
- Views: 15835
- Wed 09 Feb 2022 15:39
- Forum: InterBase Data Access Components
- Topic: Error "Too many Contexts of Relation/Procedures/Views" in IBDAC 8.0.2
- Replies: 8
- Views: 15835
Re: Error "Too many Contexts of Relation/Procedures/Views" in IBDAC 8.0.2
I am using Firebird 3.0.7. I am sorry but it is part of my bigger application and I have not enought time for creating test application. Menwhile I "solved" it by downgrading to 7.4.4 where all is working ...
- Fri 28 Jan 2022 15:09
- Forum: InterBase Data Access Components
- Topic: Error "Too many Contexts of Relation/Procedures/Views" in IBDAC 8.0.2
- Replies: 8
- Views: 15835
Error "Too many Contexts of Relation/Procedures/Views" in IBDAC 8.0.2
Hello,
I have this code, where error occured with IBDAC 8.0.2 version.
I must downgraded to IBDAC 7.4.4 where all is OK.
Can you please check it and fix it ?
Thanks
I have this code, where error occured with IBDAC 8.0.2 version.
I must downgraded to IBDAC 7.4.4 where all is OK.
Can you please check it and fix it ?
Thanks
Code: Select all
qKI.SQL.Text:='SELECT pcI, SUM(CENAO), SUM(CENAS), SUM(HM), SUM(HMBAL), SUM(CELKPOCET), SUM(VYRPOC), SUM(NAKO*ICELKKS), SUM(NAKS*ICELKKS), SUM(CENAO*ICELKKS), SUM(CENAS*ICELKKS), SUM(NAKO), SUM(NAKS)'
+' FROM BWIO'
+' WHERE PCI=10001562 AND NOT INULY'
+' GROUP BY PCI';
qKI.Open;
Pocet:=qKI.RecordCount;
if Pocet>0 then begin
qKU.SQL.Text:='UPDATE I SET CENA=:0, HM=:1, HMBAL=:2, OPEALL=:3, OPEVYR=:4, NAKL=:5 WHERE PC=:6';
qKU.Params[0].DataType:=ftCurrency;
qKU.Params[1].DataType:=ftCurrency;
qKU.Params[2].DataType:=ftCurrency;
qKU.Params[3].DataType:=ftInteger;
qKU.Params[4].DataType:=ftInteger;
qKU.Params[5].DataType:=ftCurrency;
qKU.Params[6].DataType:=ftInteger;
qKU.Params.ValueCount:=Pocet; // specify the array dimension:
qKI.First; i:=0;
while not qKI.Eof do begin
Inc(i);
qKU.Params[0][i-1].AsCurrency:=qKI.Fields[1].AsCurrency+qKI.Fields[2].AsCurrency;
qKU.Params[1][i-1].AsCurrency:=qKI.Fields[3].AsCurrency;
qKU.Params[2][i-1].AsCurrency:=qKI.Fields[4].AsCurrency;
qKU.Params[3][i-1].AsInteger:=qKI.Fields[5].AsInteger;
qKU.Params[4][i-1].AsInteger:=qKI.Fields[6].AsInteger;
qKU.Params[5][i-1].AsCurrency:=qKI.Fields[11].AsCurrency+qKI.Fields[12].AsCurrency;
qKU.Params[6][i-1].AsInteger:=qKI.Fields[0].AsInteger;
qKI.Next;
end;
qKU.Execute(Pocet);
end;
qKU.Params.Clear;
qKI.Close;
- Thu 29 Apr 2021 07:50
- Forum: InterBase Data Access Components
- Topic: DetailDelay and Detail dataset
- Replies: 3
- Views: 4058
Re: DetailDelay and Detail dataset
Thanks, Viktor, I did it ...
- Fri 23 Apr 2021 13:14
- Forum: InterBase Data Access Components
- Topic: DetailDelay and Detail dataset
- Replies: 3
- Views: 4058
Re: DetailDelay and Detail dataset
FireDAC have TFDMasterDataLink.Synchronize for this purpose.
But how I can do it in IBDAC ?
Please answer, it is urgent for me.
Thanks !
But how I can do it in IBDAC ?
Please answer, it is urgent for me.
Thanks !
- Tue 20 Apr 2021 16:33
- Forum: InterBase Data Access Components
- Topic: DetailDelay and Detail dataset
- Replies: 3
- Views: 4058
DetailDelay and Detail dataset
Hello,
I am using DetaiDelay for all my tables (big database with lot of Master/Detail/SubDetail tables). After change of position of Master table I want check if data in Detail/Subdetail table was loaded already. Can you please add here any function, which can check it ?
If DetailDelay is more than 0, you are starting FDetailRefreshTimer in procedure TMemDataSet.MasterRecordChanged.
I would be like, if you can add here two things :
boolean DetailRefreshTimerRunning (if it is True, I will know that Detail dataset is not refreshed yet)
and/or
procedure ImmediatellyRefreshDetail (I can run it manually and be sure, that Detail dataset is refreshed)
Or can you advice, how I can check it in current version ?
Big thanks in advance !
I am using DetaiDelay for all my tables (big database with lot of Master/Detail/SubDetail tables). After change of position of Master table I want check if data in Detail/Subdetail table was loaded already. Can you please add here any function, which can check it ?
If DetailDelay is more than 0, you are starting FDetailRefreshTimer in procedure TMemDataSet.MasterRecordChanged.
I would be like, if you can add here two things :
boolean DetailRefreshTimerRunning (if it is True, I will know that Detail dataset is not refreshed yet)
and/or
procedure ImmediatellyRefreshDetail (I can run it manually and be sure, that Detail dataset is refreshed)
Or can you advice, how I can check it in current version ?
Big thanks in advance !
- Sat 23 Feb 2019 11:09
- Forum: InterBase Data Access Components
- Topic: Add new user
- Replies: 2
- Views: 3505
Re: Add new user
I'm sorry, it was my mistake - I'm using embedded server and I forgot set IBCSecurityService1.Server ...
Now is all OK.
Now is all OK.
- Fri 22 Feb 2019 15:13
- Forum: InterBase Data Access Components
- Topic: Add new user
- Replies: 2
- Views: 3505
Add new user
Hello,
can you please write here any example, how I can add new user into Firebird 3.0.4 via IBCSecurityService1. I tried lot of things, but without success. Always I get error "Missing user management plugin" ...
Thank you in advance !
can you please write here any example, how I can add new user into Firebird 3.0.4 via IBCSecurityService1. I tried lot of things, but without success. Always I get error "Missing user management plugin" ...
Thank you in advance !
- Thu 21 Jun 2018 13:04
- Forum: InterBase Data Access Components
- Topic: TVirtualTable - problem with Master/Detail
- Replies: 3
- Views: 2147
Re: TVirtualTable - problem with Master/Detail
Problem stay also on 6.1.7 ... Version 6.1.5 is OK ... Just I sent you sample application.
- Thu 21 Jun 2018 10:36
- Forum: InterBase Data Access Components
- Topic: TVirtualTable - problem with Master/Detail
- Replies: 3
- Views: 2147
TVirtualTable - problem with Master/Detail
Hello,
I found problem in IBDAC 6.1.6 with Master-Detail relationship in Virtual tables.
Short sample : I have 2 Virtual tables M (master) and D (detail).
I am using more that Master/Detail pairs in my application and now I have big problems with newest 6.1.6 version.
I readed list of changes and I found one possible point :
"Now Detail dataset is not refreshed when Master dataset editing is started"
Maybe just here is any bug with refreshing of detail virtual table ...
Thank you in advance for ASAP solution ...
I found problem in IBDAC 6.1.6 with Master-Detail relationship in Virtual tables.
Short sample : I have 2 Virtual tables M (master) and D (detail).
Code: Select all
M.First;
while not M.EOF do begin
...
D.First;
while not D.EOF do begin
!!!! <<<< here problem occured, D include not correct records (detailed to actual record of M)
D.Next;
end;
M.Next;
end;
I readed list of changes and I found one possible point :
"Now Detail dataset is not refreshed when Master dataset editing is started"
Maybe just here is any bug with refreshing of detail virtual table ...
Thank you in advance for ASAP solution ...
- Wed 11 Apr 2018 16:38
- Forum: InterBase Data Access Components
- Topic: GDPR, encryption - fastest way ?
- Replies: 3
- Views: 1531
Re: GDPR, encryption - fastest way ?
Thank you for answer, I will test it ...
- Fri 06 Apr 2018 15:15
- Forum: InterBase Data Access Components
- Topic: GDPR, encryption - fastest way ?
- Replies: 3
- Views: 1531
GDPR, encryption - fastest way ?
Hello,
I want use encryption in my application (+Firebird database) due to a new European law GDPR. Your solution is perfect and I thank you very much for it !!! :)
But I want optimize it for speed and I am looking for best way :
I have table CUSTOMERS with 20 fields (CHAR 80 each, approx.) and I want encrypt all this fields. All this fields will be showed in DBGrid and I want change sorting, search ...
I understand, that decryption is performed in the application (after fetching data from database/table) and data are decrypted and cached ? Now user can change sorting or search.
But what is faster way ?
1. When all fields will be encrypted/decrypted individually (it mean 20 field for one record)
or
2. I create any common data field (BLOB) where I put all this 20 fields together and application will encrypt/decrypt only this one field (naturally, I will create 20 "calculated"
fields for table and load it in OnCalcFields event.
Or shorten - what is faster - encrypt/decrypt of 20 short fields or encrypt/decrypt of 1 longer field ?
Thank you for explanation ...
I want use encryption in my application (+Firebird database) due to a new European law GDPR. Your solution is perfect and I thank you very much for it !!! :)
But I want optimize it for speed and I am looking for best way :
I have table CUSTOMERS with 20 fields (CHAR 80 each, approx.) and I want encrypt all this fields. All this fields will be showed in DBGrid and I want change sorting, search ...
I understand, that decryption is performed in the application (after fetching data from database/table) and data are decrypted and cached ? Now user can change sorting or search.
But what is faster way ?
1. When all fields will be encrypted/decrypted individually (it mean 20 field for one record)
or
2. I create any common data field (BLOB) where I put all this 20 fields together and application will encrypt/decrypt only this one field (naturally, I will create 20 "calculated"
fields for table and load it in OnCalcFields event.
Or shorten - what is faster - encrypt/decrypt of 20 short fields or encrypt/decrypt of 1 longer field ?
Thank you for explanation ...
- Fri 06 Apr 2018 14:58
- Forum: InterBase Data Access Components
- Topic: Encrypted fields + OnCalcFields
- Replies: 5
- Views: 1732
Re: Encrypted fields + OnCalcFields
Hello Viktor,
thank you. I understand now - here can be encrypted and crypted informations in one field and IBDAC will decrypt it only when it have "valid" format. But I think, I found next bug - I tried changed only one character in encoded text (character No.49 changed from "A" to "B" - see example) and application showed error message "Encrypted data is corrupt - Invalid encrypted data".
OK :
thank you. I understand now - here can be encrypted and crypted informations in one field and IBDAC will decrypt it only when it have "valid" format. But I think, I found next bug - I tried changed only one character in encoded text (character No.49 changed from "A" to "B" - see example) and application showed error message "Encrypted data is corrupt - Invalid encrypted data".
OK :
Bad:C544E5292C9C42A5B94FE27912702901D43DEE4BF7030808A5D71C397925E046532E8C0434AD7A9948FF286E8927511CB180D53747DCF783365B5FFAA4EF1983717FC76CE7F6AE1A5366DB2275BDF82CBC701D4B925C9188
Yes, I know, data are corrupted, but this message was showed also when I set ihSkipData in TIBCEncryptor.InvalidHashAction ...C544E5292C9C42A5B94FE27912702901D43DEE4BF7030808B5D71C397925E046532E8C0434AD7A9948FF286E8927511CB180D53747DCF783365B5FFAA4EF1983717FC76CE7F6AE1A5366DB2275BDF82CBC701D4B925C9188
- Wed 04 Apr 2018 14:08
- Forum: InterBase Data Access Components
- Topic: Encrypted fields + OnCalcFields
- Replies: 5
- Views: 1732
Re: Encrypted fields + OnCalcFields
Hello Viktor,
just I sent it ...
just I sent it ...
- Tue 03 Apr 2018 13:08
- Forum: InterBase Data Access Components
- Topic: Encrypted fields + OnCalcFields
- Replies: 5
- Views: 1732
Encrypted fields + OnCalcFields
Hello,
I am using encrypted field with IBDAC 6.1.5 in Delphi 10.1. All is working well, but I found one problem :
I want read decrypted value in OnCalcFields event of TIBCTable. All is OK when Options.CacheCalcFields is False,
but when Options.CacheCalcFields is True, I see only encrypted value. It seems, OnCalcFields is executed before
decryption ... How I can see decrypted value in OnCalcFields, when caching is enabled ?
Second think - I tried harm encrypted data in database for testing. I want "see" NULL value in this case.
I set ihSkipData in TIBCEncryptor.InvalidHashAction (DataHeader = ehTagAndHash, EncryptionAlgorithm = eaAES256,
HashAlgorith = haSHA1). But I see not NULL, but harmed encrypted value ...
Thank you in advance for any advice :)
I am using encrypted field with IBDAC 6.1.5 in Delphi 10.1. All is working well, but I found one problem :
I want read decrypted value in OnCalcFields event of TIBCTable. All is OK when Options.CacheCalcFields is False,
but when Options.CacheCalcFields is True, I see only encrypted value. It seems, OnCalcFields is executed before
decryption ... How I can see decrypted value in OnCalcFields, when caching is enabled ?
Second think - I tried harm encrypted data in database for testing. I want "see" NULL value in this case.
I set ihSkipData in TIBCEncryptor.InvalidHashAction (DataHeader = ehTagAndHash, EncryptionAlgorithm = eaAES256,
HashAlgorith = haSHA1). But I see not NULL, but harmed encrypted value ...
Thank you in advance for any advice :)