Search found 136 matches

Go to advanced search

by Terence
19.07.2006, 00:07
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Ado protocol = TZQuery problem rev 82.
Replies: 27
Views: 6951

?? sure it never changes, your code doesn't change the param, you have to set it eg with Query.ParamByName(TableNameColName).Value:= 'xy';
And i don't know an example where the sql
"select field from table where 'xy';" will makes sense.
Still unclear.
by Terence
18.07.2006, 23:56
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: maximum opened curors exceeded
Replies: 3
Views: 1046

Hmm we had someone with same problem. As far as i remember it was working for him. Maybe ask him at thread http://zeos.firmos.at/viewtopic.php?t=6 ... ght=cursor
by Terence
18.07.2006, 23:51
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: autoinc fields
Replies: 4
Views: 1624

I need more details!
How does your table def/ddt look like? How did you realized the autoinc with triggers?
What error exactly raised at which cmd in code?
by Terence
18.07.2006, 23:47
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Ado protocol = TZQuery problem rev 82.
Replies: 27
Views: 6951

Sry, i can't follow you. Try too make clear what is your problem, what is your actually solution and what don't work there.
by Terence
18.07.2006, 23:43
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZeosLib thread safety
Replies: 13
Views: 3647

I think this "bug" is fixed since delphi 2005.
by Terence
17.07.2006, 07:48
Forum: Announcements
Topic: MySQL Lifecycle Calendar
Replies: 1
Views: 6006

If they end support (5.0), what version follows, or does it simply ist no longer free available?
by Terence
15.07.2006, 09:46
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: How can I obtain value set in triggers?
Replies: 2
Views: 523

Sounds you likely could use "slq defaults def" for insert statements with some fields having default values, either you have to calculate them from others fields and don't wanna do that client side. I didn't exactly understood your question, but if you wanna save variables on server side b...
by Terence
15.07.2006, 09:31
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Howto get generated id/int best ?
Replies: 8
Views: 3372

Carefully pushing that topic ;) I am interested in implementing that, it seems having optimizing features for db connection and data exchange. Any idea how to solve that problems with need of run sql in front of insert statment? At the moment the "hook" is after the insert statmenet as imp...
by Terence
15.07.2006, 09:22
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Get auto-numbered primary key on insert?
Replies: 2
Views: 772

You can query for it with same params as for insert and "select id" afterwards , you can use mysql method in sql call "SELECT LAST_INSERT_ID()" or you can use TZUpdateSQL.OnAfterInsertStament Event for mysql only and only available for latest testing branch. Also see here for det...
by Terence
14.07.2006, 15:00
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: timeouts query/connection
Replies: 2
Views: 685

No, not really. I thought it was already implemented.
As far as no one has problems witrh timeouts i would see it as "nice2have".
by Terence
14.07.2006, 13:19
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: timeouts query/connection
Replies: 2
Views: 685

timeouts query/connection

Howto Set/Get Query and Connection Timeouts in Zeos?

Tx for help.
by Terence
13.07.2006, 15:39
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Maximum open cursors exceeded
Replies: 5
Views: 1166

Ahh, this already is applied in testing branch. Will be officical with next release also.
http://users.telenet.be/mdaems
by Terence
13.07.2006, 15:35
Forum: MySQL
Topic: Tablename as parameter
Replies: 6
Views: 1945

Well, i didn't say its tested, just give it a try. Inever used it that way too.

In any case i would propose to create a method taking the tablename as param and creating sql query as string or returning whole query- there are much possibilities.
by Terence
13.07.2006, 15:18
Forum: MySQL
Topic: Tablename as parameter
Replies: 6
Views: 1945

Try:

Code: Select all

with ZReadOnlyQuery2 do
begin
sql.Clear;
sql.add('Select');
sql.add('IFNULL(');
sql.add('(Select Ergebnis');
sql.add('from :LTABLE');
sql.add('where Probennr=106010050');
sql.add('and Parameternr =19),'') Parameter');

ParamByName('LTABLE').asstring:='l06_parameter';
open;
end;
by Terence
13.07.2006, 12:52
Forum: MySQL
Topic: Tablename as parameter
Replies: 6
Views: 1945

Try .ParamByName('LTABLE').asstring:=l06_parameter;

Leave the ':' out.
The ':' just implys an upcoming Parameter in the sql, just to differ between normal names and Parameter, but only in the sql. The Param is used without ':' later.

Go to advanced search