Search results for query: *

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

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

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

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

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

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

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

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

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 ?

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

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

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

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