Search results for query: *

SantaMufasa, Thank you for the great support.

Yes, so if I understnd it by using the concat we are are lumping all the columns data into one string so if I wanted to use a alias I would just use one alias for the whole concated info.

You are the greatest !!! So it was the aliases that was killing me. Why can't you use aliases with the concat ? Thanks. output: select ft.serial_number||','||ft.state||','||ft.fap_version ||','||sum(case when rf_params_.id = ft.params_1x_fk then channel end) ||','||sum(case when...

I am currently using the query below to pull data from two tables and multiple fields based on a primary key from the first table and two foreign keys in the second and output it to a single row. This working great but the output is spaced out based on column size. I have tried to comma delimit...

Give GooeyScript a look see. It lets you create custom forms for VBS scripts. I uploaded the IDE version that allows you to build the code for the form by point, click and drag. You can do custom process bars, buttons, listboxs...ect. Original version...

...'# '# The input file would look something like: '# '# ==================================================================== '# 1375> d -o vr/* pp/* '# '# Vr/* Pp/* '# Use -noTabular to see hidden attributes: atmAddress. '# +================+====================+------+-----+----+-----+-----...

...testFile.AtEndOfStream varLine = testFile.ReadLine If (regExp1.Test(varLine)) And (Len(Trim(varLine)) > 5) And (InStr(varLine, "/*") = False) And (InStr(varLine, ">") = False) Then If (Left(varLine,1) = "|") Then Report = Report &...

...need. All help is appreciated. I have some ProComm Aspect scripts for Nortel nodes if anyone needs them. :-) Before parsing: 20> 20> d -o nsta/* vgs h248/* Nsta/* Vgs H248/* Use -noTabular to see the many hidden attributes...

...I have and tell me if there is a better way. Also thanks for all the info on the this forum Files before parsing: File1: 617> 617> d -o laps/* Laps/* Use -noTabular to see hidden attributes: osiUnknw, osiStby, osiAlarm, osiCntrl, osiProc, osiAvail, ps, psmAlarm, mmAlarm, pfAlarm...

...is a script to display the uptime on a Nortel Passport 7 & 15K Passport. You must be in the OS level before running the script. Enjoy !!!! ;*********************************************************************** ;* * ;*...

...control over what you want to collect and monitor. You now get a dialogbox with multiple choices. Some of the choices have alarms, I have placed a "*" beside those. Below are the choices: Display Node Info *** --> Alarms if not "UP" Display Show Mod Info *** -->...

...control over what you want to collect and monitor. You now get a dialogbox with multiple choices. Some of the choices have alarms, I have placed a "*" beside those. Below are the choices: Display Node Info *** --> Alarms if not "UP" Display Show Mod Info *** -->...

;*********************************************************************** ;* * ;* THIS SCRIPT IS FOR COLLECTING AND MONITORING 1XEVDO RNC DATA. * ;* ! NO TECHNICAL SUPPORT IMPLIED ! * ;*...

No question, Just posted it in case anyone need it.

I have posted the full "RNC MONITOR" script in another thread. Below is what I did, luckly the dlgupdate doesn't trigger the when statement. If you could look at the whole script and give me some pointers on what to do better or different. The script runs great but I know it could be better...

;*********************************************************************** ;* * ;* THIS SCRIPT IS FOR COLLECTING AND MONITORING 1XEVDO RNC DATA. * ;* ! NO TECHNICAL SUPPORT IMPLIED ! * ;*...

Hey Knob, I found a way to hide the main window and leave the dialogbox visible using "winhide $PWMAINWIN" and a "when" statement that does a "winshow $PWMAINWIN" when the dialogbox is closed. Thought you might be interested. Thanks for all the great post, You have provide me with a ton of info.

Here is one I use, very simple: proc main while 1 waitquiet 18 forever transmit "^M" endwhile endproc

Is there a mode or way to minimize the main ProComm window and still keep a dialogbox visible ? I am using a dialogbox as a monitor GUI that is continually being updated and would like to minimize the main window. Thanks.

...captured in the log file. string DateString,TimeString,timestmp proc main ltimestrs $LTIME DateString TimeString ; Now concatenate the capture filename together strcat timestmp DateString strcat timestmp " " strcat timestmp TimeString termmsg "* %s *`r`n" timestmp...