Search results for query: *

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...

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...

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...

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...

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...

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...

I want to display a one-to-many relationship within a form using a grid for the many end.&nbsp;&nbsp;This is easy if both ends are tables, however the single end of the relationship is a view.&nbsp;&nbsp;Is this possible?&nbsp;&nbsp;Please help.<br><br>The MS Help implies you can create a...