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!

Register Log in
  • 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!

Search results for query: *

  1. Gilesy

    read write cursors

    That's it! Thanks guys!! Gilesy
  2. Gilesy

    read write cursors

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

    Runtime error starting Quark 6.0

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

    Runtime error starting Quark 6.0

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

    IIF command not working correctly?

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

    IIF command not working correctly?

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

    Phantom Files in Temporary Internet Files folder

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

    RENAME across different drives

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

    Sys(1004)

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

    Sys(1004)

    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!!
  11. Gilesy

    Sys(1004)

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

    exclude items tagged fro del from querry without Pack

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

    Unusual error message

    '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
  14. Gilesy

    FPW26 and Winxp

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

    Reading a Word Document

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

    problem with ALLTRIM

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

    problem with ALLTRIM

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

    problem with ALLTRIM

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

    problem with ALLTRIM

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

    Save and Restore Screen

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

Part and Inventory Search

Back
Top