Lucas,
You dont have open indexes right ?
Regards
Antonio H Ferreira
Antonio H Ferreira
Board index FiveWin for Harbour/xHarbour ADO RDD xHarbour
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 (1047 posts)
No.
Muchas gracias. Many thanks.
Un saludo, Best regards,
Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]
Implementando MSVC 2010, FWH64 y ADO.
Abandonando uso xHarbour y SQLRDD.
Un saludo, Best regards,
Harbour 3.2.0dev, Borland C++ 5.82 y FWH 13.06 [producción]
Implementando MSVC 2010, FWH64 y ADO.
Abandonando uso xHarbour y SQLRDD.
Antonio, Enrico,
How can we show or hide deleted records in ADO?
How can we enforce SET DELETED?
Regards
Antonio H Ferreira
Antonio H Ferreira
Antonio,
As far as I know, there is no direct support for deleted records in SQL. You have to add a logical field and use it in WHERE clauses, I'm afraid.
EMG
AHF wrote:Antonio, Enrico,
How can we show or hide deleted records in ADO?
How can we enforce SET DELETED?
As far as I know, there is no direct support for deleted records in SQL. You have to add a logical field and use it in WHERE clauses, I'm afraid.
EMG
Perhaps a first version of ADORDD no need to treat the deleted records because generally all have SET DELETED ON at the beginning of our programs
Enrico,
In fact this is not a problem because deleting records in SQL will wipe records off the table and we cannot recover them again. Is this true for all DB Sql ?
Regards
Antonio H Ferreira
Antonio H Ferreira
Antonio,
I don't know but we have to make it "database aware", haven't we?
EMG
AHF wrote:Enrico,
In fact this is not a problem because deleting records in SQL will wipe records off the table and we cannot recover them again. Is this true for all DB Sql ?
I don't know but we have to make it "database aware", haven't we?
EMG
Enrico,
Do you mean mark a record as deleted with truly deleted in SQL using a delete field in the tables?
In dbf apps we have to pack to clean it and some kind of recycle to recover it when adding records.
If we truly delete it nothing else mus be done. Although recall and pack exists in adordd but do nothing.
The trials we ae running with our app there is no problem but maybe others have a different approach.
Is it worth to do it ?
What do you think ?
Regards
Antonio H Ferreira
Antonio H Ferreira
The only drawback I see is this case:
Â
My opinion: will be few occasions or applications that this circumstance. At the moment I do not think it worthwhile to consider it. Perhaps ADORDD v2.00
nRec: = RecNo()
DELETE
GO nRec  // Ok dbf. ADO FailÂ
My opinion: will be few occasions or applications that this circumstance. At the moment I do not think it worthwhile to consider it. Perhaps ADORDD v2.00
Antonio,
Yes.
No, it's not worthwhile.
EMG
AHF wrote:Enrico,
Do you mean mark a record as deleted with truly deleted in SQL using a delete field in the tables?
Yes.
AHF wrote:In dbf apps we have to pack to clean it and some kind of recycle to recover it when adding records.
If we truly delete it nothing else mus be done. Although recall and pack exists in adordd but do nothing.
The trials we ae running with our app there is no problem but maybe others have a different approach.
Is it worth to do it ?
What do you think ?
No, it's not worthwhile.
EMG
To All
I think each RDMS handles deleted records a bit differently .. As in all Sql Databases, when a record is Deleted, it just drops off the 'radar' and there is no need to even worry about it or even to 'Recall' it .. I do not even think you can get it back unless you use some sort of 'roll back' technique.
I will say this .. it is obvious with Ms Access, that the size of the database DOES NOT decrease when you have deleted records so they still must be there, but are just not accessible, hence why you have to Compact and Repair the database from time to time. And, my guess when DBA's tune their MS Sql and Oracles of the world, deleted records are purged during that process.
In any case .. in my experience as a developer with Sql databases .. once a record is deleted, you might as well forget about it and 'Setting Deleted (On or Off )' is irrelevant.
Rick Lipkin
Rick,
Thanks for the info.
Inside transactions if it fails everything rolled back, but its the only situation I can find where his happens.
Are you trying adordd. All feed back its a great help.
Im trying it for a big app conversion and browses with relations run without any code change except a autoinc field to use for recno().
Regards
Antonio H Ferreira
Antonio H Ferreira
Is possible get library for Borland C 5.5 ?
Today, direct from Harbour, is imposible make this library.
Regards
O te pago una cerveza si lo consigues... 
Saludos
Rafa Carmona ( rafa.thefullARROBAgmail.com___quitalineas__)
Rafa Carmona ( rafa.thefullARROBAgmail.com___quitalineas__)
Antonio
I use the ADO Class and methods to create recordsets to manage SQL.. and creating separate recordsets based on the primary key and the foreign key or a single recordset based on inner and outer joins.. not necessarily like we used to with .Dbf.
I am watching this thread with interest.
Rick Lipkin
Rick,
Thats the SQL normal way.
Unfortunately we would get only one recordset (joined) and to simulate Dbf behavior and working with already written apps that's not possible because it breaks completely the code.
Thus I'm working with true relations issuing SELECTS for each child only if key changes.
The speed suffers but its completely acceptable.
I'm converting a big app and till now in browses didn't need to change a single line of code!
We have indexes, scopes, seeks, relations, filters (translated to Selets) using exactly the same app source code.
Take a look at the adordd.
Your comments and ideas would be most welcome.
Ill post new version with lot of bugs corrected tomorrow morning.
The actual posted version has been much modified and is very outdated.
Regards
Antonio H Ferreira
Antonio H Ferreira