Only Title

Answer Questions

• VisBas Accessing FoxPro 2.x tables from VFP 9

  Hi, i have found, that VFP 9 cannot optimize selects / updates / deletes on FoxPro 2.0 tables - it does not use any indexes defined for these tables. When i was manipulating these tables from VFP 6, there has not been problems and all selects / updates were optimized. Can someone help me to find solution for this  Thanks in advance Yes, our system under VFP 9 uses CP 1252 (current CP is 1252) -  ...Show All

• bizbiz Using SQL-Update in FoxPro 8.0

  Hi, I m trying to update a column of multiple rows in a table from a column of multiple rows from another table but havent got the required result. I have tried various queries; here are a few failed examples: 1. UPDATE expenses_fxd ; SET expenses_fxd.postedpr = expenses_new.postedpr ; FROM expenses_new ; WHERE expenses_fxd.slipnum = expenses_new.slipnum Error Msg: "Command contains unrecognized phrase/keyword." 2. INSERT INTO expenses_fxd ...Show All

• JBT3000 ActiveX registration question

  I just downloaded Andy Kramek's book 1001 Things .. and ran through many pages. It is an awesome work! Clearly written and just very good for learning. I tried to find an answer to a question I have (among others) but it does not seem to shed any light on it--the question is rather specific. I tried to play with some ActiveX controls that can be found in Tools-->Options-Controls menu but some of the most interesting ones I could not even d ...Show All

• TrickyToo Stretch with Overflow + Page breaks

  Hi, all This is probably an easy question, but I'm still a newbie at VFP. I've got a report (built with the Report Designer that's shipped with VFP) and I have a field wicg is marked to stretch with overflow. Problem is, sometimes it strechs over a page break (part of the text is printed in one page, the rest in the next page). Can I keep this from happening Thanks in advance Hi You can ...Show All

• Bob Sculley Public Variables

  Somebody can tellme how can I use a Public Variable declared in main.prg to use in all forms in an application Actually, I want to check a Password to assign diferent access to change data or only for consulting. Declaring Public in Main seems not have effect in forms. Thank you You might want to do this creating a property of the _screen object... _screen . AddProperty ("UserSecurityLevel", 1) This way you can re ...Show All

• P MOORE 12 hour time format

  Hello, I am doing a program that will compute the time in and time out.  As much as possible I want to do the time() function and not the datetime() function but the problem is if I use time() it displays the 24 hour format.  What I am tasked to do is to subtruct the time out to time in and be able to display the 12 hour format. Any advice will be greatly appreciated. But surely that's a display issue, not a data storage is ...Show All

• HermanMoore Can't write to new tables.

  Hey, I was given the task of updating a project in .NET and foxpro. I opened up the foxpro database and added a couple tables. I can write to them from the command line, but I can't insert or update records through the oledb. The users have write access, and can write to any of the old tables, but not the new ones. I am doing this in VFP 6.0. I don't know what the version to make the originals was. What am I missing ...Show All

• Faisal H. Siddiqui Help! Save me from this error cursor not saved error message!!!

  Hi all; I have this grid who's control source is a cursor who is exclusive. Somewhere in the grid I use a replace command to change one of the fields in the cursor. When I move to the next row, and change a field I get an error stating that the current row is not saved and needs to be saved. I have tried everything including putting a FLUCH FORCE command after the replace command. I don't see why an exclusively opened table shoul ...Show All

• rainielle73 Report problem

  Hi All, I met a strange problem in using REPORT FORM. Say I have selected a list of data by using SQL-select and placed it in cursor MyCurcor in my PRG file, but not in MyReport.scx Then I want to create a report: REPORT FORM MyReport PREVIEW the result is OK for first page and when I move to next page or other page or if I were to click on the report, suddenly selected cursor is changed and report shows me that there is Variable 'xxxx ...Show All

• BerndD How to show images(pictures) in RTF control??? (like chat...)

  I am not able to insert a picture in RTF control. I am using following code: thisform.rtfcontrol.oleobjects.add(,,"mypicture.gif","paint.picture") When I execute this command a picture viewer appears. When I close it a object with a title "mypicture.gif" appears in the RTF control. I want to see a picture not a name of the file without loading a picture viewer window. Thanks a lot. Hi You don't get ...Show All

• granville combobox problem

  I would like my combobox to look like the combobox of ACCESS where I could reduce the size of the first column to 0 so it will only show the second column. Like the zipcode(the 1st column) and the description or place (the 2nd column). I would show the description but internally I am storing only the zipcode but as a user one would only see the description. Hope you could help me again, thanks. Is there a workaround so it won't ...Show All

• Dvorak Pavel report temp file not found

  I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Loca ...Show All

• AnneR Using SQL Pass Through to Access my Remote Data Source

  Here's the source code which I copy from QUE Book('The One Source for Comprehensive Solutions' by Menachem Bazian) //*using SQL PASS THROUGH TO ACCESS DATA SOURCE *// LOCAL lnHandle lnHandle = SQLConnect("My Remote text") IF lnHandle > -1    SQLExec(lnHandle, "SELECT customers.* FROM customers","Results")    SELECT Results    BROWS    SQLDisconnect(lnHandle) ENDIF I try that sample, and a ...Show All

• David Deen import from excel

  how can i import an excel sheet with huge text on some cells... i try it, but the character field is only 254 chars size, i did try to create a table and then append the big text cells to memo fields, but they remain empty... thanks for the help !! Instead of import use SPT to get the data. I'll try, Thanks !! i'm checking that... Thanks a lot ! I wrote this a while ago to conver ...Show All

• Stefano Padovan Question about using left join and where clause together.

  Hi, I have a select statement as follows: SELECT ;     a.cust_id as Customer, ;     a.store_no as StoreNo, ;     b.pd_code, ;     c.pd_sdesc, ;     sum(b.ord_qty) as OrderQTY, ;     sum((b.cs_uprice + b.handle_fee) * b.ord_qty) as OrderAmount ; FROM ;     sspdodhd a, sspdoddt b, sspdcd c ; LEFT JOIN ;   ...Show All