Answer Questions

• cyr2224 Determining nXYCOORDINATES for the Typing Cursor (Insertion Point) in myEditBox.Selstart

  (to help with an autotext class in an editfield) I'd prefer not to use Mouse Cursor Coordinates nor myEditBox.Selstart Derivations. Both frequently elude the Typing Cursor in myEditBox.SELSTART ... (See code below) (Intellisense pinpoints nXYCOORDINATES of the selstart in Native VFP-9 editors) Is _WGetCursor() a solution here Thanks, Philip *Failing Code: lnXY= (this.Width * this.height /(70000)) &&1 lLineIncr=lnXY*pLoadedSelStart/8.5+ ...Show All

• P. Eisel creating tables programmatically-some questions

  I have decided to create some tables programmatically since they most likely will be used temporarily. I do have a number of questions pertainint to CREATE TABLE paramaters. I could not find any explanations so far to figure out what they meant. First I assumed that CODEPAGE should be 1252 (Windows ANSI). Is it the right choice I want to create tables FROM ARRAY arrName I understand that arrName is a 2-dimensional array with the same numb ...Show All

• Chad Neal Export Contact to Windows Address Book

  Hi, My VFP8 app is currently exporting contacts to Outlook and I've been getting the security warning because of the MS patch. However, occasionally after allowing access, it causes my app to hang. Clicking on it in the task bar gives the beep which normally occurs when there is another window open in the same application and Ctrl-Alt-Del is required to get out of my app. Anyway, I was looking at the 3rd party tools around to get around the mess ...Show All

• Naveen Prakash cannot update cursor

  I have a main form that calls a couple of other forms to make some selections. One of them opens a table and after a selection is made a mark is left in a special field that this record has been selected. Then this small form is closed and the same table is opened in the main form. The table is opened EXCLUSIVE in both forms. Before it is opened in the secondary form it is not opened in the main form. The point is that it all works well in ...Show All

• valef 2 more questions (VFP8)

  (1) I've made and deployed a simple app. with its own helpfile, but when deployed, nothing happens when I press F1. (It is not, that the app cannot locate the helpfile. If I rename it, I get an error when starting the program.). Any suggestions (2) The other problem is, that about one in every 4 times I close the program, the process keeps hanging and thus locking my datafiles. (When I kill the process, the datafiles are corrupted, when I start ...Show All

• modem 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

• Phillip Shentu 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. Greetings Your code ...Show All

• Mithun.Pentuker report labels

  hi all,im making new reports during run time according to users actions.for example he selectes some fields from comboboxes then he puts in a text box a value that is for the "where like.."and i save the results in a temporary table.from that table i create report and the i report form to print the new report..the problem is that the new report has as labels the names of the fields..for example if the field name is costomer_id it shows costomer_ ...Show All

• Marianor Overload possible

  I need a way to overload a fox function like Empty with a UDF of my own called Empty. Is this possible If Fox doesn't support overloading, is there a class I can inherit from and override the empty function I need help ASAP. Thanks, It will stay. An include file (.H) is read once at compilation time. If you redefine in another program (or another inlcude) you get an error as it is already defined. In that case you would have to use #UNDE ...Show All

• Gerardo Rossi How to use the tables of a Form

  I am having problem using the tables listed in its data environment, I would like to zap the records, append some data and replace some records but when I used the zap command it says that the table should be used in exclusive mode, what should I do If am going to open the tables again as exclusive wouldn't it create possible conflicts Once the form is actived and initiated it automatically opens the tables, am I right And once, the focus ...Show All

• Patrick Antonioli define window

  How could we show a define window into a top level form, where-in screen visible is set to FALSE Because I try it, and it doesn't show-up, maybe i got wrong in coding. Thanks for any help Amado Ok...this is how it works, I select a group of records using define window (ex. address that begins with letter 'A' so I have Afghanistan, America, Angola, & Asia) then the brows field will show-up over my form with records stated above, then ...Show All

• Aneel getpict() /explorer defaults

  Using XP & VFP9 When I issue fn=getpict(), How do I force the explorer window to sort by file name and display thumbnails. I have set remember each folders settings in Folder Options, Explorer always displays the directory properly, But I can not get  getpict to sort on file name.   It would be nice if I could set the default directory to open also. We are still not clear how ...Show All

• myrdhrin migrating VFP app to .net (architecture question)

  Hello everyone! I'm a fairly experieced database developer (SQL Server primarily, and Oracle quite a bit less). My experience with .net is primarily vb.net to built asp.net applications, using web services as my middle man. I just started at a new company which has a few legacy systems, one of which is a rather large FoxPro application. There are a host of problems associated with it, primarily data conflicts. Because the company has grown so mu ...Show All

• Brian M. Reisman Why this SQL select command is not optimized?

  Hello. I have turned on rushmore level messages using sus(3054,1). I run the following from the command window: select * from ruginv where status = "ST000" ruginv does have an index tag on status. The response I am getting is that rushmore optimization level is NONE. I have set optimize on. Why is this query not optimized Thanks, Aleniko Hi, what coll ...Show All

• basedcp data from one table1 that isn't in table2

  Yallo, I know there is an easy fix, but I have spent to much time on it and can't figure it out. I have two tables that share some id numbers. I want to pull all the data from one table where the id isn't in the other table. Table1 id name 1 steve 2 clarith 3 dorthy 4 pudbo Table 2 id name 8 clem 2 clarith 6 fursmorth 4 pudbo two tables: they share records with ID 2 and 4. I need to pu ...Show All