*** Alex|off is now known as Alex| | 00:59 | |
*** DerMeister has joined #ingres | 02:32 | |
*** Alex| is now known as Alex|off | 02:36 | |
*** DerMeister has quit IRC | 03:17 | |
cytrinox | hi | 05:55 |
---|---|---|
cytrinox | I've downloaded the latest 9.3 release to test some of the new features | 05:55 |
cytrinox | here is the script that I'm using to create two tables and a selectable procudure: | 05:56 |
cytrinox | http://nopaste.info/40bffb374f.html | 05:56 |
cytrinox | but the last statement which selects the rows from the procedure returns no rows | 05:56 |
cytrinox | the "test" rows are not returned, too. | 05:56 |
cytrinox | does anyone know why the procedure doesn't work as expected? | 05:57 |
pboro | did it work in 9.2, or does it require 9.3 to work? | 05:58 |
cytrinox | selectable procedures (SELECT .. FROM proc()) is a new feature in 9.3. maybe 9.2 can handle such procedures, too, if you use {call proc()} | 06:00 |
pboro | ah, ok | 06:01 |
cytrinox | http://www.privatepaste.com/download/d10a6EuOlG | 06:01 |
cytrinox | direct download-link | 06:01 |
cytrinox | ..huhu? :) | 06:22 |
pboro | I don't have 9.3 installed, so can't try reproducing :/ | 06:23 |
cytrinox | :/ | 06:24 |
pboro | you could try posting the forums or newsgroup :) | 06:24 |
pboro | there's a lot more people following things than here | 06:24 |
cytrinox | is: SELECT COUNT(*) INTO :"varArticleCount" FROM "article"; the correct syntax to assign the result to a local variable varArticleCount? | 06:30 |
*** FrankW has joined #ingres | 06:41 | |
*** rossand has joined #ingres | 06:57 | |
*** ChanServ sets mode: +o rossand | 06:57 | |
cytrinox | Runtime error in vdbasql.exe | 07:49 |
cytrinox | ..duhh :) | 07:49 |
*** rossand has quit IRC | 07:53 | |
*** Alex|off is now known as Alex| | 09:16 | |
*** [1]Gerhard has joined #ingres | 10:13 | |
*** [1]Gerhard has quit IRC | 10:57 | |
*** FrankW has quit IRC | 11:21 | |
*** FrankW has joined #ingres | 12:02 | |
*** rossand has joined #ingres | 12:05 | |
*** ChanServ sets mode: +o rossand | 12:05 | |
*** rossand has quit IRC | 12:25 | |
*** Alex| is now known as Alex|off | 13:51 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:21 | |
*** cytrinox_ is now known as cytrinox | 19:21 | |
*** FrankW has quit IRC | 21:52 | |
*** Alex|off is now known as Alex| | 22:37 | |
*** Alex| is now known as Alex|off | 23:17 | |
*** dyki has joined #ingres | 23:21 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!