Re: Access Plugins
http://www.download.com/XML-2-MDB/3000-2210_4-10447327.html The way I populate an empty database is to construct the sql commands and save them as a text file, then execute the file. How are you going to do that without having Access installed? -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
Mikey- Wednesday, December 6, 2006, 11:46:58 AM, you wrote: > Well, a couple of things hre, > 1) the plane-disaster only supports access97, so that's a bit of a problem. > 2) Someone sent me a link to an application called xml-2-mdb, which > solves the database creation problem. > Now if I can just populate the tables I'm set, other than talking to > the piece of hardware that I need to retrieve the data from... Can you post the link? That sounds interesting. The way I populate an empty database is to construct the sql commands and save them as a text file, then execute the file. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
Well, a couple of things hre, 1) the plane-disaster only supports access97, so that's a bit of a problem. 2) Someone sent me a link to an application called xml-2-mdb, which solves the database creation problem. Now if I can just populate the tables I'm set, other than talking to the piece of hardware that I need to retrieve the data from... -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
Viktoras- Wednesday, December 6, 2006, 2:11:34 AM, you wrote: > Although I have never tried creating new database or defining schema with > this, but maybe it can be useful in this regard too... Rev studio has open IIRC the Access driver doesn't support the "CREATE DATABASE" sql command. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
Don't know if this might be useful (calling it from Rev): http://sourceforge.net/projects/plane-disaster/ Can create new files, you can then zip them up with Rev. From the description: 'PlaneDisaster.NET is a .NET Database front end for JetSQL (Microsoft Access File Format) and sqLite. In addition to basic database browsing and querying, it can create new JetSQL and SQLite files as well as compact and repair JetSQL databases.' It's Windows only. Cheers, Luis. Mikey wrote: All, I have a really interesting project that I'm going to be starting here shortly, but it has a problem - I need to be able to generate Access database files as output (and then zip them). I'd love to be able to do this one in RR, because there will be a significant amount of parsing, and chunk expressions are SO perfect for that. However, if I can't use RR to (easily) generate .mdb files then I'm going to be forced to use one of the other tools at my disposal. Suggestions? Mike. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
try communicating with Access driver through js or vbs script. In both js and vbs there is a way to build a dsn-less connections to nearly any type of relational database. A while ago I worked with this from within hta apps, but now went multiplatform with Rev and start forgetting those things... For example this jscript function creates and uses dsn-less connection to execute SQL commands: function dbAccess(sql) { var dbrcd, cString, sql; // Creating ADO Recordset dbrcd = new ActiveXObject( "ADODB.Recordset" ); //Creating the connection string cString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=Tables.mdb"; // Create SQL Statement //sql = "SELECT * from table1"; // Open connection to database dbrcd.Open( sql, cString, 1, 3); while( !dbrcd.EOF ) { // Loop through each field in this record // and add contents to variable for( i = 0; i < dbrcd.Fields.Count; i++ ) { record+= dbrcd(i) + " ";} //Move to the next record and loop dbrcd.MoveNext(); record+="\n"; } return (record); } Although I have never tried creating new database or defining schema with this, but maybe it can be useful in this regard too... Rev studio has open driver close driver handlers, although I have never tried to communicate with Access driver directly from within Rev, could this work ?.. Best regards Viktoras ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
I'd love to be able to do this one in RR, because there will be a significant amount of parsing, and chunk expressions are SO perfect for that. One possibility is to generate a DLL (if this is on Windows) that has the Jet Engine interface built into it. I'm not knowledgeable about building plugins for Rev, but Delphi, C++ Builder and Visual C++ can all do this (with the right custom libraries and they aren't dear). Then call the dll as a plug-in I guess... Scott ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
Mikey- Tuesday, December 5, 2006, 11:08:45 AM, you wrote: > All, > I have a really interesting project that I'm going to be starting here > shortly, but it has a problem - I need to be able to generate Access > database files as output (and then zip them). > I'd love to be able to do this one in RR, because there will be a > significant amount of parsing, and chunk expressions are SO perfect > for that. > However, if I can't use RR to (easily) generate .mdb files then I'm > going to be forced to use one of the other tools at my disposal. > Suggestions? Does it *have* to be Access, or can you generate some intermediate file (CSV, for example) that could then be imported into Access? That's the way I would go here if I could get a buyin. mdb files are a proprietary format, and there's precious little software around that will muck with them outside of an Access system. -- -Mark Wieder [EMAIL PROTECTED] ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
It would be nice if there was a way to convert access databases to SQLite. On 12/5/06 3:57 PM, "Mikey" <[EMAIL PROTECTED]> wrote: > Unfortunately that isn't a solution. This is going to be a project > that is going to replace an embedded Access database, so access to > Access is negatory. ||| )_) )_) )_) )___))___))___)\ )))_)\\ _|||\\\__ ---\ /- http://www.bluewatermaritime.com ^ ^ ^^^^^ ^^^ 24 hour cell: (787) 378-6190 fax: (787) 809-8426 Blue Water Maritime P.O. Box 2087 Rio Grande, PR 00745 ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
Unfortunately that isn't a solution. This is going to be a project that is going to replace an embedded Access database, so access to Access is negatory. -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Access Plugins
Hi Mikey, You can always connect to Access databases via ODBC - setup a DSN and open a connection to it. If you need to create new .mdb files, it's a little trickier as you'd have to create an empty .mdb file, duplicate that, create a DSN on the fly and then manipulate it from Revolution. Good luck, Jan Schenkel. Quartam Reports for Revolution <http://www.quartam.com> = "As we grow older, we grow both wiser and more foolish at the same time." (La Rochefoucauld) - Original Message From: Mikey <[EMAIL PROTECTED]> To: How to use Revolution Sent: Tuesday, December 5, 2006 8:08:45 PM Subject: Access Plugins All, I have a really interesting project that I'm going to be starting here shortly, but it has a problem - I need to be able to generate Access database files as output (and then zip them). I'd love to be able to do this one in RR, because there will be a significant amount of parsing, and chunk expressions are SO perfect for that. However, if I can't use RR to (easily) generate .mdb files then I'm going to be forced to use one of the other tools at my disposal. Suggestions? Mike. -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution Want to start your own business? Learn how on Yahoo! Small Business. http://smallbusiness.yahoo.com/r-index ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Access Plugins
All, I have a really interesting project that I'm going to be starting here shortly, but it has a problem - I need to be able to generate Access database files as output (and then zip them). I'd love to be able to do this one in RR, because there will be a significant amount of parsing, and chunk expressions are SO perfect for that. However, if I can't use RR to (easily) generate .mdb files then I'm going to be forced to use one of the other tools at my disposal. Suggestions? Mike. -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution