Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi, You may also want to check your windows settings - see below (W10 Pro) - and/or in VFP the SET SYSFORMATS command hth MarK

and a more concise version of the above PUBLIC goForm1, goForm2, goForm3 LOCAL i IF NOT FILE("dbfTemp.dbf") CREATE TABLE dbfTemp (f1 I, f2 I, f3 I) FOR i = 1 TO 500 INSERT INTO dbfTemp VALUES ( Int(Rand()*1001), Int(rand()*1000), Int(Rand()*999)) ENDFOR...

... and a fancier example showing the versatility of DATASESSION = 2 - three forms using one table with different index tags and creating their own sets of cursors all named identically (see attachment). hth MarK

Hi Filip, Please find below the demo code for one or more forms accessing the same table PUBLIC oForm1, oForm2 LOCAL i CREATE TABLE dbfTemp (f1 I, f2 I, f3 I) FOR i = 1 TO 50 INSERT INTO dbfTemp VALUES ( Int(Rand()*1001), Int(rand()*1000), Int(Rand()*999)) ENDFOR USE...

Hi, The DATASESSION property of each form has to be set to 2 (Private). Then you have full control of the underlying table(s). From Hacker's Guide to VFP 7 You may also want to have a look at "Programming for Shared Access" in the help file. hth MarK

Hi, The INTEGER field type accepts values up to 2,147,483,647 but a numeric field type accepts values between these limits - .9999999999E+19 to .9999999999E+20 Check "Visual FoxPro Data and Field Types" in the Help File hth MarK