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.
Search found 322 matches
- 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
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?![Embarassed :oops:](./images/smilies/icon_redface.gif)
I wonder if anybody is using Zeos and MySQL 5. Especially stored procedures. Is there any good tutorial on stored procedures for dummies?
![Embarassed :oops:](./images/smilies/icon_redface.gif)
- 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...
- 13.10.2005, 14:05
- Forum: MySQL
- Topic: Delphi7 - mysql 4.1 user variable
- Replies: 7
- Views: 2235
- 13.10.2005, 14:04
- Forum: MySQL
- Topic: Delphi7 - mysql 4.1 user variable
- Replies: 7
- Views: 2235
- 13.10.2005, 11:21
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: ZConnection with MySQL 4.x
- Replies: 2
- Views: 946
- 12.10.2005, 22:40
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: resume broken connection
- Replies: 9
- Views: 2998