Search results for query: *

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...

Combobox drop down list on top not bottom Any ideas why a combobox would popup above the combobox rather than below? I am making a 7" tablet app. It works fine in development but on the tablet the drop down list appears above the combobox. Regards, Rob

Thanks! Now let's say users can pick any day of the week. Now I want to be able to set the week start date so: 03/16/17 (Thursday) would set week start to Thursday through Wednesday If 03/17/17 (Friday) would set week start to Friday through Thursday Finally I need to group the data by weeks...

I need to dynamically query past 8 weeks and current week based on a given date. I can't use the week function since I am on sql So if I say in where clause for example: EVENTDATE between cast('03/06/17' as datetime) and cast('03/06/17' as datetime) + 6 This will give me current week based...

I may have figured it out. But I need some understanding of how to handle a value passed with spaces & '&': This causes duplicates: <input type="button" value="Next Week ----->" onclick="window.location.href =...

At the top of an classic asp page I set the variable: CustomerID = Request.QueryString("CustomerID") At the bottom is a back button. When they click it more than once the CustomerID duplicates appending the same value with commas. <input type="button" value="Next Week ----->"...