Search results for query: *

Look into Rick Strall's WebConnect at www.west-wind.com. Easy to use and a mature internet framework. Jean http://www.sigp.ca

Hi Mike, Ouf. I am glad we agree at last. And I will be more carefull in the way I put things forward in the future. Keep up the good work in this forum.... Jean http://www.sigp.ca

Hi Mike, Put a packet sniffer on your machine and do an unoptimzed SQL Select. Jean http://www.sigp.ca

Hi Mike, I believe my comments where refering to SEEK, LOCATE AND SQL SELECT commands and not to the browse Command. In a traditionnal VFP Application, all the data processing is done on the local machine. Therefore data has to be sent via the network to the workstation. Rushmore...

Hi Benson, You are using an MSSQL server in the backend. My suggestions do not apply for they are, as Mike pointed out, relevant only if you use the native VFP backend (DBC-DBF). Jean http://www.sigp.ca

Right, I just saw the SPT in the original message. Need new glasses... Jean http://www.sigp.ca

While using SQL statements make better sense if you think migrating your application to a Client/server architecture, it does not provide speed gains to a classic Foxpro application using the native Database container and DBF Files. In the Client-Server architecture, VFP sends an SQL command...

Cstr is not a native VFP function. I suspect that it is a User Defined function (UDF). This function should be in a prg file that was not sent to you. Have no fear, you can probably replace CSTR(pass_str) with TRANSFORM(pass_str). Jean http://www.sigp.ca

Hi Mike, Feedback is the only reward people get from their efforts in trying to help others in this forum. I fully agree with you. BTW thanks for your presence on this forum. Your knowledge and insights are much appreciated. Jean http://www.sigp.ca

Hi Mike, I cant speak for tmaycroft but I have to say that this thread is most instructive. I've been using vpf8 for a little more than a year and I did not know about the code reference tool, nor did I know about the third party solutions available for this. Thanks to all Jean...

Hi Mike, The reason the Set EngineBehavior 70 is needed is because of the "Group by" clause. This SQL statement should throw an error if Set EngineBehavior is 80 or 90. Lee, Sorry for the missing comma. I need a new pair of glasses. Jean http://www.sigp.ca

My kick at the can: OPTION 1 : MainCat is part of a DBC *-- Needs to use non standard SQL Syntax SET ENGINEBEHAVIOR 70 SET SAFETY OFF local lcbk as string *-- Change to your backup file lcbk = "C:\backups\myBackup.dbf" *-- Make a copy of your table (backup) SELECT MainCat COPY TO &lcbk...

You could try something like: Select UPC, min(price) AS minPrice, Description from catalogue into cursor NewCatalogue group by UPC, Description Jean http://www.sigp.ca

I tried your code and got an error on the first line. replaced it as follows and it run great in vfp9. hdr = ["FIRST","LAST","OR CURRENT RESIDENT","STREET","CITY","ST",] + ; ["ZIP4","JOBNUM","PART","OPT. ENDORSEMENT LINE","POSTNET BARC",] + ...

If you run Win XP, you can delegate this responsibility to the OS. There is a FAQ on synchronizing time between machines here faq184-3505. You could also do a search on web services. Jean http://www.sigp.ca

Hi Andreas, HTLM files are text files. You can open them using the following code: lcHTMLFile = GETFILE('HTML','OPEN HTML','HTML') lcHTMLCode = FILETOSTR(lcHTMLFile) lcNewHTMLCode = lcHtmlCode *-- Do whatever analysis needed lcNewHTML = STRTRAN(lcNewHTMLCOde, "My old string", "My new...

Hi Chris, A star for you. I was just looking at a better way to prevent users from launching multiple instances of an application. I think you have FAQ material here! Jean http://www.sigp.ca

Why not use an Iframe containing a form (Textbox and submit button) from your second server? Jean http://www.sigp.ca

That is about it. You may want to consider using MySQL or MSSQL instead of Access for performance issues. Jean http://www.sigp.ca

Hi Onliner, You may want to read before tackling such a project. Jim Buyens's book "WEB DATABASE DEVELOPMENT" from microsoft's press is probably your best bet. It will introduce you to various technologies essential to web development. Jean http://www.sigp.ca