Recent content by robsuttonjr

SELECT code, MIN(recno()) AS minrecno ; FROM yourTable ; GROUP BY code ; INTO CURSOR FirstRecords SELECT yourTable.* ; FROM yourTable ; JOIN FirstRecords ; ON yourTable.code = FirstRecords.code AND RECNO(yourTable) = FirstRecords.minrecno ; INTO CURSOR FinalResult

I just want to convert one crosstab at a time not the whole Access database. I am hoping there is a simple tool to copy paste and convert simply. If this can be done simply with the upsize wizard and someone has done this, I would like to know. Regards, Rob

Anyone have a script or know of how to take a Microsoft Access crosstab XTAB a convert it to SQL Server Stored Procedure?? I have plenty of examples on doing it manually. Just figured somebody had built some automated way to do it since it is a common task. Regards, Rob

If you google "foxpro ymodem" you will see some links worth looking into. Here is the first hit: MarshallSoft Windows Standard Serial Communication Library for Visual FoxPro http://www.marshallsoft.com/wsc4fp.htm Regards, Rob

So I have a grid with a table that has an index and set order to. Since the order changes the recno() order when I try to do go recno()+1 or recno()-1 it causes the the grid row to jump around rather than go 1 up or down. Is there another way to be able to move 1 up or down when the recno() is...

Has anyone tried getting ReactOS on a phone and using Foxpro on the phone? Regards, Rob

Using a dbf table not a cursor for the grid works. If I use a cursor the combobox does not dropdown and has no value shown. Really goofy. If anyone has figured this out I would still like to use a cursor with the grid. I don't like using DBF's since I have to worry about physical files. But...

I have a grid with a combobox I inserted. I cannot get the combobox to drop down and show the data from the cursor I am binding it to. I want the data in the cursor selected by the combobox to replace the grid column controlsource value or display it. I have tried a sql query as the style and...

Check out http://foxincloud.com/ They have a conversion process but you still have to make changes. Regards, Rob

Thank you for the quick replies! I did find this after reading your posts: Visual FoxPro 7, 8, 9 is available for following MSDN subscription levels: VS Pro with MSDN Pro (VL); VS Pro with MSDN Premium (Empower); Developer AA; VS Pro with MSDN (Retail); MSDN Enterprise; MSDN Universal...

Where can I buy 'legitimate' Visual FoxPro 9 licenses? The only copy of Visual FoxPro 9 I can find is on Ebay from the UK and is a downloaded ISO which seems fake to me...

I am now 49 years old in July of 2017. I have used Visual FoxPro for over 15 years. I don't see any end to using it. I hate .NET and tolerate Python. I am fortunate to work for a company which allows me to develop with Visual FoxPro. That said and burying the question, "Is FoxPro dead?"...

Thanks Olaf. I just added lctxtx controlsources to each. Regards, Rob

I have hundreds of textbox's that I want to set the values on the fly from a table. I tried the following be get and error saying, "ThisForm can only be used within a method": SELECT citemjuliancount_final SCAN...

[highlight #73D216]Thank-you Mike, Olaf and Scott.[/highlight] Setting the displaycount to 6 worked. The problem occurred when I moved the combobox below another combobox. I did try to google several ways to find this obvious answer (to those who know) but did not find one. I am working on a...