thanks to all
i confident that, i should use vfp, but can u help me for using SQL Server
as back hand?
i am also FoxPro lover and using FoxPor since 15 years.
please help me in 2 points,
1. how to use SQL sever as back hand
2. how to set "SET PROPERTY" for create multi user accounting and inventory
program. or tel me any other necessary commands for multi user programs .
On Jan 18, 2008 12:23 PM, Bernardo Stanfield <[EMAIL PROTECTED]> wrote:
> I would like to share the following. I set up my system VFP 9 with VFP as
> backend at a clients site which had a Pentium 3 PC as a server. The admin
> office PC's were connected to the server by wire and the warehouse by WIFI.
> The performance at the office was very good, not so at the warehouse where
> there was a very noticeable delay on any write. Obvious conclusion; there
> was something wrong with the connection to the warehouse, right? Then the
> client bought a new top line HP server. No big difference in performance at
> the warehouse, all well at the office, same as before. Then we migrated to
> SQL Server 2003 as backend. My system was designed to work with either of
> the two. Bingo, performance at the warehouse was very slightly less than at
> the office. While using VFP as backend, over a 5 month period we had two
> cases of data corruption in the tables which required a restore from the
> nightly back up. Since moving to SQL there has been no data corruption.
> I love VFP and have been using it to make a living since 1988, (with
> FoxPro in DOS) but I try to avoid using it as a backend, especially now with
> the advent of the SQL Server Express which is free up to 4 GB of capacity.
> Best regards.
> Ben Stanfield
>
> ----- Original Message ----
> From: Dave Crozier <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Sent: Friday, January 18, 2008 12:40:26 PM
> Subject: RE: Grid value send to Excel
>
>
> Tanvir,
> 1. VFP Run Slowly
> Firstly if you can find anything to run faster than VFP, please tell me
> -
> short of assembler code. VFP will handle networked installations no
> problem
> at all. The slowness will probably be because of the way the system is
> designed and/or due to the lack of optimization of the data indexes and
> nothing to do with VFP per se.
>
> 2. Lack of Unicode support
> Sorry, but I never get involved with Unicode so I can't help here.
> Maybe
> some others on the list may well like to comment.
>
> 3. Tables corrupt if the power is cut.
> Well the obvious solution is to ensure that the power isn't cut. You
> can
> protect the data to some extent by wrapping any data up into
> "Transactions"
> using basic VFP commands as well as using file buffering (See Andy
> Kramek's
> excellent paper on buffering for more details). Better still, implement
> a
> real client/server solution with proper power protection on the server
> using
> M$SQL or MySQL with VFP as a front end, which it is excellent at.
>
> In any "unstable power" situations, there is always a chance of power
> loss
> whatever language you use so VFP is in no worse a situation than C#, VB
> etc
> etc. The secret is in good design to minimize the potential problems of
> data
> corruption. As the saying goes - rubbish in, rubbish out x 1000.
> However,
> your solution should never be designed to overcome the inadequate
> environment. It is better to solve the underlying problems (eg Power)
> first
> as opposed to programming around it or the problems will never go away,
> just
> get bigger and more frequent. Also you need to look VERY carefully at
> your
> backup procedures in an unstable environment, whatever solution you end
> up
> with.
>
> The only real solution programming wise, to your problems is a better
> in
> depth understanding of the language you are using, be it VB.net, VB, C#
> or
> VFP.
>
> I use all of these languages and VFP comes out the top for speed of
> development and execution. I will continue to use it until a
> better/faster
> solution appears which doesn't involve the vast learning curve of the
> modern
> day languages.
>
> Post away with your problems in the group, there are always people who
> will
> give good unbiased advice and we all have many years of developer
> experience
> for you to call upon.
>
> Ask away.
>
> Dave Crozier
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf
> Of tanvir ahmad
> Sent: 18 January 2008 15:02
> To: ProFox Email List
> Subject: Re: Grid value send to Excel
>
> thanks dave
> i m using vfp-9 i like very much, but i want to switch vb.net, for only
> 3
> problem
>
> 1-vfp run very slow in network or local area network
> 2-it's not support unicode
> 3-it's table has been currupted if power cut sudenly
>
> what can i do. plz give any suggestion
>
> On Jan 18, 2008 2:36 AM, Allen <[EMAIL PROTECTED]> wrote:
>
> > I would normally create a csv file as I go. DataToClip will create
> the
> > data
> > but not headers.
> > I do this a lot to create excel sheets unless I go with automation.
> > scan the table adding values with "," between (dont forget to trim)
> and
> > dtoc
> > dates and the like to a loacl var.
> > Make you column headers first also with "," between.
> > I make this as a var then stringtofile after. (.csv). This can be
> read
> > into
> > excel.
> > Note excel buggers up csv files. It replaces dates with its own type
> for
> > one.
> > Allen
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> > On
> > Behalf Of tanvir ahmad
> > Sent: 18 January 2008 11:17
> > To: [EMAIL PROTECTED]
> > Subject: Re: Grid value send to Excel
> >
> > Thanks Dave
> > u'r advice is working very well but my requirement is sent grid value
> with
> > header caption or report sent to excel.
> >
> > No virus found in this outgoing message.
> > Checked by AVG Free Edition.
> > Version: 7.5.516 / Virus Database: 269.19.6/1230 - Release Date:
> > 17/01/2008
> > 16:59
> >
> >
> >
> >
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
