[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

Re: Using Vruby instead of VB ?

Berger, Daniel

11/23/2003 2:58:00 PM

> -----Original Message-----
> From: Shashank Date [mailto:sdate@everestkc.net]
> Sent: Saturday, November 22, 2003 1:37 PM
> To: ruby-talk ML
> Subject: Using Vruby instead of VB ?
>
>
> Inspired by Steve's presentation at RubyConf-2003, (
> thanks to zenspider, see:
>
> Steve Tuckner: Ruby World: (Not) Implemented
> www.zenspider.com /dl /rubyconf2003 /RubyNotImplemented.tar.gz
> )
>
> I am looking at the possibility of using Vruby/Swin instead
> of VisualBasic to develop a small (commercial) application on
> Windows. This application has
> to:
>
> 1. Have native (Windows) look and feel

I *think* Vruby/Swin will give you that from what I've read. I haven't
actually tried it. I'm a bit concerned that the author says his
development environment is Windows 98, but perhaps it's a non-issue.

> 2. Interface with MS Access (possibly with MS SQL Server2K in
> future)

I *thought* you could use ODBC to interface with MS Access, but I'm not
positive. Otherwise, it ought to be possible via OLE (right?). There's
no specific DBD for either Access or SQL Server that I know of.

>3. Print reports in landscape and portrait mode

Eek - now you're talking hardware interfaces - way out of my realm.

>4. Run only on one machine (no networking etc)

Simple enough - don't create any sockets or pipes that would allow
networking. :)

>
> With Steve Tuckner, Dan Berger, Park Heesob and many other
> Win / Ruby experts on my side, I feel like taking the risk ;-)
>
> What do Rubyists have to say ? Any gotchas I need to be aware of ?
>
> -- shanko

We'll help as we can, I'm sure. :)

Regards

Dan

5 Answers

Shashank Date

11/23/2003 5:49:00 PM

0

Hi,

> I *think* Vruby/Swin will give you that from what I've read. I haven't
> actually tried it. I'm a bit concerned that the author says his
> development environment is Windows 98, but perhaps it's a non-issue.

Yes, Vruby/swin gives that , and Win 98 is a non-issue (yet).

> > 2. Interface with MS Access (possibly with MS SQL Server2K in
> > future)
>
> I *thought* you could use ODBC to interface with MS Access, but I'm not
> positive. Otherwise, it ought to be possible via OLE (right?). There's
> no specific DBD for either Access or SQL Server that I know of.

Yes, I will use ODBC (or OLEDB, whichever turns out to be easier ;-)).
ODBC Performance is not a big issue yet since the database is very small.

> >3. Print reports in landscape and portrait mode
>
> Eek - now you're talking hardware interfaces - way out of my realm.

The feature list on this website says something about "using printer with
swin"
http://www.osk.3web.ne.jp/~nyasu/vruby/vrproject-e.ht...

I will have to find out what it is all about. (if only I could
read/understand
Japanese ... sigh)

> >4. Run only on one machine (no networking etc)
>
> Simple enough - don't create any sockets or pipes that would allow
> networking. :)

Yes :-)

And I spent about an hour installing the "nifty" FormDesigner:

http://homepage3.nifty.com/Yukimi_Sake...

But it is worth the pain. Will keep you posted.

> We'll help as we can, I'm sure. :)
> Dan

Thanks Dan.
-- shanko


daz

11/24/2003 4:40:00 AM

0


"Shashank Date" wrote:
> Hi,
>
>
> 3. Print reports in landscape and portrait mode
>
> The feature list on this website says something about "using printer with swin"
>


http://www.threeweb.ad.jp/~nyasu/vruby/samp...
(labeled "using priner" - which probably defeats Google)
^t

.... refers to the author's sample printer script:
http://www.threeweb.ad.jp/~nyasu/vruby/sample/...

---

If you do use Win32OLE to script MS Access, OLE printing should be usable also ?

Wiki references for /other/ MS Office apps.
http://www.rubygarden.org/ruby?Script...
http://www.rubygarden.org/ruby?Scri...


Of possible interest (from Access/VBA help):

PrintOut method -
.PrintOut [printrange][, pagefrom, pageto][, printquality][, copies][, collatecopies]

PrtDevMode property - [Orientation] member (amongst others)
An Integer that specifies the orientation of the paper.
It can be either 1 (portrait) or 2 (landscape).



Haven't played this; good luck,


daz



zoranlazarevic

11/24/2003 3:48:00 PM

0

> > 2. Interface with MS Access (possibly with MS SQL Server2K in
> > future)

I used ODBC with free download of Microsoft Data Access Components
(mdac_typ.exe) and I was able to create/update/select Access tables,
even though I don't have Access installed.

http://www.microsoft.com/downloads/results.aspx?fre...

--Laza

Shashank Date

11/25/2003 2:13:00 AM

0


"Zoran Lazarevic" <zoranlazarevic@yahoo.com> wrote in message
> (mdac_typ.exe) and I was able to create/update/select Access tables,
> even though I don't have Access installed.
>
> http://www.microsoft.com/downloads/results.aspx?fre...

Thanks for the link. Which version of ruby and MDAC did you work on ?


zoranlazarevic

11/25/2003 8:32:00 PM

0

> Thanks for the link. Which version of ruby and MDAC did you work on ?

I am using Ruby 1.8.0 and the latest download of MDAC 2.8 as of two weeks ago.

--Laza