LiveCode Forums

Thanks for the update - have you submitted this problem to bugzilla?
That way the RunRev engineers can study it and provide a fix.

Jan Schenkel.

In that case, put an answer command right after the database connection is opened, to make sure that this handler is called: put revdb_connect("mysql","host:port","schema","user,"password") into tConnectionID answer "Opened connection:" && tConnectionID For debugging purposes, you could also trap th...

Hi Riccardo, If it works inside the Rev IDE, but not in your standalone, that's quite puzzling. As I don't know how your app works, I can only suggest that you add the following line just before your call to revdb_query, so you can check if you're using the wrong connection ID, or if some other piec...

Hi Riccardo, Could you post the exact script here? It should be something like: on mouseUp put revdb_connect("mysql","host:port","schema","user,"password") into tConnectionID if tConnectionID is not a number then answer error tConnectionID exit mouseUp end if put revdb_query(tConnectionID,"SELECT * ...

Hi Ed, The first thing to do is make sure and put quotes around the application path. launch "/macintosh HD/Programma's/iblog.app" You should check the path of the application as well, since the name of the folder in the finder may be different from the actual name of the folder. answer file "Select...

Unfortunately, some googling didn't turn up an ODBC Excel driver on MacOS. You could use AppleScript to talk to Excel, but that means you'll have to keep both Excel and your Rev-based solution open at the same time. Of course you can store the data in MySQL, and then you can always use Excel to quer...

Hi Ed, If you're on Windows, you can create a DSN in your ODBC Control Panel, using the Microsoft Excel driver. Then you can connect from Rev using something like: put revdb_connect("odbc",<DSN name>,,<username>,<password>) into tConnectionID And then use the connection ID in conjunction with the ot...

Hi George, You are correct: Rev doesn't support ActiveX controls because they're Windows only. Quartam Reports was written entirely in Revolution and doesn't rely on any platform-specific features. Give it a whirl and see if it does the trick for you - if you need a feature that it doesn't have yet,...

Hi Alex, When you connect to a MySQL database, you specify the host of the database as an IP-address or its hostname). So suppose that the server is called "gandalf.example.net", you'll connect to it like: get revdb_connect("mysql","gandalf.example.net",.....) or get revdb_connect("mysql","192.168.2...

Hi Steve,

Do you have any 'send in time' constructs in your code? The engine won't quit if you close the last window and there are still pendingMessages.
If that doesn't help, make the stack available for download and I'm sure someone will look it over to see what's going on.

Jan Schenkel.

A better option is to put your opup menu button somewhere off-screen, and then use a script like: on mouseUp pMouseButton if pMouseButton = 3 then popup button "MyPopupButton" at the clickLoc else -- do other stuff here end if end mouseUp The popup menu button will receive the 'menuPick' message whe...

Finally dragged out the install disk, and found the X11 optional install. Went ahead and installed it, and now the errors are gone and echo.mt actually returns results. Weird that I already had a directory on my hard drive, with only .a files -- and that the X11 installer from the Apple site claimed...

Hi Prior, There is currently a problem in the standalone builder that prevents the 'theme' support from getting copied into your standalone apps. You can fix this yourself using the following steps: - Go to the folder where you installed Revolution (probably the Applications folder) - Open the subfo...

Nope, the only dylib in that directory is libXpm.4.11.dylib and libXpm.dylib which is just a link to the first. imac-g5-van-jan-schenkel:/usr/X11R6/lib janschenkel$ ls -l -a total 37520 drwxr-xr-x 49 root wheel 1666 Apr 19 20:38 . drwxr-xr-x 6 root wheel 204 Dec 26 11:34 .. -rw-r--r-- 1 root wheel 1...

Hi Garett, There's no real reason to set those properties, except to save RAM - when you close a stack and the purge stack property is true, reopening the stack will be the same as a 'revert' (unless you saved the stack first). If those properties are false, the stack is retained in memory, and any ...