Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #13054 > unrolled thread

Step forward DBF/VO -> SQL/?

Started by"Grzegorz R." <ramotny64@gmail.com>
First post2020-09-04 02:42 -0700
Last post2020-09-04 07:53 -0700
Articles 14 — 6 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Step forward DBF/VO -> SQL/? "Grzegorz R." <ramotny64@gmail.com> - 2020-09-04 02:42 -0700
    Re: Step forward DBF/VO -> SQL/? Danilo Giuliani <softdevo@tiscali.it> - 2020-09-04 12:17 +0200
    Re: Step forward DBF/VO -> SQL/? "Wolfgang Riedmann" <wriedmann@gmail.com> - 2020-09-04 14:53 +0200
      Re: Step forward DBF/VO -> SQL/? "Grzegorz R." <ramotny64@gmail.com> - 2020-09-04 07:54 -0700
        Re: Step forward DBF/VO -> SQL/? Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2020-09-04 17:23 +0200
          Re: Step forward DBF/VO -> SQL/? "Grzegorz R." <ramotny64@gmail.com> - 2020-09-04 08:32 -0700
          Re: Step forward DBF/VO -> SQL/? "Grzegorz R." <ramotny64@gmail.com> - 2020-09-04 09:05 -0700
          Re: Step forward DBF/VO -> SQL/? "Grzegorz R." <ramotny64@gmail.com> - 2020-09-09 23:30 -0700
            Re: Step forward DBF/VO -> SQL/? Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2020-09-10 15:28 +0200
              Re: Step forward DBF/VO -> SQL/? "Grzegorz R." <ramotny64@gmail.com> - 2020-09-10 09:05 -0700
                Re: Step forward DBF/VO -> SQL/? Frans Wauters <info@wautersit.com> - 2020-09-10 09:36 -0700
                  Re: Step forward DBF/VO -> SQL/? "Grzegorz R." <ramotny64@gmail.com> - 2020-09-11 07:14 -0700
    Re: Step forward DBF/VO -> SQL/? Robert Pope <cooeee@gmail.com> - 2020-09-04 07:33 -0700
      Re: Step forward DBF/VO -> SQL/? Robert Pope <cooeee@gmail.com> - 2020-09-04 07:53 -0700

#13054 — Step forward DBF/VO -> SQL/?

From"Grzegorz R." <ramotny64@gmail.com>
Date2020-09-04 02:42 -0700
SubjectStep forward DBF/VO -> SQL/?
Message-ID<1363cefb-9820-4c23-b248-125bb56ae4can@googlegroups.com>
Dear Friends
Sorry for a little long intro but must present background of this topic...

I started programming in Clipper late 90's (and then went to VO - now 2.8sp4 + bBrowser 4) because there was no software for my trade company that at affordable price could do what I wanted.
Still I do not earn from programming - it more hobby than profession alhough there was short period when I considered selling my soft but it never reached "foolproofness" necessary for being sold.
After years I finally reached end of capabilities of DBF and decided to step forward, abandon DBF and go to SQL (also becasue I want to integrate external files like graphics and pdf in database).
I'm not really afraid of new langauge and enviroinment but obvoisly would be great if it could not be to far from VO. It would save me a lot of time if I could tranfer my current soft with only litte adaptation/rewrite. I also know C a little but am not very advanced and interfacing C to VO is a mystery for me.
Therefore I would like to ask You for suggesion/hint where should I go to have possibility of:
- sending emails directly from program or interfacing it with Thundebird
- generating PDF docs
- get access do database from outside world (field salesmen)
Should it be X#? How to make transition as smooth as possible?

Any help is greatly appreciated...

Gregory

[toc] | [next] | [standalone]


#13055

FromDanilo Giuliani <softdevo@tiscali.it>
Date2020-09-04 12:17 +0200
Message-ID<rit474$1blh$1@gioia.aioe.org>
In reply to#13054
Hi, first you should decide which database to use.
Personally I have used Mysql for years, but since it was bought by 
Oracle I don't like it much anymore so for about two years I switched to 
MariaDB.
MariaDB is developed by the same team that wrote Mysql at the time and 
has now reached a remarkable maturity.
To access the data from XSharp you can use the mysql.data.dll dll for 
the Famework version of mysql 5.7.
For the rest with Xsharp I don't think you will have any problems.

