Search found 7 matches
- 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...
- 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 -...
- 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...
- 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 ...
- 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...
- 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
- 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 ...