Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: TOCIUpdateSQL
TOCIUpdateSQL
Posted: 2000/09/10 03:17
 
Dmitry,
I hope you don't mind, but I have the following comments on TOCIUpdateSQL.

1. It would be really useful to be able to see the automatically generated SQLLock, SQLUnlock, SQLUpdate, SQLInsert, SQLDelete, SQLRefresh at design time for its associated query, instead of it being generated only at run-time. Then we could make slight changes where required.

2. Do you have plans to create a property editor similar to that employed in Borland's TUpdateSQL (for use at design time) to help generate specific SQLUpdate, SQLInsert, SQLDelete etc. ? That would be very useful.

3. If I refer to any of the UpdateSQL TStrings text in the OnSQLGenerate, e.g. SQLUpdate.Text or SQLUpdate.Strings[1] I get stack overflows.

4. Just as a small point, there are two spelling mistakes associated with TOCIUpdateSQL, which as I am English keep catching me out.
lmPesimistic (TOCILockMode) should be spelt lmPessimistic
lpDefered (TOCILockPoint) should be spelt lpDeferred

Can't wait for the next release!

Paul
RE: TOCIUpdateSQL
Posted: 2000/09/20 17:45
 
Hi Paul !

1,2 Yes, i will develop such component editor for TOCIUpdateSQL.

3,4 Fixed. Thank you ! V 0.9.1 will contain appropriate fixes. If you want to get them earlier, let me know.