Danilo

[toc] | [prev] | [next] | [standalone]


#13056

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2020-09-04 14:53 +0200
Message-ID<hrermjFgocfU1@mid.individual.net>
In reply to#13054
Hi Gregory,

I would go the route of X#, it is the easiest, and there is also a free
version of it.

Regarding the database: we have experience with many databases,
including Advantage Database Server, and we use PostgreSQL when we have
the liberty of choice (sometimes the database is decided by our
customer or there is already one present so we need to use that).
PostgreSQL is free and really powerful and runs on both Windows and
Linux machines.

Wolfgang

Grzegorz R. wrote:

> Dear Friends
> Sorry for a little long intro but must present background of this
> topic...
> 
> I started programming in Clipper late 90's (and then went to VO - now
> 2.8sp4 + bBrowser 4) because there was no software for my trade
> company that at affordable price could do what I wanted.  Still I do
> not earn from programming - it more hobby than profession alhough
> there was short period when I considered selling my soft but it never
> reached "foolproofness" necessary for being sold.  After years I
> finally reached end of capabilities of DBF and decided to step
> forward, abandon DBF and go to SQL (also becasue I want to integrate
> external files like graphics and pdf in database).  I'm not really
> afraid of new langauge and enviroinment but obvoisly would be great
> if it could not be to far from VO. It would save me a lot of time if
> I could tranfer my current soft with only litte adaptation/rewrite. I
> also know C a little but am not very advanced and interfacing C to VO
> is a mystery for me.  Therefore I would like to ask You for
> suggesion/hint where should I go to have possibility of:  - sending
> emails directly from program or interfacing it with Thundebird -
> generating PDF docs - get access do database from outside world
> (field salesmen) Should it be X#? How to make transition as smooth as
> possible?
> 
> Any help is greatly appreciated...
> 
> Gregory



-- 

[toc] | [prev] | [next] | [standalone]


#13060

