Answer Questions

• felix21685 sending report(text) vfp to sms

  it is possibel to send sms through vfp to sms. message can be send win to mobile via bluetooth etc. if any idea example send report to sms. thanks There’s a Foxpro SMS Class on the universalthread.com. In the foxpro section Click downloads and search under title=SMS. Dave M. ...Show All

• Alisa619 Need help on a small open table code

  Hi, I m trying to make a general opentable function that I will use with all my apps in the future. Now I need someone to explain to me a few things to see things more clear. Here is my code: function OPENTABLE(TABLENAME)  LOCAL TABLETOOPEN *Ok this is just a full path I make for the dbf file. I do not know if it the right way.what it gives is  eg. c:\program files\my app\data\mytable.dbf  TABLETOOPEN=TOSTRING(checkpathf ...Show All

• Leviathan small test on transaction atomicity

  Need help with small test on table in database with transaction. Could somebody show state of table after execution this code: CLOSE ALL CLOSE DATABASES OPEN DATABASE "c:\ path to database\data1.dbc" SHARED BEGIN TRANSACTION UPDATE data1! table 1 SET name = 'BBBB BBBB BBBB BBBB BBBB' = Messagebox ('END TRANSACTION') END TRANSACTION if in table1 before execution was 500K records with value "AAAA&q ...Show All

• Arjun Bijanki Receipt Printer Problem

  Hi to All! I am using Epson Partial Cut receipt printer for our POS system. my problem is that the printer will eject or automatically cut the paper when the lenght of the paper riches 11 inch from the start of printing. the result is ok if the customer will buy only a few items, but when the customer buy plenty of items the problem start on, the receipt is cut every 11 inch of lenght.i already select the paper for Receipt when i design th ...Show All

• Albert C SELECT - SQL COMMAND again

  In a situation like this where the first field is of type " C " and the second -- " M " SELECT RTRIM (field1), LEFT (field2,20)... INTO ARRAY arr1 The first function < RTRIM > appears to be ignored (the result has trailing blanks regardless) but the second < LEFT > seems to be doing fine. I am wondering if anybody has similar experience and how such needs should be handled. There is no purpose usi ...Show All

• leovernazza With ... EndWith

  How does nesting work with With ... EndWith Does VFP work out which object I am referring to if I just enter .cDescription for example Is there a potential for ambiguity if the 2 objects have the same property I would like to use nested With ... EndWith but I am wary of introducing some difficult to find bugs. Darren, I am glad you are finding help. VFP is a wonderful product. Do not worry about my sensib ...Show All

• ozy End datasession users?

  I sharing data in LAN network, what to end datasession users If you are using Windows server you could go to Start> programs>administrative tools >computer management Than click “shared files” Then “open files” This will tell you who is accessing what, you can then call the user and ask then to log off. Or disconnect then, as a last resort. Dave Thank you! Mean, I want clos ...Show All

• Siddharth Fadnis a child form needs 2 clicks to close

  I have a form calling a secondary form. In order to close the latter I have to click twice the button that has the following statements in the CLICK method: ACTIVATE SCREEN "CLICK fired " THISFORM . Deactivate () THISFORM . Destroy () THISFORM . Hide () THISFORM . Release () 4 statements are there out of desperation. I tried them separately and in many combinations. I see on the SCREEN that the event fir ...Show All

• Hakan at devBiz VFP & Pocket PC

  Dear experts, I am working on a restaurant ordering system with VFP+MSDE and looking for the possibility to input order via a mobile device. Is there any tool like VFP for Pocket PC Or any suggestion to which language should I used at the mobile side for a shortest learning curve Someone show me with a terminal client installed on Pocket PC, connect to Small Business Server 2003 and run a VFP exe (re-write with large icon and less color ...Show All

• dfer frmpanemanager.setpane

  I get this error message from an OLE when I try to open a form with run command in interactive mode. The debugger says that the source code is unavailable. The call stack is as follows: frmpanemanager.setpane frmpanemanager.init ClassLib: forxpaneengine.fxp The file path leads to a directory in C:\\documents and settings\\..... That's it. I have never seen this object before. What can I do about it Thanks. It is actually very ...Show All

• Jocke Intellibis HOW TO START AUTOMATICALLY A .prg FILE!

  I have save my project in this folder: C:\Documenti\Visual Foxpro Projects\cescoproject In my project I have a example.prg file! In the form load procedure I have write: DO example But when I execute my program, foxpro return me this error: "File 'example.prg' does not exist" or "File 'c:\.....\another folder\example.prg' does not exist"! But if I go in the "Code section", and chose example.prg then the DO BUTTON ( red ! ), and next I'll ...Show All

• mattdk Amount range

  Hi, I have a table where the salary range and deduction are stored. As an example the salary ranging from 1,000 to 1,500 has a deduction of 100. This is the part where i should be getting the amount for deduction unfortunately i don't get any record though the record exists in the table: SELECT nfrom, nto, ndeduction from tbldeduct WHERE ; tbldeduct.nfrom >= thisform.txtngross.value .and.; tbldeduct.nto <= thisform.txtngross.v ...Show All

• Michael Bested CRLF --chr(13)+chr(10)--> .Selstart Dilemmas in myEditBox

  MyEditBox.SELSTART CHANGES during keypress events, interactive change events and/or programmatic change events when line-feeds (LFs) aren’t paired with (CRs): E.g., ‘LineFeeds’ [chr(10)] …seem to… insert themselves after every ‘carriage return’ [chr(13)] during *certain* run-time keypress events. Likewise…COM imports (e.g., oWord values) don’t seem to have paired CRLFs in them, but CRs only. VFP-9 seems to *prefer* paired ...Show All

• Joel Brabant how to SET DEFAULT TO "running program's dir" ?

  Please Help.... <SET DEFAULT changes the default directory to the directory you specify. MicrosoftR Visual FoxProR searches for a file in the default Visual FoxPro directory. The default directory is the one from which you start Visual FoxPro.> If A program called “DISP.EXE” displaying customer.dbf installed in a directory Created by user, then how to tell the DISP.EXE to look for the database (customer.dbf) The problem is if   ...Show All

• Kerdany report preview form problem

  I posted a post related to some problem with memo fields in reports. What I've done so far was to create an intermediate table, a workbench with a single field of a character string length 95. When I need to preview or print a memo field I first format it and place every word sequentially in records of that table. It required a bit of coding but now it seems to work. In any event, the problem I am about to inquire is not related to it at all. ...Show All