LiveCode Forums.

Okay,

Now I've figured out that the script was never really executing anyway because it part of the OpenCard event and I need to close the card before that event executes. cute...

Now I get an error.
Type: Function: error in function handler
Line: get revOpenDatabase("ODBC","mydatabase","user ...

Good questions....

OpList is a Table Field on the card. How did I configure it? I didn't.
I can't find an example of loading data from a query into a table.
http://lists.runrev.com/pipermail/use-revolution/2003-May/016229.html
Has some example I was going to try next in it's "transcriptList" event ...

Okay...

So, I have a card with a Table field named "OpList" on it.

In the card script I have:

on opencard
get revOpenDatabase("ODBC","mydatabase","user","password")
put it into did
get revDataFromQuery(,, did, "select * from dbo.operator")
put it into OpList
end opencard

When I run the card I ...

Mark....

Its MS-Sql2000. It's an existing database so I don't have a choice. Is ODBC a problem? Is there a better way to access MSSql? I bot the pro version because Enterprise didn't add anything I needed and didn't see MSSql in it's specs..

Okay - so I need to ignore the Query Builder. and use ...

I've seen the tutorials and they are all single table type applications.
I've never developed anything like that before. Most of my applications have 50 to 100 tables, etc.

Since I purchase RunRev a few months ago, I have been unable to get anywhere with it. There are no examples of a real contact ...

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.

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 ...