Answer Questions

• Steve X B Text in Grid formatting for billions

  What should I do when I put the (9,999,999,999.99) format as the inputmask for a text in grid it works well while data entry is performed but once it losts its focus it goes back to its unformatted state that is : 5,677,999.99 will show while data entry is performed but after hitting enter key it shows 5677999.99. what's the problem Set column's Sparse property to .F.    ic that s ...Show All

• Rebekkah Deactivate Popup

  Dear Sir, There are two command buttons on Form1. On the MouseMove event of command1, I use following codes this.setfocus LOCAL SELE1 SELE1=0 DEFINE POPUP ABC SHORTCUT RELATIVE FROM 8,77 to 14,109 TITLE 'I N P U T S' DEFINE BAR 1 OF ABC PROMPT '\<1- Receipt Voucher'FONT "Verdana",10 COLOR ,RGB(0,0,255,0,255,128) DEFINE BAR 2 OF ABC PROMPT '\<2- Payment Voucher'FONT "Verdana",10 COLOR ,RGB(0,0,255,0,255,128) DEFINE BAR 3 OF ABC PROMPT '\& ...Show All

• lgrainger VFP9 printing issue with multiple detail bands and group subtotals and/or summary totals

  I have a report with one group and a summary total. Adding a new detail band, a big new feature added by VFP9, lead to incorrect totals/subtotals. I am using VFP9 SP1, behavior80, but is the same with behavior90. Steps to duplicate: 1) Run this code create table PRINCIPALE ;   (AGENTE     C(2), ;    N_DOCUMENT C(5), ;    D_DOCUMENT D, ;    TOTALE     N(5), ; & ...Show All

• Aquilax VFP9 printing issue with multiple detail bands and group subtotals and/or summary totals

  I have a report with one group and a summary total. Adding a new detail band, a big new feature added by VFP9, lead to incorrect totals/subtotals. I am using VFP9 SP1, behavior80, but is the same with behavior90. Steps to duplicate: 1) Run this code create table PRINCIPALE ;   (AGENTE     C(2), ;    N_DOCUMENT C(5), ;    D_DOCUMENT D, ;    TOTALE     N(5), ; & ...Show All

• Airex FTP with VFP

  I tried looking for a VFP 7 specific forum, since to this problem it is irrelevant (i think) which version of VFP i'm usding i posted here. If there is a more apropriate place please be so kind as directing me to it. Hi, i'm trying to use FTP integrated in VFP 7 and Win XP SP2 to upload/download/delete files in an FTP server but with limited success. The code i am using i took from some other VFP support site but it was so long ago that i can' ...Show All

• JDFox Form Feed Character

  Hello Experts: I am using FPUTS to write text to a file. At the end of each page I need to insert Form Feed Character. How can I do this Try adding CHR(12) as your FF character. I normally work them from memory but any decent ASCII table would show it. Here's one I found through Google: http://www.lookuptables.com/ Thanks Alex. Is ther ...Show All

• Yasir Godil Info Combining on Page 2 in Page Frames

  How can I get my info on Page 1 to stay on Page 1 when I select Page 2   When I select Page 1 just the info I placed on Page 1 appears.  When I select Page 2 however, the info I placed on Page 1 also appears on Page 2 along with Page 2's info.  Thanks! It's fairly easy once you get the hang of it. You have  Pageframe. It is a container for Pages inside. As Drew said, you have to drill i ...Show All

• V0rtex return from a form.

  Still struggling to communicate with some of my secondary forms. This problem, again, happens only in StartMode = 4. Everything is fine interactively. LOCAL cUserReturn AS String DO FORM <formName> WITH par1, par2 TO cUserReturn. I get an error message that there is operand/operator type mismatch. I tried to define cUserReturn as Variant - the same thing. The expected type of return is String . According to the Help FoxPro is s ...Show All

• Sami Vaaraniemi VFP linked server issue

  We're using SQL Server for the majority of our applications, but our accounting package is still in VFP 8.0.  I need to make some costing adjustements from our inventory program.  I have linked the VFP database to SQL Server just fine and, using OPENQUERY, I can SELECT data without a hitch.  Performing an UPDATE or INSERT, however, is a different story.  I get the following error: "Server: Msg 7301, Level 16, State 2, Line 1 ...Show All

• Brad Huffman SELECT statement is showing unwanted display of data and is not passing data to a table.

  I'm using a SELECT statement to pull out data from a table... that is working great. What I'm trying to do is feed the selected data to a different table using REPLACE so that it can be used by a report. All of this is triggered from a command button on a form. Here's the code for the CLICK property of the button: SELECT store, stock, year_1, make_1, model_1, auction1, transport, recon, sold_for, fees, net_check, result ; FROM wholes ...Show All

• hotwind Scan EndScan

  CLIENT table has a one to many relationship with the CHARGE table. Select CHARGE SCAN for CHARGE.client_fk = CLIENT.client_pk    **execute commands ENDSCAN How to prevent the commands inside scan..endscan from executing if no charges were found for a client There is nothing to add. You already do a filtered scan. ie: use employee scan for Title = "no title"   delete endscan No record would ...Show All

• PeterPan1120 does sqlserver have the funtion as same as recno() of vfp?

  if not,how can i get the unique numbe of each record for example in vfp i can do like this select *,recno() from tablename coz i am just doing some test of sql in vfp8 and my friend's dbf doesn;t has the unique filed.so i used recno() to idenfied it,now  i want to know it  whether does work in sqlserver.... About the only way to achieve this with a single statement in T-SQL is to use a self-join... there are also other ...Show All

• Chuck Wagner topmost window

  Good day to everyone... My problem is about the active mainform of my application which is top level form.  All settings has already been set, compiled with no errors and deployed at the workstation.  This small VFP program is just to warn me at the server if a certain workstation is already on-line.  But when the user start any on-line games, and I wanted to send message to him, my little vfp program will not show's up ...Show All

• John Cromie Please help me

  Hi, i’m in latin america, do you know the link of this page but in spanish i have issue when try to open a foxpro application, a msg that cant found a support library of Visual FoxPro appear. Please help me with thi. I need this important application. Best regards. Doggo: I'll answer in Spanish and give you links for Foxpro forums in Spanish. This one unfortunately does not have a Spanish section. No indicas qu ...Show All

• mjy78 FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering l ...Show All