Prev: Crystal Report "Basic syntax not supported"
Next: Wildseek doesn't work with memo-fields
From: G Schaller on 7 Jan 2007 15:33
Rob.

My recommendation would be to avoid the VO SQL classes and use VO2Ado
which comes free in 2.7 - the version of VO is irrelevant, however, for
SQL access. VO2Ado also comes with an RDD that helps you simulate pure
DBF style coding and companies like ours have built full class based
mechanisms to do the same.

I think you are best off with SQL Server 2005, especially as it has a
free version for redistribution. You can even replicate it to the free
version in case your users want to take their databases away or offline.

I have some white papers on SQL conversion and usage on my website and
very soon I will start an RSS feed for VO'ers to help them understand
and use SQL optimally. But this forum will stand here to help you with
coding for SQL.

Cheers,

Geoff



"Erk" <erk.v(a)hotmail.com> wrote in message
news:1168191872.704995.43710(a)s34g2000cwa.googlegroups.com:

> Hello all. For years I have programmed in VO (and previously Clipper)
> and always used the DBF databases (.CDX and NTX) for my applications.
> My main reasons to use VO are the variety of functions and the easyness
> to manipulate data from our end-systems (Windows Server, AS400, etc)
> into a DBF database for the user. However, in the past I have had some
> occassions that our DBF Database had become corrupt and for this reason
> (and because I'am interested to learn more....!!) I would like to learn
> more on how I can work with .SQL databases in VO (how to
> create/maintain them). I wonder if and where I can find the necessary
> documentation about implementing SQL in VO applications. There are not
> a lot of books for VO available but maybe (.... I hope), as starting
> point, someone can provide me with a simple .AEF in which the base
> database functions are included (creating, deleting and updating a
> record). Can someone help me with this? Are there also specific points
> of concern when starting to use SQL in VO?
>
> Kind rgds,
> Rob

From: Willie Moore on 7 Jan 2007 18:24
Rob,

I create my databases from inside the SQL Server Management app that comes
with SQL 2005 or I use viso to draw out my database and let it create the
scripts. Either way works well. When I distribute the app, I send the
database out dependant on who is receiving it. Some clients have their own
IT departments and want scripts, others dont and I ship them an empty
database and have them attach it using SQLMaster (from Software Objectives).

You can use the free version of SQL Express 2005 from Microsoft. It is all
you eed to start working with VO

VO2ADO is on your VO 2.7 CD. I highly recommend it. It supports the
ADORecordset but also a DBServer compatible server called the ADOServer. If
I am using bBrowser on a form, I use the ADOServer, otherwise I use
ADORecordsets. I dont need the notifacation that the ADOServers adds so I
use the lightest weight version.

Regards,

Willie

"Erk" <erk.v(a)hotmail.com> wrote in message
news:1168198667.934602.110030(a)s80g2000cwa.googlegroups.com...
>
> Willie,
>
> I'am using VO 2.7 (I think it is the Professional version. Need to
> check this in the office tomorrow) so will have a look at the CDRom.
> Just some questions:
>
> 1) are you creating a SQL database on the SQL server or within VO 2.7?
> 2) does VO 2.7 work properly with the latest version of SQL Server? Is
> this Windows SQL
> 2005?
> 3) I will build up my own SQL Server (at home) to start working with
> VO. Assume the standard
> build of the SQL Server is sufficient or do I need to add certain
> Windows components on the
> SQL server so that it runs fine with VO?
>
> Sorry for the simple questions.....
>
> Thks,
> Rob
>


From: Paul D B on 8 Jan 2007 04:21
Erk wrote:
> Hello all. For years I have programmed in VO (and previously Clipper)
> and always used the DBF databases (.CDX and NTX) for my applications.
> My main reasons to use VO are the variety of functions and the
> easyness to manipulate data from our end-systems (Windows Server,
> AS400, etc) into a DBF database for the user. However, in the past I
> have had some occassions that our DBF Database had become corrupt and
> for this reason (and because I'am interested to learn more....!!) I
> would like to learn more on how I can work with .SQL databases in VO
> (how to create/maintain them). I wonder if and where I can find the
> necessary documentation about implementing SQL in VO applications.
> There are not a lot of books for VO available but maybe (.... I
> hope), as starting point, someone can provide me with a simple .AEF
> in which the base database functions are included (creating, deleting
> and updating a record). Can someone help me with this? Are there also
> specific points of concern when starting to use SQL in VO?
>
> Kind rgds,
> Rob

if corruption is your major concern then you could also consider using
ADS...
Changes to your application are minimal and you get stable and quite
performant C/S.
But it is expensive.
--
Paul


From: Marc Verkade [Marti IT] on 8 Jan 2007 06:19
when using the real server.
Using local server (like SQL-Express) it is free..
Local server can be used upto 5 users standard (but more if you contact your
sales rep) and stil outperformes standard DBFCDX.
Grtz, Marc

"Paul D B" <polleke(a)NOMORESPAMhnt.be> schreef in bericht
news:45a20d26$0$2689$ba620e4c(a)news.skynet.be...
> Erk wrote:
>> Hello all. For years I have programmed in VO (and previously Clipper)
>> and always used the DBF databases (.CDX and NTX) for my applications.
>> My main reasons to use VO are the variety of functions and the
>> easyness to manipulate data from our end-systems (Windows Server,
>> AS400, etc) into a DBF database for the user. However, in the past I
>> have had some occassions that our DBF Database had become corrupt and
>> for this reason (and because I'am interested to learn more....!!) I
>> would like to learn more on how I can work with .SQL databases in VO
>> (how to create/maintain them). I wonder if and where I can find the
>> necessary documentation about implementing SQL in VO applications.
>> There are not a lot of books for VO available but maybe (.... I
>> hope), as starting point, someone can provide me with a simple .AEF
>> in which the base database functions are included (creating, deleting
>> and updating a record). Can someone help me with this? Are there also
>> specific points of concern when starting to use SQL in VO?
>>
>> Kind rgds,
>> Rob
>
> if corruption is your major concern then you could also consider using
> ADS...
> Changes to your application are minimal and you get stable and quite
> performant C/S.
> But it is expensive.
> --
> Paul
>


From: Erk on 8 Jan 2007 10:37

Thanks to everyone. Sufficient stuff to study I think.......
Brgds, Rob

First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: Crystal Report "Basic syntax not supported"
Next: Wildseek doesn't work with memo-fields