Search results for query: *

Mike, Top man! - Thanks problem solved Cheers Andy

Hi All, I recently had a problem whereby I had two tables, both containing a field named 'f_name' joined by a single view. The problem was that the view seemed to not be able to resolve where the updates should go for each of the corresponding 'f_name' view fields (I used appropiate aliases in...

Hi, I have a complicated view which I have been using to update its base tables. In the latest release of my software it has stopped updating the base one of the bases tables. To debug I simplified the view to just get two fields (the primary index & the field I'm trying to update) from a...

Hi, I have a 'owner draw fix' CListCtrl which does not return the values I expect when I call GetSubItemRect(). GetSubItemRect() always seems to return the values expected it the owning dialog's font size is 8pt. If I change the font to 16pt the cell heights are unaffected, resulting in any...

Scott, Thanks for that - I've tried it out in the command window and I'm confident I can get it to work that way. As a restore facility would you suggest using the COPY FILE command (with the database close)? Is this the safest way? It feels safer that emptying a table and then doing an...

Hi, I've developed a small database that I would now like to deliver to a number of PCs to be used by people who are not too knowledgeable of PCs. I would like them to backup the data regularly to a Zip/CDW drive and to be able to create multiple backups on the same media e.g by allowing the...

Hi, Can anyone help? I would like to invoke a modal dialog from a menu item/toolbar button and whilst the dialog is being displayed, I would like the menu item and button disabled. I have no problem doing this for the items which result in a modeless dialog being displayed. It is because I...

Thanks Vlad, I've managed to get it working to a fashion. Your suggestion of turning the cursor OFF and ON seems to have no affect though. Also I am using the DynamicBackColor property, consequently the Selected Color needs to change according to the expression in the DynamicBackGround...

Hi, I have a grid which is populated and all cells are read-only. I would like to be able to double click on one of the rows and active a 'details' form for that row. Obviously, the cells of the grid being disabled results in the Click/Double Click events being inactive. Any ideas?? Many...

Thanks for all your replies, I am actually running Outlook Express 5 on my development machine. My problem is that the target machine may be running Outlook or Outlook Express. Therefore I assume Ropje's solution is the most suitable. I have had some success with this solution after I swopped...

I would like to send an email from within FoxPro. The VFP Help gives an example of invoking Excel using OLE and this works fine. Could anyone give me an example of sending an email using Outlook Express? When I run the command: oleApp = createobject("outlook.Application") I get...

Sorry Rob, I'll keep it to American in future!

Jon/Robert, I tried setting the cursor property to no avail. When Robert said he had had the same problem well I knew I was in trouble!! Thanks for you rapid responses though - both within an hour or so, that's service for you. I've got around the problem by only allowing edits within a set...

Dear All, I've got a parameterized view that I have created as follows: create sql view as SELECT T_worklog.ip_work_lo,; T_worklog.i_activity,; T_worklog.i_bf,; T_worklog.f_date,; T_worklog.f_ncode,; T_worklog.f_ndesign,; T_worklog.f_ntest,; T_worklog.f_ndocs...

Dear All, I'm getting a less than helpful 'Syntax Error' when I'm issuing a 'SET RELATION' command. The situation is this: I've got a view which I'm using at the 'one' end of the relation and a table for the 'Many' end. The table is actually one of the base tables of the view. The...

Sorry, problem solved - I had some combo boxes being populated from other tables. I'm not sure what was wrong but I've re-done them and all it fine.

Thanks, sounds like sound advice. Can I just comfirm that what you are suggesting si neat way to re-order views? My original query was really about how to build complex views in the Studio and display the result in forms. I'll try what you have said, but due to by inexperience, I am unsure of...

Thanks Robert,<br><br>I think I'm on the right track now.&nbsp;&nbsp;Having to use DBSETPROP() to get the updates working is also making sence to me now (being essentially a C++ developer).&nbsp;&nbsp;The FoxPro Designers are far too nice for people like myself!<br><br>Many Thanks Andy.

Hi All,<br><br>I've posted a similar question previously on the FoxPro Forum, with your help (thanks David and John!) I've managed to get a bit further, but I am still not quite there, so a bit more help would be gratefully received.<br><br>The Problem:<br><br>I have a table containing records...

Jon,<br><br>Thanks, I've managed to create the temp index solution in the command window!&nbsp;&nbsp;I'll try doing it in the form shortly.<br><br>I had played with Parameterized Views as per your second solution, however I could not get the child view to update with new parameter...