Search results for query: *

That's it! Thanks guys!! Gilesy

Hi All, I am trying to create a read write cursor. Having searched these threads, sombody suggested the following: SELECT * FROM v_products INTO CURSOR lcresult NOFILTER USE lcresult IN 0 AGAIN ALIAS myTable SELECT myTable && this will be readwrite SO, i do this: Select * FROM maintbl ...

Hi all Got an answer for this - would have replied earlier but needed to finish my project. Create a new folder with name "Preferences" under QuarkXPress 6 application folder. I have no idea why ! But it worked for me. I'd tried reinstalling, upgrading etc. Nothing worked, but adding the new...

This has happened to me whilst I was in the middle of using it! It crashed and trying to restart it, I got the same message. I have have reinstalled it but it doesn't fix it. I know this isn't helpful but just to let you know you are not the only one and I need an answer too - I have 3 days to...

Hi Mike I thought that was the case too, however I beleive I have stumbled on where it happens: close data all use <table> SELECT * from <table> WHERE <field> = iif(con1() and con2(),1,0) PROCEDURE CON1 WAIT WINDOW "Processing Condition 1" RETURN .F. PROCEDURE CON2 WAIT WINDOW "Processing...

Hi all I have had it reported that the IIF will evaluate all conditions regardless of the return value. For Example <test> = IIF(Procedure1() AND procedure2(),1,0) If procedure1 returns false then it still (apparently) evaluates procedure2. I cannot however recreate this. Has anyone ever heard...

Hi All. In xp, if you go to this directory: C:\Documents and Settings\USERNAME\Local Settings\Temporary Internet Files And then empty it. Then Right click, properties. It states it has 34 files, 12 folders totalling 3.08 mb. I have show hidden files or folders on. They are still there after I...

Hi folks. Having a problem with the RENAME command. I have a line RENAME (File1) TO (file2) Where File1 is &quot;T:\spare\temp\12345678.tmp&quot; And file2 is &quot;data\newfile.txt&quot; I get the error &quot;Attempt to move file to a different device&quot; Other than prevent the user having...

Nothing! It's just one line: <var> = sys(1004) But nothing is done with <var>. I had wondered if it was a memory purge type thing. Or if he was testing for something during developing. I just wonder what else there is in Fox that is undocumented and may be useful - if we knew what it was...

Somebody put this into our code. He isn't with us anymore so I didn't know if it was deliberate or not and what it was supposed to do. I'm going to rewrite it anyway. Thanks Guys!!

Hi all Does any body know what this is for? it returns a string like &quot;16756543&quot; Thanks

Try putting ... FOR NOT DELETED() in your code. IE BROWSE FOR NOT DELETED() or SCAN FOR NOT DELETED() etc. Good luck

'Transgressed node found during compaction.' Anyone got any idea what on earth this is? Fox 2.6a dos, using a general input screen I have used millions of times and had no problems. It crashed my whole PC. Only happend once so far, but I'd love to know where it came form. Thanks

We had a very similar problem, it turned out to be that the user had a large resolution set in XP, 1280 x 1024. When we got them to change it down, the crash didn't occur. Good luck.

I have had a limited amount of success with this: RENAME name.DOC TO name.TXT STORE FOPEN('name.TXT',12) TO file_handle STORE FSEEK(file_handle, 1, 2) TO lcrow STORE FSEEK(file_handle, 0) TO ifp_top lcLetter = FREAD(file_handle, lcrow) t_string = &quot;&quot; FOR t_loop = 1 TO LEN(LCLETTER) IF...

Morning all. We don't know what caused this - the original code from the command prompt works - always. Put inside some of our other applications - it works there too! But put it into the program where it originally was and it refuses to work properly. That's why I wondered if there was a...

Thanks guys. It's Fox 2.6a windows by the way. After a lot of experimenting we came up with this Ret_val = PADR(EVAL(&quot;ftable.ftype&quot; + ; STR(fld_type,1,0)),30) It works but God knows why the other didn't. And, the powers that be decreed that the ftypes above 9 have become...

IF fld_type > 0 Ret_val = PADR(EVAL(&quot;ftable.ftype&quot; + ; ALLTRIM(STR(fld_type))),30) ENDIF RETURN ret_val This is the code in question. There are 12 ftypes in the table. The fields are named ftype1 to ftype12, previous processing tells fld_type which we should be on. So if...

Good morning all I have an unusual problem with this code: Where var = 4 STR(var) is returning &quot; 4&quot; and bizarrely ALLTRIM(STR(var)) is also returning &quot; 4&quot; I am using this to construct a field name which subsequently crashes during EVALUATE because of the...

Morning guys, It's FP Windows and the user has a huge resolution, 1280 x 1024, 32 bit colour. After the SAVE SCREEN it shells out to a dos bat program and restore is activated when that is complete. It's very old code written in 94. We've told the user to change the screen resolution down and...