Re: SQL update in SQL database issue
- From: "swdev2" <wsanders@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 1 May 2006 01:21:26 -0600
You could always switch to a postGreSql backend ...
or mySql backend.
Keep VFP for your front end and reports.
In either instance, you can control lots of things with vfp's spt commands.
I prefer postGreSql over mySql - the price is right PLUS you can do some
fairly complex stored procs.
I would not use Access for anything - it's an end-user toy and not useful
for real-world deployment of company mission-critical systems.
It's popular because MS linked it so well to VB (yarrrgh).
If you want to go even smaller use FireBird SQL.
good luck !
regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net
"Tsair" <lstsair@xxxxxxxxx> wrote in message
news:emXuKo0aGHA.5000@xxxxxxxxxxxxxxxxxxxxxxx
Thank you for all your reply,how
I am thinking if i change the database from Foxpro to SQL or MS Access,
does the easy way to support the database ?mapping
I am satisfy the Foxpro database in term of easy to support, no 3rd party
program installation require, if a table corrupted, user can just attach
that table and email to us for recovering, no database tuning require, no
additional database cost, no additional report writer cost, Foxpro Report
writer is power, easy workstation installation, just do the network
for file server sharing.command
The main concern is the concurrent access of the database in File Server
Sharing. the speed of database update is slow, i use the normal USE
to open the table and REPLACE command to update the table.write
Is that any technique to solve the speed problem.
should I use SQL pass through command to update the Foxpro Database or
the update command in Store Procedure or using LOCAL VIEW to update thedisk
database?
IF I access the Remote SQL Database, does REMOTE VIEW will process faster
than using SQL Command to retrieve or update data or should I use Cursor
Adaptor ?
Currently, Anywhere are talking .NET, how does the Foxpro going to be ?
I am trying the C# .NET, I don't like the application installation, it
prerequire IE Explorer 6.0, MS SQL Express, Windows Installer 3.1 above,
.NET Framework 2.0. Total installation take about more that 200MB hard
space, my application just 2 MB.
.
- Follow-Ups:
- Re: SQL update in SQL database issue
- From: Tsair
- Re: SQL update in SQL database issue
- Prev by Date: Re: strange problem with remote view
- Next by Date: Re: Reading the Registry
- Previous by thread: Re: Problem using Dreamweaver 8 and Visual Foxpro OLEDB
- Next by thread: Re: SQL update in SQL database issue
- Index(es):
Relevant Pages
|
