Re: RevMail Problem
Thanks Dwayne, I tried your suggestion, but my version of RR was already up to date. The problem does seem to be related to a missing library in the stand-alone. Revmail doesn't work from the standalone until I start the RR development environment. Whereupon, the mail in the standalone script behaves impeccably, even if I exit the RR development app. A reboot of my PC then restores the standalone to its non-mailing state. Regards Roger Kingston >Hi Roger, >Problem lies in the original revlibrary.rev file (components/global >environment/) >The problem has been fixed, you can download an update by running Rev 2.5 then choose Help > Check >for Updates... You will probably be prompted to update the revstandalonesettings.rev file >(components/tools/) also. >This is done automatically and a backup copy of each is made! >Cheers Dwayne... >> From: "Roger Kingston" <[EMAIL PROTECTED]> >> Subject: RevMail Problem >> >> I'm running RR 2.5 under MS Windows XP SP2 and have stumbled across a >> problem with revMail in a standalone. The mail script I have is in a >> button on a card in a substack and it works fine in the Development >> environment and MS Outlook - starting the mail program if it's not >> running, but just does nothing in the standalone. (No error message). >> >> Code is: >> revMail lvMailTo,lvRecipientList,lvSubject,lvBody >> >> The Standalone Application Settings are set to 'search' for required >> inclusions. >> >> Can anyone help please? >> >> >> Roger Kingston ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RevMail Problem
I'm running RR 2.5 under MS Windows XP SP2 and have stumbled across a problem with revMail in a standalone. The mail script I have is in a button on a card in a substack and it works fine in the Development environment and MS Outlook - starting the mail program if it's not running, but just does nothing in the standalone. (No error message). Code is: revMail lvMailTo,lvRecipientList,lvSubject,lvBody The Standalone Application Settings are set to 'search' for required inclusions. Can anyone help please? Roger Kingston ___ use-revolution mailing list use-revolution@lists.runrev.com http://lists.runrev.com/mailman/listinfo/use-revolution
RE: How to list tables in an SQL database
Thanks again Jan, I very much appreciate your in-depth knowledge of the secrets of Rev! My tests, which I performed on ODBC connections both local (MS Access) and over the Internet (MS SQL), show that the revdb_tablenames() function does exist (i.e. no error message when called), but the response is always empty. This is strange, because I can manipulate the connected databases very successfully with all the other revdb funtions and commands, so I'm not sure what is going wrong here. I tried the exact example you mailed me and the response was empty. Perhaps this is why the function isn't documented, maybe it's not properly supported? The only other clue I have is that when using the Automatic DB Query form, it too fails to list the database tables. Could it be connected with something in my local setup or do others experience the same problem? Regards Roger Kingston Hi Roger, Indeed I was referring to an automatic query from the Query Builder. If you're not using that, you could try the 'revdb_tablenames' function ; unfortunately that didn't get an entry in the docs either. So assuming tConnectionID is the ID of a connection to your database, try this : -- put revdb_tablenames(tConnectionID) into tTables answer tTables -- Hope this helped, Jan Schenkel. = "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
RE: How to list tables in an SQL database
Jan,
Thanks for your guidance. I'll give it a try shortly. Just to clarify,
when you say, "use the name of an existing query" do you mean the ID
number generated by a RevDBquery or are you referring to an automatic
query from the Rev Query Builder?
Sorry for submitting this question three times, but I was getting
'mailbox full' rejections.
Regards
Roger Kingston
8 Parsons Walk
Clifton Campville
Tamworth
B79 0DL
email: [EMAIL PROTECTED]
-Original Message-
From: Jan Schenkel [mailto:[EMAIL PROTECTED]
Sent: 19 January 2004 16:52
To: [EMAIL PROTECTED]; How to use Revolution
Subject: Re: How to list tables in an SQL database
--- Roger Kingston <[EMAIL PROTECTED]>
wrote:
> All,
>
> I've had a good deal of success using Rev 2's revdb functions, but
> would like to be able to get a list of tables belonging to
> a database that I
> have connected to.
>
> Looking in the code behind the Rev Database Query
> builder, there is a
> function:
> revTableNamesOfQuery() which looks promising, but it
> is not documented
> and I'm too dumb to figure out how to use it.
>
> Any suggestions?
>
> Roger Kingston
>
Hi Roger,
The trick is to use the name of an existing query that
connects to the database whose table names you want ;
so suppose you have a query "Foobar" :
put revTableNamesOfQuery("Foobar") into tNames
answer tNames
Hope this helped,
Jan Schenkel.
=
"As we grow older, we grow both wiser and more foolish at the same
time." (La Rochefoucauld)
__
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
___
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
FW: How to list tables in an SQL database
All, I've had a good deal of success using Rev 2's revdb functions, but would like to be able to get a list of tables belonging to a database that I have connected to. Looking in the code behind the Rev Database Query builder, there is a function: revTableNamesOfQuery() which looks promising, but it is not documented and I'm too dumb to figure out how to use it. Any suggestions? Roger Kingston 8 Parsons Walk Clifton Campville Tamworth B79 0DL email: [EMAIL PROTECTED] ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
FW: How to list tables in an SQL database
All, I've had a good deal of success using Rev 2's revdb functions, but would like to be able to get a list of tables belonging to a database that I have connected to. Looking in the code behind the Rev Database Query builder, there is a function: revTableNamesOfQuery() which looks promising, but it is not documented and I'm too dumb to figure out how to use it. Any suggestions? Roger Kingston 8 Parsons Walk Clifton Campville Tamworth B79 0DL email: [EMAIL PROTECTED] ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
How to list tables in an SQL database
All, I've had a good deal of success using Rev 2's revdb functions, but would like to be able to get a list of tables belonging to a database that I have connected to. Looking in the code behind the Rev Database Query builder, there is a function: revTableNamesOfQuery() which looks promising, but it is not documented and I'm too dumb to figure out how to use it. Any suggestions? Roger Kingston 8 Parsons Walk Clifton Campville Tamworth B79 0DL email: [EMAIL PROTECTED] ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
URL Trouble
I'm having success with this simple script in a button: on mouseUp get URL "http://mysite.com/Data/myDataFile.csv"; put it into lvData put lvData & cr & the result end mouseUp This works fine the first time. Then I have to wait something like several minutes (or exit RunRev and reload) before it, or any other file will download again. In the meantime I get "Timeout Error" in the result. I'm sure this is a very simple misreading of the Runrev documentation, coupled with my inexperience with URL's, but can anyone help me please??? Thanks in advance Roger Kingston Omnibus Systems Roger Kingston VP Omnibus Product Operations Omnibus Systems Stanford House Stanford on Soar Loughborough LE12 5PY England Tel + 44 8705 004380 (Direct Dial) Tel + 44 8705 004300 (Reception) Fax + 44 8705 004333 (Not secure) Mob + 44 7970 134 380 The information contained in this email and any attachments may be confidential. If you have received this mail in error please notify us immediately by telephone or by a return email. You should not use, copy or disclose the contents of this email or of any attachments for any purpose or to any person. Opinions expressed in this communication are those of the sender and are not necessarily supported by Omnibus Systems. ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Re: DDE - Dynamic Data Exchange
Ken Ray wrote: > Where is this "old" Externals Collection for Windows? I don't see it on > runrev.com. OK is this it? http://www.xworlds.com/metacard/external.htm > ? I found it in the list archives. Maybe it should be added to the > runrev.com site? Roger Kingston wrote: Thanks Ken - I found it and it works! >It's at: http://www.xworlds.com/metacard/contributorfiles/ext10final.sit >Ken Ray >Sons of Thunder Software ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
DDE - Dynamic Data Exchange
In a past life, I used to integrate Toolbook (Asymetrix) applications with Winword and EXCEL using DDE. This allowed me to pass data to and from MS documents and then remotely run macros in MS to format, chart or mail-merge, etc. This was extremely powerful and pretty reliable. Now I am an unrepentful RR convert (no going back!) can anyone suggest whether or not this, or something like it, can be achieved with RR? Regards Roger Kingston Omnibus Systems ___ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
