|
|
|
How to create Graphics
|
OpenInsight Community Source Code
|
0 |
Sep 2 2009, 11:24 AM EDT by
|
|
|
Thread started: Sep 2 2009, 11:24 AM EDT
Watch
Hi, I´m new in this tool, and I wish to know if exist a way to create graphics using OI, or if I need an extra componet.
Thanks a lot Best regards!!
out of
found this valuable.
Do you find this valuable?
|
|
|
|
OpenInsight HTTPPost
|
Web Services
|
0 |
Aug 3 2009, 6:02 PM EDT by
|
|
|
Thread started: Aug 3 2009, 6:02 PM EDT
Watch
contact me for a sample
0
out of
1 found this valuable.
Do you find this valuable?
Do you?
|
|
|
|
Accessing XML Web Service from OpenInsight using HTTPPOST
|
Get Cureent Windows User ID
|
0 |
Aug 3 2009, 5:57 PM EDT by
|
|
|
Thread started: Aug 3 2009, 5:57 PM EDT
Watch
oops - wrong place
out of
found this valuable.
Do you find this valuable?
|
|
|
|
abut openi
|
Whitepapers
|
0 |
Aug 2 2009, 11:39 AM EDT by
|
|
|
Thread started: Aug 2 2009, 11:39 AM EDT
Watch
look for use of OI
out of
found this valuable.
Do you find this valuable?
|
|
|
|
Serial communications
|
Operating AREV32
|
0 |
May 30 2009, 11:14 AM EDT by
|
|
|
Thread started: May 30 2009, 11:14 AM EDT
Watch
V123 and V124 seem to have gone away in Arev32. Does anyone know of a good workaround? My VB/C++ skills aren't what they should be. I wonder if there's a good dll/ole/exe solution that would be inexpensive (free would be nice).
out of
found this valuable.
Do you find this valuable?
|
|
|
|
Copy to clipboard
|
Discussion Forum
|
0 |
May 27 2009, 3:05 PM EDT by
|
|
|
Thread started: May 27 2009, 3:05 PM EDT
Watch
I whish to copy several cells from an edittable to an Excel worksheet. I have used the status = Send_Message(control , "COPY") but i got a 0 (unsuccesfull) in status(). The control has several rows selected. Any idea that could help to accomplish this task?
out of
found this valuable.
Do you find this valuable?
|
|
|
|
M4a metadata retrieval
|
OpenInsight Community Source Code
|
0 |
May 22 2009, 12:29 AM EDT by
|
|
|
Thread started: May 22 2009, 12:29 AM EDT
Watch
I have finally found an easy way to get info from M4a files.
Get AtomicParsley from here:
http://sourceforge.net/projects/atomicparsley
function bsbs_get_metadata(MusicFile) declare subroutine SRP_Run_Command equ null$ to '' Song=null$ Artist=null$ Album=null$ Output="VAR" Cmd="c:\m4aMetadata\AtomicParsley.exe ":quote(MusicFile):" -t" SRP_Run_Command(Cmd, Output) swap \0D0A\ with @fm in OutPut Pos = index(OutPut,\A9\:'nam" contains:',1) if Pos then Song=trim(OutPut[Pos+15,@fm]) end Pos = index(OutPut,\A9\:'ART" contains:',1) if Pos then Artist=trim(OutPut[Pos+15,@fm]) end Pos = index(OutPut,\A9\:'alb" contains:',1) if Pos then Album=trim(OutPut[Pos+15,@fm]) end
return Song:@fm:Artist:@fm:Album
out of
found this valuable.
Do you find this valuable?
|
|
|
|
AREV32 ERROR
|
AREV32
|
12 |
Apr 8 2009, 2:21 PM EDT by
|
|
|
Thread started: Sep 3 2008, 11:22 AM EDT
Watch
When trying to execute the Arev32_standalone_form, I do not get a menu, instead I am presented with the blue screen and the error box [w192] Menu "MAIN" has not been created. I have tried attaching and reattaching the AREV_DIR, and that has not worked. I am runninh OI 8.0.7. Any help would be greatly appreciated. One other thing I have noticed, in my RevCmd folder I am missing revcmdctl.ocx, I am not sure how this affects Arev32.
out of
found this valuable.
Do you find this valuable?
Show Last Reply
|
|
Last Reply:
RE: AREV32 ERROR
By: ,
Apr 8 2009, 2:21 PM EDT
"When trying to execute the Arev32_standalone_form, I do not get a menu, instead I am presented with the blue screen and the error box [w192] Menu "MAIN" has not been created. I have tried attaching and reattaching the AREV_DIR, and that has not worked. I am runninh OI 8.0.7. Any help would be greatly appreciated. One other thing I have noticed, in my RevCmd folder I am missing revcmdctl.ocx, I am not sure how this affects Arev32." I believe this is because the ENVIRONMENT record for the logging-in user has a startup menu of "MAIN" indicated. And during log-in that menu isn't being found in MENUS or SYSMENUS. Try logging in as SYSPROG. in a Command window enter RUNMENU STARTUP. Choose Options, then choose User, and bring up that user. Then F10 to Advanced choice, and see the Environment name. ESC Esc to the Environment choice. Choose Menus. Press Shift-F1 and choose the above Environment name. This should show you "MAIN" in prompt Default System Menu. Change it to APPMAIN for now since we know that will be found in SYSMENUS. Save, exit, change Application and log in as the user.
out of
found this valuable.
Do you find this valuable?
|
|
|
|
|
Arev32 Conversion - Copy Tables
|
OpenInsight Community Source Code
|
2 |
Apr 2 2009, 4:25 PM EDT by
|
|
|
Thread started: Jan 30 2009, 4:28 PM EST
Watch
I'm trying to run the Arev32 conversion wizard on an old Arev 2.12 system with Lots of dots (no underscores). Aside from the dot issue, I want to convert the data tables in place and Not copy them elsewhere (We're talking Huges tables). The wizard doesn't seem to let me get away with that, and Bob at RevSoft tells me that you Have to copy the tables.
Any advice?
Michael Matthews
out of
found this valuable.
Do you find this valuable?
Show Last Reply
|
|
Last Reply:
RE: Arev32 Conversion - Copy Tables
By: ,
Apr 2 2009, 4:25 PM EDT
"Hi Michael,
Sorry, I'm not sure how to do what you're requesting.
Also, I might not be understanding what you're asking - but if its trying to convert your Production data directly against existing tables, rather than running off a copy (or copying them elsewhere as part of the process) then this sounds rather risky. What happens if the conversion doesn't complete fully, or there is some side-effect, which makes your data unusable in its current form? You might be opening yourself up for a world of hurt. And Bob generally has good reasons to say things :)
Best of luck, James" Huge in AREV is peanuts anywhere else. The AREV2.12 to AREV32 conversion we did resulted in great DB performance and reliability gains, never mind the indexing fixes. My advice: get a case of two-four and run it over the weekend. For AREV32 conversion tips see http://exorsys.com/ProductsServices/AREV32/tabid/247/Default.aspx.
out of
found this valuable.
Do you find this valuable?
|
|
|
|
|
Weeknumber routine
|
Week Number
|
0 |
Feb 15 2009, 11:01 AM EST by
|
|
|
Thread started: Feb 15 2009, 11:01 AM EST
Watch
compile Function WeekNumber(inDate)
** inDate as MM-DD-YYYY
Declare Function Week_Day, WeekNumber
DayNo = Iconv(inDate,'D4-') - Iconv("01-01-": inDate[7,4],'D4-') + 1
StartDay = Week_Day(Iconv("01-01-": inDate[7,4],'D4-')) StopDay = Week_Day(Iconv("12-31-": inDate[7,4],'D4-'))
** Number of days belonging to first calendar week StartDays = 7 - (StartDay - 1)
** Test to see if the year will have 53 weeks or not If StartDay = 4 Or StopDay = 4 Then ThurFlag = 1 Else ThurFlag = 0 VNumber = Int(((DayNo - StartDays - 4) / 7) + .5)
** If first week has 4 or more days, it will be calendar week 1 If first ** week has less than 4 days,it will belong to last year's last calendar week If StartDays >= 4 Then WeekNumber = VNumber + 2 End Else WeekNumber = VNumber + 1 End
** Handle years whose last days will belong to coming year's first calendar week If WeekNumber > 52 And ThurFlag = 0 Then WeekNumber = 1
** Handle years whose first days will belong to the last year's last calendar week If WeekNumber = 0 Then WeekNumber = WeekNumber("12-31-": inDate[7,4] - 1) End
Return WeekNumber *****************************************************************************8 Compile Function Week_Day(tempDate)
Mo = Oconv(tempDate,'D4-')[1,2] Da = Oconv(tempDate,'D4-')[4,2] Ce = Oconv(tempDate,'D4-')[7,2] Yr = Oconv(tempDate,'D4-')[9,2] Z = Int(2.6 * (Mo - 2 + 1 * 12 * (Mo < 3)) - 0.199) Z += Da +Yr -1*(Mo < 3) + Int((Yr - 1*(Mo < 3))/4) + Int(Ce / 4) - 2 * Ce Weekday = (Z-7*Int(Z/7))
Return Weekday
out of
found this valuable.
Do you find this valuable?
|
|
|
|
Existing conditions that cause problems with conversion
|
Converting to AREV32
|
1 |
Aug 20 2008, 9:52 AM EDT by
|
|
|
Thread started: Jun 23 2008, 9:12 AM EDT
Watch
* SYSINCLUDE had user-defined rows that were referenced in programs and dictionaries. * HELP was used as a repository of setup data. * OBJECT had user-defined dictionary equates that were referenced in programs and dictionaries. * VOC dictionary had custom items * VOC had many custom items * Menus: All had the value of the Application in field 2 of the menu record. Had to be removed in order to run it.
1
out of
1 found this valuable.
Do you find this valuable?
Do you?
Show Last Reply
|
|
Last Reply:
RE: Existing conditions that cause problems with conversion
By: ,
Aug 20 2008, 9:52 AM EDT
Found that the pre-compiler has problems where R/Basic keywords were used as labels and variable names:
e.g. GOSUB PRINT
e.g. SELECT = "whatever"
just adding "1" to the end cleared up the problems, PRINT1, SELECT1
out of
found this valuable.
Do you find this valuable?
|
|
|
dharmacek |
|
Bugs and workarounds version 8.0.6
|
Operating AREV32
|
2 |
Aug 20 2008, 9:49 AM EDT by
dharmacek |
|
|
Thread started: Jun 23 2008, 9:39 AM EDT
Watch
VIDCTRL appears when AREV32_...FORM is closed - Upon closing Arev32 an error message stating that $vidctrl was not found. Then the program closes properly. This was an assembler program called by Arev during closing. (patch available) (fixed in 8.0.7)
Resizing the Arev32 form:
This window can be resized like any Windows window by grabbing the lower right corner with the mouse and resizing it. You will notice that it automatically changes which font is used. A ratio can be chosen that looks good (and bad). Noticed that the menu character (a solid triangle/arrow) changes to a circle in some ratios.
ENVIRONMENT records not named for user don't work: (fixed in 8.0.7)
In Arev for DOS you could have an environment, like MGMT. Then, in the User (e.g. USER1) setup window (in SYSPROG) you could specify that a user's environment was MGMT. Then Arev would ignore the USER1_ENVIRONMENT row and use the MGMT_ENVIRONMENT as USER1 logged in. I have found that Arev32 allows you to specify a different environment row, but actually uses the one with the name of the user. (Bug Tracker issue 1001, fix sked 9.0)
LIST - If the option is not at the end of the command line, the option character causes an error: e.g. LIST CUSTOMERS (T) BY STATE returns an error about T not found (Bug Tracker issue 1006, patch available, fix sked for v9.0)
1
out of
1 found this valuable.
Do you find this valuable?
Do you?
Show Last Reply
|
Last Reply:
RE: Bugs and workarounds version 8.0.6
By: dharmacek,
Aug 20 2008, 9:49 AM EDT
"VIDCTRL appears when AREV32_...FORM is closed - Upon closing Arev32 an error message stating that $vidctrl was not found. Then the program closes properly. This was an assembler program called by Arev during closing. (patch available)
ENVIRONMENT records not named for user don't work
In Arev for DOS you could have an environment, like MGMT. Then, in the User (e.g. USER1) setup window (in SYSPROG) you could specify that a user's environment was MGMT. Then Arev would ignore the USER1_ENVIRONMENT row and use the MGMT_ENVIRONMENT as USER1 logged in. I have found that Arev32 allows you to specify a different environment row, but actually uses the one with the name of the user. (Bug Tracker issue 1001, fix sked 9.0) " Apparently fixed in version 8.0.7 VIDCTRL. ENVIRONMENT records not named for user don't work - now they work
out of
found this valuable.
Do you find this valuable?
|
|
|
|
|
replacement debugger
|
OpenInsight Community Source Code
|
0 |
Aug 8 2008, 2:53 AM EDT by
|
|
|
Thread started: Aug 8 2008, 2:53 AM EDT
Watch
Any chance of getting some replacement debugger examples posted, that also sends an email.
out of
found this valuable.
Do you find this valuable?
|
|
|
|
Screen appearance
|
Operating AREV32
|
2 |
Jul 16 2008, 8:12 PM EDT by
|
|
|
Thread started: Jun 23 2008, 9:48 AM EDT
Watch
The appearance of the Arev32 window was a disappointment to many users. The characters were deemed indistinct, even after adjustment for best appearance.
The default font used appears to be Courier New. This can be changed, see CTO configuration records and layout.
You can experiment with various monospaced fonts like: Courier New, default, resizes XP Fixedsys, does not resize XP Lucida Console, best appearance XP Consolas ugly from Microsoft Vera Sans Mono worse than Lucida Console from Bitstream
out of
found this valuable.
Do you find this valuable?
Show Last Reply
|
|
Last Reply:
RE: Screen appearance
By: ,
Jul 16 2008, 8:12 PM EDT
"I have failed to change the font. I have tried changing SYSENV CTO, reversed that and created MD CTO with "Lucida Console" in field <7>, altered it to "LUCIDA CONSOLE", deleted that and created CTO*BILLING (the account is BILLING and I log in as BILLING) and tried mixed case and upper case again, then tried Fixedsys. So, I've tried it 6 different ways and it stubbornly refuses to look any prettier. I do have Lucida Console, according to OpenOffice. BTW, it would have been useful it you could have pointed out that details of the CTO configuration record were linked to elsewhere on the page. I was wondering where the record was when I happened to notice the link." Sorry I didn't set up my advice to your satisfaction. I was using a local engine and java. I no longer remember how I switched from one font to the other, but it did change in appearance. I think I had to shut down OI, then start again.
out of
found this valuable.
Do you find this valuable?
|
|
|
|
|
Color in Text Box
|
Discussion Forum
|
2 |
Jul 8 2008, 2:24 AM EDT by
|
|
|
Thread started: Jun 27 2008, 2:06 AM EDT
Watch
Is it possible to change the colors of individual lines of text in a Text Box. The purpose is to run side by side text boxes highlighting direrences (compare) in source code. Colorising individual cells in an edit table seems a lot of trouble...
Thanks
out of
found this valuable.
Do you find this valuable?
Show Last Reply
|
|
Last Reply:
RE: Color in Text Box
By: ,
Jul 8 2008, 2:24 AM EDT
Thanks will give it a try. It is for static protected display only, so should be ok. Reading the rtf spec is not going to be much fun.
out of
found this valuable.
Do you find this valuable?
|
|
|
|
|
Source line error
|
RGD Application Remove Source
|
0 |
Jul 7 2008, 12:21 AM EDT by
|
|
|
Thread started: Jul 7 2008, 12:21 AM EDT
Watch
Val = Repository(EntIds<J>,"DESTROY")
Should be:
Val = Repository("DESTROY",EntIds<J>)
out of
found this valuable.
Do you find this valuable?
|
|
|
|
DEBUGGER
|
Operating AREV32
|
0 |
Jun 23 2008, 9:41 AM EDT by
|
|
|
Thread started: Jun 23 2008, 9:41 AM EDT
Watch
* There is a place to specify you want to retain the precompiled code in the Database Manager / Environment Settings / AREV32 Settings.
* If you place a DEBUG statement in SOURCE, it reports the line number in OI_PRECOMPILED_CODE, which is different from your SOURCE if you have any $INSERT records.
* There appears to be a new symbolic row with a @ prefix.
1
out of
1 found this valuable.
Do you find this valuable?
Do you?
|
|
|
|
Careful
|
Operating AREV32
|
0 |
Jun 23 2008, 9:40 AM EDT by
|
|
|
Thread started: Jun 23 2008, 9:40 AM EDT
Watch
Be careful when holding down a key. It will repeat many, many, many more times than in the ArevDOS version!
Occasionally you will have to re-touch a key to get it recognized. We call it "going to sleep". I found the Left-arrow is best key to press when resuming.
out of
found this valuable.
Do you find this valuable?
|
|
dharmacek |
|
CTO Configuration records and layout
|
Operating AREV32
|
1 |
Jun 23 2008, 9:35 AM EDT by
dharmacek |
|
|
Thread started: Jun 23 2008, 9:32 AM EDT
Watch
CTO has a configuration record named CTO in SYSENV.
The above can be overwritten by a configuration record named CTO in the table MD of the application.
The above can be overwritten by a configuration record named CTO*<username) in the table MD of the application.
Layout is all the same:
out of
found this valuable.
Do you find this valuable?
Show Last Reply
|
Last Reply:
RE: CTO Configuration records and layout
By: dharmacek,
Jun 23 2008, 9:35 AM EDT
Configuration record layout
Field# Description /Comments 1 IP Address of engineserver, or path to revcap32.dll . for local engine 2 Port number 8088 default 3 foreground color name 4 background color name 5 title of Arev32 frame 6 routine to run 7 font name defaults to Courier New
out of
found this valuable.
Do you find this valuable?
|
|
|
|
|
Which CTO form to use
|
Operating AREV32
|
0 |
Jun 23 2008, 9:30 AM EDT by
|
|
|
Thread started: Jun 23 2008, 9:30 AM EDT
Watch
Two OI/CTO forms are provided:
AREV32_STANDALONE_FORM
This form appears separately from the OI windows. It can be moved and sized outside of OI.
AREV32_CHILD_FORM
This form is a MDI Child and appears within the MDI Frame.
Can we use the Arev32 as a tab page in OI? We will continue to have a hybrid system, some in OI 8 and some in Arev32. I have found the CHILD_FORM for use in MDI.
per RevSoft: "You can not open it in a tab control but you can maneuver the window to act like it is. Click the tab and make it visible and size it to fit with the table."
PM decided to use only the STANDALONE_FORM and have OpenInsight running as well.
(version 8.0.6)
out of
found this valuable.
Do you find this valuable?
|