From"Grzegorz R." <ramotny64@gmail.com>
Date2020-09-04 07:54 -0700
Message-ID<f338906a-d997-4418-ab6a-596e7b3b8bd7n@googlegroups.com>
In reply to#13056
piątek, 4 września 2020 o 14:53:43 UTC+2 Wolfgang Riedmann napisał(a):
> Hi Gregory, 
> 
> I would go the route of X#, it is the easiest, and there is also a free 
> version of it. 
> 
> Regarding the database: we have experience with many databases, 
> including Advantage Database Server, and we use PostgreSQL when we have 
> the liberty of choice (sometimes the database is decided by our 
> customer or there is already one present so we need to use that). 
> PostgreSQL is free and really powerful and runs on both Windows and 
> Linux machines. 
> 
> Wolfgang
> Grzegorz R. wrote: 
> 
> > Dear Friends 
> > Sorry for a little long intro but must present background of this 
> > topic... 
> > 
> > I started programming in Clipper late 90's (and then went to VO - now 
> > 2.8sp4 + bBrowser 4) because there was no software for my trade 
> > company that at affordable price could do what I wanted. Still I do 
> > not earn from programming - it more hobby than profession alhough 
> > there was short period when I considered selling my soft but it never 
> > reached "foolproofness" necessary for being sold. After years I 
> > finally reached end of capabilities of DBF and decided to step 
> > forward, abandon DBF and go to SQL (also becasue I want to integrate 
> > external files like graphics and pdf in database). I'm not really 
> > afraid of new langauge and enviroinment but obvoisly would be great 
> > if it could not be to far from VO. It would save me a lot of time if 
> > I could tranfer my current soft with only litte adaptation/rewrite. I 
> > also know C a little but am not very advanced and interfacing C to VO 
> > is a mystery for me. Therefore I would like to ask You for 
> > suggesion/hint where should I go to have possibility of: - sending 
> > emails directly from program or interfacing it with Thundebird - 
> > generating PDF docs - get access do database from outside world 
> > (field salesmen) Should it be X#? How to make transition as smooth as 
> > possible? 
> > 
> > Any help is greatly appreciated... 
> > 
> > Gregory
> --
Hello Wolfgang
thank You (and Danilo of course) for quick replies.
I forgot to write that now I use simple QNAP NAS as a DBF file "server" with VO app on each client PC.
On QNAP there is a MySQL which I could use (I already made a test database with MyPHPAdmin but can't access it from VO) - question is if I'm able to connect to it easily with X#.
PostgreSQL is nice idea but I do not know if it exist for QNAP or what hardware do I need. On this field I'm fresh as a grass in spring.
Company is small - just 5 persons so no any huge server is needed but want to move from file server to app server.
By "free X#" you mean that: https://www.xsharp.info/itm-downloads/download?path=installers%252FXSharpSetup25bPublic.zip ?
Best regards
Gregory
PS: it's not big deal to pay for soft if only I get what I need

[toc] | [prev] | [next] | [standalone]


#13061

FromKarl Faller <mail_withoutthat_@_drei-f_andthat_.de>
Date2020-09-04 17:23 +0200
Message-ID<ndm4lfd16erish42tbfiq4ma8cgtqnis8f@4ax.com>
In reply to#13060
On Fri, 4 Sep 2020 07:54:36 -0700 (PDT), Grzegorz R. wrote:

Greg,
>I forgot to write that now I use simple QNAP NAS as a DBF file "server" with VO app on each client PC.
>On QNAP there is a MySQL which I could use (I already made a test database with MyPHPAdmin but can't access it from VO) - question is if I'm able to connect to it easily with X#.
>PostgreSQL is nice idea but I do not know if it exist for QNAP or what hardware do I need. On this field I'm fresh as a grass in spring.
If MySql runs, Postgre will, too. I only ever "play" with it, but i
run on my desktop machine 4 versions of PG and don't notice their
existance ;)
Get you the installer, it won't be more than five minutes to get you
running. 


>By "free X#" you mean that: https://www.xsharp.info/itm-downloads/download?path=installers%252FXSharpSetup25bPublic.zip ?
Yes. Free as free beer. If you want to enter FriendsOfXSharp to
support continuing development and get direct suppport from Dev, you
may. 
But to see what'll you get, fetch the install. The "free" version
doesn't give access to compiler source code and may miss some
optimazations, (you won't notice this) - apart from that it is the
full thing. 
Not the least: it comes with XIDE, an IDE written by Chris P. of Dev
in XSharp, which is really not far from VO-IDE.

There's nothing to loose - give it a try for a weekend or two ;-)
Regards

Karl

[toc] | [prev] | [next] | [standalone]


#13062

From"Grzegorz R." <ramotny64@gmail.com>
Date2020-09-04 08:32 -0700
Message-ID<8c7d8661-ec10-4b1d-b27a-b6f5020f71ban@googlegroups.com>
In reply to#13061
piątek, 4 września 2020 o 17:23:09 UTC+2 Karl Faller napisał(a):
> On Fri, 4 Sep 2020 07:54:36 -0700 (PDT), Grzegorz R. wrote: 
> 
> Greg,
> >I forgot to write that now I use simple QNAP NAS as a DBF file "server" with VO app on each client PC. 
> >On QNAP there is a MySQL which I could use (I already made a test database with MyPHPAdmin but can't access it from VO) - question is if I'm able to connect to it easily with X#. 
> >PostgreSQL is nice idea but I do not know if it exist for QNAP or what hardware do I need. On this field I'm fresh as a grass in spring.
> If MySql runs, Postgre will, too. I only ever "play" with it, but i 
> run on my desktop machine 4 versions of PG and don't notice their 
> existance ;) 
> Get you the installer, it won't be more than five minutes to get you 
> running.
> >By "free X#" you mean that: https://www.xsharp.info/itm-downloads/download?path=installers%252FXSharpSetup25bPublic.zip ?
> Yes. Free as free beer. If you want to enter FriendsOfXSharp to 
> support continuing development and get direct suppport from Dev, you 
> may. 
> But to see what'll you get, fetch the install. The "free" version 
> doesn't give access to compiler source code and may miss some 
> optimazations, (you won't notice this) - apart from that it is the 
> full thing. 
> Not the least: it comes with XIDE, an IDE written by Chris P. of Dev 
> in XSharp, which is really not far from VO-IDE. 
> 
> There's nothing to loose - give it a try for a weekend or two ;-) 
> Regards 
> 
> Karl
Hello Karl
I installed and have XIDE :)
Now - how can I import my old VO app? Copy-paste source code or is there any import tool/converter )from AEF/MEF)?
Gregory

