ODBC Connection busy with results for another hstmt ?

[PaulMacFarlane]

I'm new (can't you tell?) to Rev.

I'm trying to establish an ODBC connection to an existing mssql DB.

So, I create a new Mainstack. I then create a query. So far seems okay.
I add a table to the card and setup the database properties.

If I run the card - nothing happens. So I switch to dev mode and try and edit the Query. I get this message. I try to go back to the card. I get the message. All seems stuck in a loop with different things competing for the connection...

- What am I doing wrong?
- Why can't Rev handle more that 1 connection at a time?
- Why can't you edit queries independently of a card?

A little lost...<g>

Thanks,
Paul

[oliverk]

Hi Paul,

Revolution should be able to handle multiple ODBC connections with no problem.

Could you explain a bit more about how your program works? If you could send me the stack perhaps I could take a look at it and see if I can spot what's going wrong.

Regards

Oliver

[PaulMacFarlane]

It really isn't even a program yet.<g>

Start a New Stack.
Edit/Create a Query
Place a table on the card using that query.
No data gets displayed.

Once I run the stack, if I attempt to edit the query the errors start.

It seems to be the development environment NOT the stack.