Search results for query: *

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

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

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

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

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

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

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

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

I am having trouble getting the CRC-16 value I know I should get for a PTI voice pick code. I tried this: ?SYS(2007,"1085051000201146587443HG234",-1,0) which returns: 59341 (0x9F9E) the value I want is: 26359 (0x66F7) This is the string value I am passing: "1085051000201146587443HG234" I...

I used Foxbarcode to create a PTI labels using a GS1-128 barcode. It is free vs. many other costly options. When I am done I will post the code somewhere. I am making web and desktop versions. Regards, Rob

FoxPro will NEVER die! Why? Because it still and always has been the best tool in it's class. Yes, I love arrays, cough, snicker. But let me show you something, a cursor. Countless times with an assortment of other languages svailable have I turned to Foxoro. Foxpro saved me time, money...

I have an old clunky duck taped desktop FoxPro app. When using the compiled EXE, I can search for a customer in one screen it works, then another screen an order # it works. When I do the same thing with the IDE I can find the customer but the order number is not found. Here is the strange...

NEWS FLASH: FoxPro STILL not dead Can't kill the FOX HAHA It's now 2014 and still people are using FoxPro. I landed a job for FoxPro in my own state and within 30 minutes of where I live. So tell me again Java and Microsoft groupies that FoxPro is a dead end career. Ok, yes it is very hard...

We have applications developed in Visual FoxPro 5.0a So my question is can we move to Visual FoxPro 6.0 without code changes? Has anyone done this? Regards, Rob

in the following simple xml I would like an inline XSD schema that would allow me to define that note is a table that contains, name, address, city (from misc), and country. I have a more complex real world xml string which I trying to figure out how to throw fields from other areas into a...

Below is a procedure which if you pass it a DHL tracking number it will use internet explorer behind the scenes to go to dhl's website and pass back the package details into a cursor. This demonstrates 'scraping' data without using any third party addons. I am specifically after table '14' in...

I had to figure out how to ocr an image cheaply (if you have office 2003 already). Since we already had Office 2003 I could use the OCR engine in office. This code converts base64 to file and ocr's it to text. You can do tiff, jpg, and some others. DEFINE CLASS imagetools as custom...

I would like to sell my supervisor on using stored procedures in MySql 5.0 on a production database. Who is using stored procedures in MySql 5.0 and for how long? Any issues? Should I push for them? Regards, Rob