Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. robsuttonjr

    Microsoft Access crosstab XTAB convert to SQL Server Stored Procedure

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

    Grid go recno()+1/-1 with index set order to

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

    ReactOS phone FoxPro

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

    Grid ComboBox not populating from cursor

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

    Where can I buy 'legitimate' Visual FoxPro 9 licenses

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

    Lianja, Foxincloud & tablet apps

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

    Set form values on the fly from table data

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

    Combobox drop down list on top not bottom

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

    Dynamically query past 8 weeks and current week based on a given date

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

    ASP Classic duplicated variables

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

    CRC-16 PTI voice pick code

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

    FREE Foxpro PTI (produce traceability initiative) GS-128 labels

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

    FoxPro will NEVER die!

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

    FoxPro IDE vs. EXE weird behavior

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

    NEWS FLASH: FoxPro STILL not dead Can't kill the FOX HAHA

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

    foxpro 5.0a vs 6.0

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

    how to combine XML table elements using XSD inline schema

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

    screen scraper html table data extractor to cursor

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

    use office 2003 automation to ocr image to text easily

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

    MySql 5.0 Stored Procedures stability

    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

Part and Inventory Search

Back
Top