[toc] | [prev] | [next] | [standalone]


#13063

From"Grzegorz R." <ramotny64@gmail.com>
Date2020-09-04 09:05 -0700
Message-ID<92348490-2192-4880-815b-2b02a5929aa1n@googlegroups.com>
In reply to#13061
piątek, 4 września 2020 o 17:23:09 UTC+2 Karl Faller napisał(a):
> On Fri, 4 Sep 2020 07:54:36 -0700 (PDT), Grzegorz R. wrote: 
> 
> Greg,
> >I forgot to write that now I use simple QNAP NAS as a DBF file "server" with VO app on each client PC. 
> >On QNAP there is a MySQL which I could use (I already made a test database with MyPHPAdmin but can't access it from VO) - question is if I'm able to connect to it easily with X#. 
> >PostgreSQL is nice idea but I do not know if it exist for QNAP or what hardware do I need. On this field I'm fresh as a grass in spring.
> If MySql runs, Postgre will, too. I only ever "play" with it, but i 
> run on my desktop machine 4 versions of PG and don't notice their 
> existance ;) 
> Get you the installer, it won't be more than five minutes to get you 
> running.
> >By "free X#" you mean that: https://www.xsharp.info/itm-downloads/download?path=installers%252FXSharpSetup25bPublic.zip ?
> Yes. Free as free beer. If you want to enter FriendsOfXSharp to 
> support continuing development and get direct suppport from Dev, you 
> may. 
> But to see what'll you get, fetch the install. The "free" version 
> doesn't give access to compiler source code and may miss some 
> optimazations, (you won't notice this) - apart from that it is the 
> full thing. 
> Not the least: it comes with XIDE, an IDE written by Chris P. of Dev 
> in XSharp, which is really not far from VO-IDE. 
> 
> There's nothing to loose - give it a try for a weekend or two ;-) 
> Regards 
> 
> Karl
Hello Karl,
got my new XIDE and learn to use it. Next will be VOPorter and VO-X# migration.
Will report back soon
Have nice weekend
Best regards
Gregory

[toc] | [prev] | [next] | [standalone]


#13072

From"Grzegorz R." <ramotny64@gmail.com>
Date2020-09-09 23:30 -0700
Message-ID<e002e6d9-fb3d-4fe2-a427-4487701ed5e6n@googlegroups.com>
In reply to#13061
piątek, 4 września 2020 o 17:23:09 UTC+2 Karl Faller napisał(a):
> On Fri, 4 Sep 2020 07:54:36 -0700 (PDT), Grzegorz R. wrote: 
> 
> Greg,
> >I forgot to write that now I use simple QNAP NAS as a DBF file "server" with VO app on each client PC. 
> >On QNAP there is a MySQL which I could use (I already made a test database with MyPHPAdmin but can't access it from VO) - question is if I'm able to connect to it easily with X#. 
> >PostgreSQL is nice idea but I do not know if it exist for QNAP or what hardware do I need. On this field I'm fresh as a grass in spring.
> If MySql runs, Postgre will, too. I only ever "play" with it, but i 
> run on my desktop machine 4 versions of PG and don't notice their 
> existance ;) 
> Get you the installer, it won't be more than five minutes to get you 
> running.
> >By "free X#" you mean that: https://www.xsharp.info/itm-downloads/download?path=installers%252FXSharpSetup25bPublic.zip ?
> Yes. Free as free beer. If you want to enter FriendsOfXSharp to 
> support continuing development and get direct suppport from Dev, you 
> may. 
> But to see what'll you get, fetch the install. The "free" version 
> doesn't give access to compiler source code and may miss some 
> optimazations, (you won't notice this) - apart from that it is the 
> full thing. 
> Not the least: it comes with XIDE, an IDE written by Chris P. of Dev 
> in XSharp, which is really not far from VO-IDE. 
> 
> There's nothing to loose - give it a try for a weekend or two ;-) 
> Regards 
> 
> Karl
Hello Karl
XIDE installed and tried to start simple project - one window with one button and...
"error XS0234: The type or namespace name 'Forms' does not exist in the namespace 'System.Windows' (are you missing an assembly reference?)	5,36	Form1.prg	Form1:Form1
Compilation failed (1 error)"
this is what XIDE created: CLASS Form1 INHERIT System.Windows.Forms.Form
What did I wrong?
Gregory

[toc] | [prev] | [next] | [standalone]


#13073

FromKarl Faller <mail_withoutthat_@_drei-f_andthat_.de>
Date2020-09-10 15:28 +0200
Message-ID<t4aklf5vlapogj16lc0uoo0pdg4q745cb8@4ax.com>
In reply to#13072
Gregory,
you don't say, what you did exactly.
First of all, did you grok the difference between "empty project" and
regular ones? The former serves as a container for "one prg"
applications. There you'll have to add any necessary references by
hand. 

Much easier:
First of all, do a "select project" - best by right click in the
explorer pane, and there  "New" - say, "Playground" or whatever.
Then, again, right click, "new application" - basic x#form
Open the form prg. Add your button, CTRL-S, F5 et voila ;)





>pi?tek, 4 wrze?nia 2020 o 17:23:09 UTC+2 Karl Faller napisa?(a):
>> On Fri, 4 Sep 2020 07:54:36 -0700 (PDT), Grzegorz R. wrote: 
>> 
>> Greg,
>> >I forgot to write that now I use simple QNAP NAS as a DBF file "server" with VO app on each client PC. 
>> >On QNAP there is a MySQL which I could use (I already made a test database with MyPHPAdmin but can't access it from VO) - question is if I'm able to connect to it easily with X#. 
>> >PostgreSQL is nice idea but I do not know if it exist for QNAP or what hardware do I need. On this field I'm fresh as a grass in spring.
>> If MySql runs, Postgre will, too. I only ever "play" with it, but i 
>> run on my desktop machine 4 versions of PG and don't notice their 
>> existance ;) 
>> Get you the installer, it won't be more than five minutes to get you 
>> running.
>> >By "free X#" you mean that: https://www.xsharp.info/itm-downloads/download?path=installers%252FXSharpSetup25bPublic.zip ?
>> Yes. Free as free beer. If you want to enter FriendsOfXSharp to 
>> support continuing development and get direct suppport from Dev, you 
>> may. 
>> But to see what'll you get, fetch the install. The "free" version 
>> doesn't give access to compiler source code and may miss some 
>> optimazations, (you won't notice this) - apart from that it is the 
>> full thing. 
>> Not the least: it comes with XIDE, an IDE written by Chris P. of Dev 
>> in XSharp, which is really not far from VO-IDE. 
>> 
>> There's nothing to loose - give it a try for a weekend or two ;-) 
>> Regards 
>> 
>> Karl
>Hello Karl
>XIDE installed and tried to start simple project - one window with one button and...
>"error XS0234: The type or namespace name 'Forms' does not exist in the namespace 'System.Windows' (are you missing an assembly reference?)	5,36	Form1.prg	Form1:Form1
>Compilation failed (1 error)"
>this is what XIDE created: CLASS Form1 INHERIT System.Windows.Forms.Form
>What did I wrong?
>Gregory
Regards

Karl

[toc] | [prev] | [next] | [standalone]


#13077

From"Grzegorz R." <ramotny64@gmail.com>
Date2020-09-10 09:05 -0700
Message-ID<28191677-9141-4528-a38e-21f8f54810ccn@googlegroups.com>
In reply to#13073
czwartek, 10 września 2020 o 15:28:43 UTC+2 Karl Faller napisał(a):
> Gregory, 
> you don't say, what you did exactly. 
> First of all, did you grok the difference between "empty project" and 
> regular ones? The former serves as a container for "one prg" 
> applications. There you'll have to add any necessary references by 
> hand. 
> 
> Much easier: 
> First of all, do a "select project" - best by right click in the 
> explorer pane, and there "New" - say, "Playground" or whatever. 
> Then, again, right click, "new application" - basic x#form 
> Open the form prg. Add your button, CTRL-S, F5 et voila ;) 
> 
> 
> 
> 
> 
> >pi?tek, 4 wrze?nia 2020 o 17:23:09 UTC+2 Karl Faller napisa?(a):
> >> On Fri, 4 Sep 2020 07:54:36 -0700 (PDT), Grzegorz R. wrote: 
> >> 
> >> Greg, 
> >> >I forgot to write that now I use simple QNAP NAS as a DBF file "server" with VO app on each client PC. 
> >> >On QNAP there is a MySQL which I could use (I already made a test database with MyPHPAdmin but can't access it from VO) - question is if I'm able to connect to it easily with X#. 
> >> >PostgreSQL is nice idea but I do not know if it exist for QNAP or what hardware do I need. On this field I'm fresh as a grass in spring. 
> >> If MySql runs, Postgre will, too. I only ever "play" with it, but i 
> >> run on my desktop machine 4 versions of PG and don't notice their 
> >> existance ;) 
> >> Get you the installer, it won't be more than five minutes to get you 
> >> running. 
> >> >By "free X#" you mean that: https://www.xsharp.info/itm-downloads/download?path=installers%252FXSharpSetup25bPublic.zip ? 
> >> Yes. Free as free beer. If you want to enter FriendsOfXSharp to 
> >> support continuing development and get direct suppport from Dev, you 
> >> may. 
> >> But to see what'll you get, fetch the install. The "free" version 
> >> doesn't give access to compiler source code and may miss some 
> >> optimazations, (you won't notice this) - apart from that it is the 
> >> full thing. 
> >> Not the least: it comes with XIDE, an IDE written by Chris P. of Dev 
> >> in XSharp, which is really not far from VO-IDE. 
> >> 
> >> There's nothing to loose - give it a try for a weekend or two ;-) 
> >> Regards 
> >> 
> >> Karl 
> >Hello Karl 
> >XIDE installed and tried to start simple project - one window with one button and... 
> >"error XS0234: The type or namespace name 'Forms' does not exist in the namespace 'System.Windows' (are you missing an assembly reference?) 5,36 Form1.prg Form1:Form1 
> >Compilation failed (1 error)" 
> >this is what XIDE created: CLASS Form1 INHERIT System.Windows.Forms.Form 
> >What did I wrong? 
> >Gregory
> Regards 
> 
> Karl
Hello Karl,
sorry for being to short...
I followed Your suggestion and of course it worked and I got my first working app & form. THANK YOU! (You have a first beer at me) :)
Now - is there any "big book" (Almanach) for X# to learn all language specific like VO had?
Does X# work with bBrowser or I will not need that because X# already has same/silmilar/better object? (I played a little with calendar and already love it)
Where should I start to learn X#? Are there examples? Can You push me in the right direction?

Regards
Gregory

[toc] | [prev] | [next] | [standalone]


#13079

FromFrans Wauters <info@wautersit.com>
Date2020-09-10 09:36 -0700
Message-ID<40a8576f-3428-4100-95b4-f283f019acdfn@googlegroups.com>
In reply to#13077
Hi Gregory,

Take a look at:
https://docs.xsharp.it/doku.php
Documentation - https://www.xsharp.info/help/index.html
https://www.xsharp.info/itm-help

Regads,
Frans

[toc] | [prev] | [next] | [standalone]


#13082

From"Grzegorz R." <ramotny64@gmail.com>
Date2020-09-11 07:14 -0700
Message-ID<2122293d-30c8-4153-8ca5-0bb50c3e2a86n@googlegroups.com>
In reply to#13079
czwartek, 10 września 2020 o 18:36:17 UTC+2 in...@wautersit.com napisał(a):
> Hi Gregory, 
> 
> Take a look at: 
> https://docs.xsharp.it/doku.php 
> Documentation - https://www.xsharp.info/help/index.html 
> https://www.xsharp.info/itm-help 
> 
> Regads, 
> Frans
Hello Again
I played a little with X# and see that a LOT of work is ahead of me.
Now:
1. in VO I used bBrowser - if I'm rewriting the app should I stick with bB (and purchase .NET version) or does it make sense to change to available tool like datagrid?

2. I have QNAP running MySQL which is visible for myPHP or MySQLAdmin but do not see it in VisualStudio (can not connect and is not detected by VS). 
Maybe it's bad idea to use QNAP + MySQL as SQL server? What do I need to connect X# to QNAP's MySQL?

Any help including links to an kind of help is greatly appreciated

Best regards
Gregory

[toc] | [prev] | [next] | [standalone]


#13058

FromRobert Pope <cooeee@gmail.com>
Date2020-09-04 07:33 -0700
Message-ID<1b129025-cc1d-4dc9-8729-ff0427cd25e8o@googlegroups.com>
In reply to#13054
If you wanted to stick with VO... (I'm not trying to argue that you should, or shouldn't).

> After years I finally reached end of capabilities of DBF and decided to step forward, abandon DBF and go to SQL (also becasue I want to integrate external files like graphics and pdf in database).

We use Advantage Database Server, which runs with your DBF files but lets you run SQL too. Maybe see if you can get your hands on a trial version of that. If you have too much trouble getting v12, give v11 a try. I think if you download the main server and install it, you'll get a 30 day trial: https://devzone.advantagedatabase.com/dz/content.aspx?Key=20&Release=19

> I also know C a little but am not very advanced and interfacing C to VO is a mystery for me.

I don't think interfacing to C/C++ is too difficult. You may have done it in the past and not realized. For example, the following is a VO definition for an external (kernel32.dll) C/C++ function.

_DLL FUNC GetDiskFreeSpace(lpRootPathName AS PSZ, lpSectorsPerCluster AS DWORD PTR, lpBytesPerSector AS DWORD PTR, lpNumberOfFreeClusters AS DWORD PTR, lpTotalNumberOfClusters AS DWORD PTR) AS LOGIC PASCAL:KERNEL32.GetDiskFreeSpaceA

You'd basically link to your C/C++ program through definitions like the above. You'll need to have fairly primitive data types between the two though, no passing objects and such.

> Therefore I would like to ask You for suggesion/hint where should I go to have possibility of:
> - sending emails directly from program or interfacing it with Thundebird

If I had to do that, I would look into using sockets to interface directly with the SMTP server. The language is pretty basic: https://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol#SMTP_transport_example

I haven't ever used it, but VO has a CSmtp class that might do a lot of the work for you.

> - generating PDF docs

If what you want to do is simple, you could try a print-to-pdf driver (e.g. FoxIt, PrimoPDF, PDFCreator, etc). You probably don't need to change your VO code.

> - get access do database from outside world (field salesmen)

ADS allows that with your existing DBF files.

[toc] | [prev] | [next] | [standalone]


#13059

FromRobert Pope <cooeee@gmail.com>
Date2020-09-04 07:53 -0700
Message-ID<c412f3d1-68b6-4db5-afda-0a325a41d911o@googlegroups.com>
In reply to#13058
On Saturday, September 5, 2020 at 12:33:13 AM UTC+10, Robert Pope wrote:
> If I had to do that, I would look into using sockets to interface directly with the SMTP server. The language is pretty basic: https://en.wikipedia.org/wiki/Simple_Mail_Transfer_Protocol#SMTP_transport_example

I just saw the other thread on problems with SMTP (port 25) and encryption. Maybe defer to that thread for solutions to this problem.

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web