Recent content by Ivor

sphipp, you are a genius! It's working now, I guess it's the last statement that fixed it. for each SV break by SV.cust-num by SV.item : if first-of(SV.cust-num) then display SV.cust-num with FRAME X. display SV.ITEM volume with FRAME X DOWN. DOWN WITH FRAME X. end. /* for each SV break...

Yes, I've tried 60 down etc but it keeps outputting just the one line. I commented out the output to filename statement so it goes to screen and it keeps overwriting the same line leaving just the last one there. The DateS and DateE I will change when I get the output working correctly. /*...

Hi plus_marca I very much appreciate your quick reply and help, I am so pleased. I am almost there now, the only issue I have is that only the last row from the work table is being displayed when using the FORM, it's something to do with down frames? Here is before: Customer Item...

I have this problem too. I am writing a report that gives a breakdown of volume sales over the last 12 months, the months printing in columns across the report. First, I extract the data into a work table to then report from which is defined as follows: define work-table SV field cust-num...

Sorted it with the following kixtart functions:- Function ListDBs($DBdir) $filename = dir( $DBdir + "\*.lk") while $filename <> "" and @error = 0 ? " " + left($filename,len($filename) - 3 ) $filename = dir() ; retrieve next file loop EndFunction Function...

Thanks for that I now have a kixtart script to selectively start and stop individual databases (amongst many other related functions), but I can no longer "see" which databases are running/stopped as you do when using Procontrol. Is there a way to interrogate which databases are running, or...

I use:- pccmd proservice start and pccmd proservice stop to stop/start all the databases for backup. Is there a method to stop individual named databases? I currently do this manually using ProControl.