LiveCode Forums

Hi Alan, Revolution doesn't really have the concept of 'date' fields - or 'decimal' fields or any other type of masked input. Every field is a rich text editor and any special behaviour must be scripted - with the exception that you can set a property to tab to the next control when the user hist th...

Hi Homer, You don't need to open and close URL's. When you 'put' something into a URL or 'get' something from a URL, Revolution will open the file, write/read the portion of data, and close the file. Also, you need to specify a URL protocol: file:, binfile:, ftp:// or http:// And Revolution likes it...

Hi Rick, If the 'filter' command is causing this type of problem, you should definitely report it in the Quality Control center: http://quality.runrev.com . That being said, for large datasets it is sometimes faster to use the 'repeat for each' construct, especially if the filter is complex: -- put ...

Hi Ralle, When I look at the following line: revExecuteSQL gConID,"insert into Schueler(SchuelerID,name, vorname) VALUES(:1,:2);", tname, tvorname I see that you're mixing a number of things. First off, the VALUES clause has one field less than the number of fields that you put in parentheses right ...

Hi Kai, The easiest way is to use preserved characters as your row and column delimiters in your call to revDataFromQuery, then replace the tab and return characters with spaces, and replace the reserved characters with tabs and returns. Here's a bit of code to get you going - you'll probably want t...

Hi Jeremy, The crash logs ought to be in the directory: C:\Documents and Settings\<User>\Application data\Runtime Revolution\Revolution <Media|Studio|Enterprise>\Crash Logs\ where <User> is the name of the user that logged in, and <Media|Studio|Enterprise> should be replaced with the proper license ...

Hi Jeremy, The likely suspect is a corrupt image - unfortunately, you cannot find out any other way than by deleting images until the app no longer crashes. Another potential problem (that bit me with Rev 2.7.0 and 2.7.1) is the 'ink' property of controls that you create dynamically; if you use the ...

Hi Ralle, Don't be alarmed by multiple views without a solution - not everybody is familiar with the intricacies of SQL databases - in fact, many Revolution users wanted to get away from those beasties in the first place ;-) You don't pass the variables themselves, but rather the names of the variab...

Unfortunately, the Query Builder cannot extract the primary key information from the database - it's there in the database, but the query builder needs your help ; the combobox is there to allow you to select a column as the primary key. This primary key column information is then used to update the...

That is odd - it works for me with Revolution 2.8.1-gm-2 on both MacOS X 10.4.10 PPC, and Windows XP.
Have you tried the oneliner approach?

Jan Schenkel.

Hi Kai, When you execute commands through the message box, they're executed one at a time, atomically. Which means that setting a 'local' property such as the 'useSystemDate' has no influence on the next line of code that you execute. So, there are two solutions: either use the multi-line message bo...

Bonjour Eric, The website for all Quartam products is located (perhaps a bit uninspired) at http://www.quartam.com You can click the link right here, or you can use the link at the end of my signature, or you can click the 'www' button at the bottom of each reply. Isn't it wonderful how the web give...

Heh, then the next bit of advice comes a tad too late ;-) If you have downloaded the MySQL Administrator app, you open that, go to the 'Options' tab, use the menu button to switch to the 'Security' panel, and then tick the checkbox 'Use old passwords'. Enjoy your new-found powers of Rev cgi and MySQ...

I think you can switch to 'old style' passwords from the MySQL Administrator, without running the query mentioned in Ken Ray's tip. As I don't have access to my desktop computer right now, I can't give you the exact location of the option, but I'll look later today.

Jan Schenkel.

It could be that FileMaker stores the style information in a separate column of the table; one that is not accessible from the outside. What happens when you use the following code to extract all the column names of a table? function AllTableColumnNames pConnectionID, pTableName put "SELECT * FROM" ...