Search found 6 matches

by Urios
19.05.2010, 14:05
Forum: 6.6 - stable
Topic: Zeos + Oracle = Erro : OCI_SUCCESS_WITH_INFO
Replies: 4
Views: 839

OCI SUCCESS WITH INFO =

you're trying to do a SUM or an over aggregate function on a NULLABLE column.
by Urios
08.01.2007, 09:08
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: [CLOSED] TZQuery with 'NewValue' and 'OldValue'
Replies: 5
Views: 1347

I have found a solution using datasource's "OnDataChange" !
I'm making an array with modified field names,
and in the tzquery's "BeforePost" method I'm modifying query's of tzupdate
object.

Thank you !
by Urios
05.01.2007, 09:21
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: [CLOSED] TZQuery with 'NewValue' and 'OldValue'
Replies: 5
Views: 1347

OldValue will store the original value of the field when the record is retreived for first time from the server. it stores the original value and not a value after a modification. So it functions for already existing records and not for newer ones Ok, but in "beforepost", for a modified f...
by Urios
04.01.2007, 18:12
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: [CLOSED] TZQuery with 'NewValue' and 'OldValue'
Replies: 5
Views: 1347

What I would like to do is rebuild the query of the UpdateSQL object in order to insert/update only the fields which were modified, according to the differents tables of the view on which I work.
by Urios
04.01.2007, 17:22
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: [CLOSED] TZQuery with 'NewValue' and 'OldValue'
Replies: 5
Views: 1347

Hello,

Nobody has tried this ?
by Urios
06.10.2006, 14:49
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: [CLOSED] TZQuery with 'NewValue' and 'OldValue'
Replies: 5
Views: 1347

[CLOSED] TZQuery with 'NewValue' and 'OldValue'

Hello everybody, first of all, excuse my very very bad English (I'm French and frenchies don't speak english very well :) ). Special thanks to the dev team of these fabulous components. If i'm posting here it's because I have a problem with tzquery's 'OldValue' and 'NewValue' functions : values are ...