Search found 7 matches

by PaulMacFarlane
Wed Apr 04, 2007 11:41 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Any Real Database type examples?
Replies: 7
Views: 7533

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","pass...
by PaulMacFarlane
Wed Apr 04, 2007 10:50 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Any Real Database type examples?
Replies: 7
Views: 7533

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 -...
by PaulMacFarlane
Wed Apr 04, 2007 8:16 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Any Real Database type examples?
Replies: 7
Views: 7533

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 receiv...
by PaulMacFarlane
Wed Apr 04, 2007 5:52 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Any Real Database type examples?
Replies: 7
Views: 7533

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 the ...
by PaulMacFarlane
Wed Apr 04, 2007 9:03 am
Forum: Getting Started with LiveCode - Experienced Developers
Topic: Any Real Database type examples?
Replies: 7
Views: 7533

Any Real Database type examples?

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 m...
by PaulMacFarlane
Fri Feb 02, 2007 6:12 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: ODBC Connection busy with results for another hstmt ?
Replies: 2
Views: 3844

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.
by PaulMacFarlane
Thu Feb 01, 2007 8:20 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: ODBC Connection busy with results for another hstmt ?
Replies: 2
Views: 3844

ODBC Connection busy with results for another hstmt ?

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

Go to advanced search