Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mjcmkrsr

  1. mjcmkrsr

    Persistent error in storing JPG in general field VFP 9.0: OLE error code 0x80040011: Not able to convert object.

    ... and some demo code (pictures in a grid) to illustrate Chriss's advice Public oForm oForm = Createobject('myForm') oForm.Show() READ EVENTS CLOSE ALL CLEAR ALL ********** DEFINE Class myForm As Form Height = 360 Width = 840 MinWidth = This.Width MaxWidth = This.Width Add...
  2. mjcmkrsr

    What is the correct or best approach in editing a table?

    Hi Doug, You'll need this unique record identifier at the latest asa your table is part of an updatable view Your're right - the RECNO() order won't change but the RECNO() WILL change, and you won't be able to find the formerly associated record hth MarK
  3. mjcmkrsr

    What is the correct or best approach in editing a table?

    ... and to illustrate Chriss's explanations - post above paragraph 2 - please see demo code below. SET DELETED ON CLOSE ALL &&& Create cursor with names CREATE CURSOR curNames (cPKey C(4), cName C(10)) INSERT INTO curNames VALUES ( "1000","Joe") INSERT INTO curNames VALUES ( "1001","Sam")...
  4. mjcmkrsr

    What is the correct or best approach in editing a table?

    Hi Mandy, Maybe REPLACE won't work either if you cannot determine the reason why UPDATE sometimes works and sometimes not hth MarK
  5. mjcmkrsr

    What is the correct or best approach in editing a table?

    Hi Mandy, If you occasionally have to update the transaction table you could use a filtered browse e.g. use transaction table browse for transactionid = "0001" and do the required updates or replace in transaction all amounts with 890 for amount = 340 and transactioncode = "0001" or...
  6. mjcmkrsr

    Grid - control source being ignored.

    ... or simply hide the column(s) you don't want to be displayed (demo code below) ************************************************** PUBLIC oForm oForm = NEWOBJECT("form1") oForm.Show Read Events Close all Clear All RETURN ************************************************** DEFINE CLASS...
  7. mjcmkrsr

    .dbf files mysteriously gone missing (or being deleted)

    Hi Vince, Please use PACK with extreme caution and best in an environment where no other user can (try to) access the file during the pack process. From Hacker's Guide to Visual Foxpro hth MarK
  8. mjcmkrsr

    Report layout differs when running

    Hi, You may want to have a look at Format - Snap to Grid (I have it checked) and Format - Set Grid Scale (I have it at 6 pixels) in the Report designer. hth MarK
  9. mjcmkrsr

    Copy fields from one table to another

    Hi, Wrong - you may want to read more carefully the report layout: the data from your former Detail 1 band are now in the Group header 1 called "localiza" whereas the data from your former Detail 2 band are now in the Detail band. If you own the book "What's New in Nine: Visual Foxpro's...
  10. mjcmkrsr

    Sum of values in a Report Detail band

    Hi, Below a demo with 4 cursors to show how to calculate values per record(s), the group(s) footer(s) and the total on the last page footer. hth MarK
  11. mjcmkrsr

    Position form in another form when radio clicked

    Hi, You may want to have a look at the demo code below - not very fancy, but it might give you an idea. oForm = CREATEOBJECT("clsMainForm") oForm.Visible = .T. oForm.SHOW() Read EVENTS CLOSE ALL CLEAR ALL RETURN *!* Define Main Form Class Define CLASS clsMainForm AS FORM...
  12. mjcmkrsr

    Set a TAG for a field programmaticaly

    ... of course since you closed CLIENTES several lines up in your code - and you wrote it yourself! Tables may only be SELECTed if they are open. hth MarK
  13. mjcmkrsr

    Problem with printed image

    Hi, It might be related with the file format *.BMP or *.JPG or ... and also how you store the pictures BLOB/MEMO. Please find some demo code attached hth MarK
  14. mjcmkrsr

    VFP Issue with date selection 1/1/25 returns 1/1/1925

    Hi Maybe Coosmann could give us some hints or at least tell us if and how he solved the problem MarK
  15. mjcmkrsr

    VFP Issue with date selection 1/1/25 returns 1/1/1925

    Hi Yes it does. But it has some other gotchas From Hacker's Guide 7 hth MarK

Part and Inventory Search

Back
Top