Search found 5 matches
- 14.10.2006, 06:06
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: select @a := field from table; and Mysql and TZQuery
- Replies: 7
- Views: 1722
to fduenas When i put some break points in function TZSQLStrings.FindParam(const ParamName: string): Integer; debuger stop and file path is correct. I try to debug, my sugestion - problem is in function Tokens := Tokenizer.TokenizeBufferToList(Text, [toSkipComments, toUnifyWhitespaces]); But there i...
- 13.10.2006, 16:02
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: select @a := field from table; and Mysql and TZQuery
- Replies: 7
- Views: 1722
- 13.10.2006, 12:03
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: select @a := field from table; and Mysql and TZQuery
- Replies: 7
- Views: 1722
I want use this construction for queryies like this: select @a := (some long and complex expersion like case ... when), @a+1, @a+3, @a*2 from some_table Nice MySql feature. I don't need to rewrite complex expresions. I try set ParamCheck = false but it does not help..... Problem also is present in Z...
- 12.10.2006, 12:03
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: select @a := field from table; and Mysql and TZQuery
- Replies: 7
- Views: 1722
select @a := field from table; and Mysql and TZQuery
When i try to run application, i get error message
Incorrect token followed by '':"
...
Incorrect token followed by '':"
...
- 04.10.2006, 06:45
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: Refresh ONLY ONE - current record
- Replies: 1
- Views: 1091
Refresh ONLY ONE - current record
I search/read this forum, but I can't find any suitable solution to this problem. Method REFRESH - is VERY bad solution, because it reload all records from server. I use MYSQL 5. An triggers to calculate some field values before update/insert. But I cant see this values in my client. In Firebird/int...