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 Chriss Miller 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. keithchansc

    Report Group Header VFP 7 SP1

    MsDDO, Sometimes the default printer may affect the report output, are the printer installed exactly the same in the old and new laptop ? Keith
  2. keithchansc

    SQLEXEC stop during record fetching

    Mike, Yes, the query is the same every time. I simply issue a "SELECT * FROM XXX" JRB-Bldr, There is a error message "Invalid cursor state", and then the SQL connection become disconnected. Now I am tring to config a much larger PacketSize using SQLSETPROP(0,"PacketSize",1024*20), and it seems...
  3. keithchansc

    SQLEXEC stop during record fetching

    About 2GB limit : For the whole DB it's over 2GB, but I am connecting to a SQL server, not MSDE. For each table, it's within 2 GB For the Connection settings, you mean the SQL connect string, or the SQLSETPROP() settings ? About Timeout, seems not, as the whole table can be retrieved within...
  4. keithchansc

    SQLEXEC stop during record fetching

    I find a problem when I select all records from a large table, the process will stop randomly during record fetching (The record counter in the status bar stopped), but sometime it success. It seems only happen in my Notebook (ACER Aspire 6920) so far, but both VFP6 & VFP9 got the same problem...
  5. keithchansc

    SelectOnEntry

    I put these code in the GotFocus event of my textbox class : IF VERSION(5) < 900 DODEFAULT() ELSE IF !UPPER(TRIM(This.Parent.BaseClass))=='COLUMN' This.SetFocus NODEFAULT ENDIF ENDIF It work great : First click highlight whole value and second click place cursor on your...
  6. keithchansc

    Touch Screen keypad

    Mike, May be I havn't explain detail enough - I plan to let user click the on-screen keypad when they are inputing any numeric value, eg. the invoice QTY. At that moment, the focus is on the QTY textbox, and when user click on the keypad, focus seems need to leave the QTY textbox and goes to...
  7. keithchansc

    Touch Screen keypad

    I have read Thread184-678850 about Touch Screen Application, and designed a form containing numeric key buttons to act as an on-screen numeric keypad. However when I activate such keypad inside a textbox, VFP will trigger the current textbox's valid event, how can I avoid that ? Keith Chan
  8. keithchansc

    Close the rectangle on each page

    Hi Stella, Thanks for you advice. The report I am working is printing an Invoice, I put the signature part on Page Footer band, and set it to print only in the last page. I use Page Footer since I want a contant detail band height across all pages. Then I need to print the Invoice Total on...
  9. keithchansc

    Close the rectangle on each page

    I place a rectangle shape from Group Header to Group Footer, Can I close the rectangle on each pages before group actually ended ? In Crystal Report, there's a option in Box shape 'Close Border on Page Breaks', Is there any similar feature in VFP report ?
  10. keithchansc

    How to update Microsoft SQL Server data for different language?

    pctest If you are connecting to SQL through ODBC Data Source, try uncheck the 'Perform translation for character data' option Keith
  11. keithchansc

    Syntax error in using ???

    Rick, It works great, Thanks with a star for you. Keith
  12. keithchansc

    Syntax error in using ???

    Mike, I tried but still the same result. Keith HongKong
  13. keithchansc

    Syntax error in using ???

    I got Syntax error when sending string containing character '{' to printer directly using '???'. Sending '{}' together is OK, but the '{' is lost. What happen?

Part and Inventory Search

Back
Top