Please help me about variables

[Phil_Test]

Hi,
it's the fist time I use Dbfit and java code....

I want use a result query in a other table fixture
For example :
|Set parameter|p1|502|
|Query| select * from MDN_BET Where spor_book_bet_id=:p1|
|BET_ID?|
|>> p2|

!|fixtures.IndexMarketFixture|
|spor_book_bet_id|bet_begin_date|result?|
|:p2|23/07/2009 10:30:00.000|true|

How do you use p2 or : (p2?) in the second fixture ?

thank you for your answers
Oups I'm french guy..

[Gojko Adzic]

use <<p2 in second table. oracle : syntax only works in queries. with
variables in tables, >> puts the value in, << reads the value out.

gojko

[Philippe Maire]

Thank Gojko,
but you know why I have a error

"Missing method"

 

fixtures.IndexMarketFixture Missing method: public TypeOfResult getFixturesDotIndexMarketFixture() { } OR: public TypeOfResult fixturesDotIndexMarketFixture() { } in class dbfit.OracleTest
spor_book_bet_id Missing method: public TypeOfResult spor_book_bet_id(Type1 arg1, Type2 arg2) { } in class dbfit.OracleTest	bet_begin_date	result?
<<p2 Missing method: public TypeOfResult lessThanLessThanP2(Type1 arg1, Type2 arg2) { } in class dbfit.OracleTest

23/07/2009 10:30:00.000

true

 

 

2009/11/5 Gojko Adzic <goj...@gmail.com>

[Gojko Adzic]

you might be missing an !include, or this might be due to fitnesse/
fitlibrary version mismatch.


gojko

On Nov 5, 8:59 am, Philippe Maire <phma...@gmail.com> wrote:
> Thank Gojko,
> but you know why I have a error
>
> "Missing method"
>
>   fixtures.IndexMarketFixture

> ------------------------------

> Missing method: public TypeOfResult getFixturesDotIndexMarketFixture() { }
> OR: public TypeOfResult fixturesDotIndexMarketFixture() { } in class
> dbfit.OracleTest spor_book_bet_id

> ------------------------------

[MatMan]

As your second fixture is not a dbfit fixture then this won't work.

[MatMan]

As far as I know "<<" and ">>" are only supported in dbfit fixtures (or fixtures extended from these).

On Monday, 3 December 2012 10:46:45 UTC, raghav wrote:

Hi Gojko,

I am having similar problem.i have used the symbol for reading output (<<)

But i am getting the error.

Please let me know which version of fitnesse is compatible.

Here is my test : 

|dbfit.MySqlTest|

|Connect|192.168.3.28:3306|lennox|123test|lennox|

Input Params values 

Selecting Prodapp parameter

Get Prev Qty from DB

|Query|select sum(qtyMoved)as qty from pvm_tabular_fp_acc where month=1 and year=2011 and prodApp=@prodApp |

|qty?|

|>>preqty|

Validate the Prev Qty from DB 

!|leantaasQa.Calculations|

|app|qty|verifyqty?|

|Test|<<preqty|Passed|