Search results for query: *

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

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

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

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.

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

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

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

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

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

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.

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

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

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

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

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.

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?

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.

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

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

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