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

    Redundant blank line generated

    Thanks for the suggestion! "Set recsep off" is working perfectly! [bow]
  2. vinczej

    Redundant blank line generated

    Thanks, hoinz! I will try tomorrow your suggestion. [bigsmile]
  3. vinczej

    Redundant blank line generated

    Hi All! I have this sample sql: with p_1 as ( select 1 sorszam, 'X1' tipus from dual union all select 2 sorszam, 'X2' tipus from dual union all select 3 sorszam, 'X3' tipus from dual ) select ( (case when p1.sorszam=1 then ('[' || chr(13) || chr(10)) else '' end) || p1.tipus ||...
  4. vinczej

    Replace all null to zero number

    I've found the "SET null 0" option. But it affects only the print function, and both strings and numbers. So it doesn't solves my problem.
  5. vinczej

    Replace all null to zero number

    Thanks for the reply, Mufasa! My reason is why I ask so "crazy questions", that this null problem can be for me a "delayed-action bomb" for SQL selects. In my example A and B are number type columns of a table. I would like to know what records are, where B > A. Because A can be NULL (B not...
  6. vinczej

    Replace all null to zero number

    Hi all! It's any way to use any SET command for general replacing of all NULLs to ZERO (0) for numbers? It would be useful, because in some cases the relation of NULL values ( a > b ) gives always a false result, instead of the real relation. I know, that is the NVL and coalesce, but if I...
  7. vinczej

    Returning from an external SQL in SQLPLUS

    Great, works! --here should return to the xmain LOG SPOOL XAMIN.LOG APPEND Indeed, this was my problem! Thank you very much!
  8. vinczej

    Returning from an external SQL in SQLPLUS

    Thanks for the reply! Your reply gave me an idea, and I've tried it. I removed the "spool off" lines from the called external script. So I could do the both script correctly, but this way the spool is a "jam", hardly readable. It's any way to separate the spools into individual LOGs? Example...
  9. vinczej

    Returning from an external SQL in SQLPLUS

    Hi all! I have an SQLPLUS script. From that SQL-script I can call an external SQL like next: @sqlname.sql . It's work correctly. My problem is the next: If I embed this external script into middle of my main SQL script, then I can't return from the external script to the main script. The rest...
  10. vinczej

    Running FP Dos 2.6 by Windows7 problem

    Thanks for the replies![orientalbow] It seems to be a problem with the "use anyfile exclusive" in some cases. I'm trying to find the real cause.
  11. vinczej

    Running FP Dos 2.6 by Windows7 problem

    Pardon, I forgot the error message: "Unrecognized command werb", and appears on very several places in the program.
  12. vinczej

    Running FP Dos 2.6 by Windows7 problem

    Hi All! I'm using Foxpro for DOS 2.6 for some "old" customers. It can run generally correctly on Windows XP in a Virtual PC of Windows7. But I have a problem. I have a process, that can't run on this configuration, if I run it as an EXE file (with option "+x" extended). But the function can...
  13. vinczej

    Any way to use UPDATE...SET Number=ROWNUM ordered by ORDER BY?

    Hi, I have got idea from my colleagues: update TABLE t set t.NUMBER = rownum where EXISTS ( select 0 from (select TABLEID from TABLE order by VALUE ) where t.TABLEID = TABLEID ) ; Not a simple solution, but works! (It is...
  14. vinczej

    Any way to use UPDATE...SET Number=ROWNUM ordered by ORDER BY?

    Hi All! My question seems to be hard, but I can't get answer to this. I can put a unique continuously growing row number into a field like next: update TABLE set NUMBER=rownum ; Value Number ----------------- 9 1 7 2 2 3 5 4 This code puts the own rownum in the...
  15. vinczej

    Foxpro 2.6 for DOS or FP for Windows can run on Windows7?

    Of course are old programs, that are written in FP2.6, and work correctly (functionally). :) Thanks for replies and advisements. I see, that the main problem, that the network sharing has problems on XP virtualbox. As desktop application works FP2.6 program greatly.
  16. vinczej

    Foxpro 2.6 for DOS or FP for Windows can run on Windows7?

    I just now tried to run my Foxpro 2.6 for DOS program on Windows7. But it sent a message, that the program is not 64bit compatible application, and the program stopped. It's any way to run Foxpro DOS programs on Windows7?
  17. vinczej

    append from with ;

    My suggestion: Since the type CSV belongs to Excel, you can simply load into an Excel table, and from that can export to Dbase III data format.
  18. vinczej

    migrating from clipper to fpw26 or fpd26

    It's a hard question. I did this change, too, in my work. I migrated programs from Clipper5.2 to FP2.6. I agree with JanBucek, that a migrating from CLipper to FPDOS isn't a big advantage, but it's quite easy. But not problemlos. FPDOS can use the commands, procedures and functions a bit unlike...
  19. vinczej

    How to run fp 2.6 on newest computers

    Prehaps it helps : http://www.tek-tips.com/viewthread.cfm?qid=995380&page=1
  20. vinczej

    PICTURE clause on GET statement fails

    You must use the '@R (999)999-9999' picture formula.

Part and Inventory Search

Back
Top