Search found 322 matches

by zippo
20.10.2005, 18:19
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problem with NULL params in TZStoredProc - URGENT!
Replies: 5
Views: 1719

Quick and dirty:

Use -1 as a parameter for using NULL (you will have to slightly modify the stored procedure): If the parameter i >=0 then it's a customer, else write NULL in the field.

Hope it helps.
by zippo
18.10.2005, 21:47
Forum: MySQL
Topic: MySQL 5
Replies: 1
Views: 1555

MySQL 5

Hi to all!

I wonder if anybody is using Zeos and MySQL 5. Especially stored procedures. Is there any good tutorial on stored procedures for dummies? :oops:
by zippo
18.10.2005, 21:44
Forum: Feature Requests
Topic: Help files needed
Replies: 4
Views: 2838

Well, to be honest I don't miss the help file very much. In fact 90% of the properties and events are from TDataSet, so F1 indeed works.. :):):) The only thing missing for new dudes is the special properties and events like Catalog, ZMetaData, SQLProcessor,.. etc. Those functions are not implemented...
by zippo
13.10.2005, 14:05
Forum: MySQL
Topic: Delphi7 - mysql 4.1 user variable
Replies: 7
Views: 2235

Any yes - do not use umlats --> use only ASCII characters for field names!
by zippo
13.10.2005, 14:04
Forum: MySQL
Topic: Delphi7 - mysql 4.1 user variable
Replies: 7
Views: 2235

"SELECT @Platz:= (@Platz + 1)" is wrong

Ithink it should be

SELECT @Platz= (@Platz + 1)

":=" is valid only in Delphi, not in SQL.
by zippo
13.10.2005, 11:21
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZConnection with MySQL 4.x
Replies: 2
Views: 946

Well, I would like to know what Catalog is exactly for. I always use .Database to select a database.
by zippo
12.10.2005, 22:40
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: resume broken connection
Replies: 9
Views: 2998

I Solved the problem with a timer and a simple function like "Select 1... :wink: . Not very clean, but Iwas in hurry,