Recent content by clarkrj

Why not set up an simple error handler. on error do test llContinue = .t. use mytable in 0 on error if !llContinue ?'failed' return endif Proc test llContinue = .f. return Not very elegant but it should work

All my apps have a housekeeping routine that will delete then recreate indexes. It is not allways convienent to run round the country fixing this sort of problem. If you have any calculated tables, it is advisable to recreate these as well.

Hi replace the "append blank & replace" command with "insert"

Hi I tried this a few years ago moving FPD 26 to VFP 6, it was a disaster. There were so many issues to overcome that it would have been quicker to rewrite the app in VFP 6. We ended up with a hybred that was a mess, I would never go down this route again. Richard

Thanks everyone for the help, I have been a bit busy recently & I havn't been able to come onto the forum as often as I would like I now have a very good idea on what approach to take Merry Xmas

I had intended to use ASP to call VFP to create the results file, then display the result in the browser.

Hi Mike I would like to use VFP for searching the stocklist but what has to be "installed" onto the server, to allow the EXE's to run. I intend to use ASP to call VFP with parameters to build the HTML pages.

I need to setup a searchable stocklist on the web. I have no problem in writing the code but I have no experience of using VFP as a com server. Does anyone have the time to list out what is necessary in setting up a windows 2000 server to run the VFP. Thank you

This gets more "interesting" the more I look at it, good job this is for myself not a paying customer. I intend to do my own web hosting from end of August so that these sort of issues can be sorted out. Thanks for all the help, you have really pointed me in the right direction...

This is where I get a bit vague, I am using a hosting service & I believe the web server is running linux. I have changed the properties to read & execute on that directory -- still doesn't work Rich

I am trying to get FOXIS to work with foxisapi.dll as per the help file. I can get it to work in the foxpro enviroment but in my webpage it gives error 404. The command line I have been using is http://www.elmserv.co.uk/test/foxisapi/foxis.employee.startup. This is a totally new subject to...

If you setup your indexes correctly FoxPro is so fast the difference shouldn't be noticable. Unfortunatly some programmers don't & end up buying extra powerfull hardware to compensate for the poor code. If you are using native foxPro tables & the network fails it is possible to corrupt tables...

Hi SQL replication is a black art. Things that you will need to consider Decide who originates what information on a record, when I was looking at this the remote sites originated most of the information. If a record has to be authorised then that field would be "owned" by the...

I read some years ago an article discussing the pro's & cons of this. It really is all down to the size of the data that is being searched & the size of the subset required. If you had a massive table 500K records & the subset was lightly to be > 200K then a set filter would be more efficient...

I have done some work on this type of problem. Is all the information on the central site anyway? Is SQL SERVER being used to replicate the data to all the sites? If the answer to above is yes then transmit a reference to the data that is already on the central site. otherwise it gets more...