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...
'############################################################################
'# PPKParser
'#
'# ! NO TECHNICAL SUPPORT IMPLIED !
'#
'# This stand alone VBS script will parse and ";" delimit a file with the output from
'# a Nortel Passport 7K/15K/20K that has been dumped by raw...
Also I changed the code a little bit in the function. It now loads all the files in a dedicated dir. for the capture files. It is posted below is case someone wants it. I put it together from multipliable post on this forum.
Thanks Everybody.
====================================
Function...
I tried the "^" at the first of the pattern but for some reason it failed to match any line until I removed it. The "(Len(Trim(varLine)) > 5)" is because I don't want lines with less then 5 char. Is there a way to put that in the RegExp pattern so I don't have to do the "(Len(Trim(varLine)) >...
Hello everybody. I am new to VBS and to using RegExp. I have a collection script that grabs data from a Passport switch into multipliable files. I need to parse the data in the files. I put together a function to do this based on what I have found in this forum and the following link...
Below 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 !!!!
;***********************************************************************
;* *...
I have rewritten the RNC monitor script to give you more 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...
RF101,
I have modified the script so that now you can choice what data you want to collect and monitor. Below is the list of things you can choose now. I will post the new version as a tip.
=================================
I have rewritten the RNC monitor script to give you more control...
;***********************************************************************
;* *
;* THIS SCRIPT IS FOR COLLECTING AND MONITORING 1XEVDO RNC DATA. *
;* ! NO TECHNICAL SUPPORT IMPLIED ! *
;*...
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.
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.
You could do something like the following, this only sends to the terminal window not the remote device and will be captured in the log file.
string DateString,TimeString,timestmp
proc main
ltimestrs $LTIME DateString TimeString
; Now concatenate the capture filename together...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.