From simon at dmservices.co.uk Thu Jan 1 10:19:50 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Thu Jan 1 10:20:29 2004 Subject: Walkthrough on setting up jDP Message-ID: <004001c3d07a$b34e0c50$7700a8c0@spvmobile> I'm trying to play with jDP over the new year. I'm using jBase 4.1.3 and jbase 3.4.5 (I have both installed on my development system). I'm looking for a simple walkthrough to get jDP up and running - I simply want to be able to demonstrate importing data into Excel (or some other application) using ODBC from my jBase data file. Anybody got any pointers for me to start?? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: HYPERLINK "mailto:simon@dmservices.co.uk"simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at HYPERLINK "mailto:info@dmservices.co.uk"info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.5.5 - Release Date: 30/12/2003 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040101/0c332b61/attachment.htm From tom at proman.com Thu Jan 1 12:06:37 2004 From: tom at proman.com (Tom Turkington) Date: Thu Jan 1 12:10:02 2004 Subject: Walkthrough on setting up jDP In-Reply-To: <004001c3d07a$b34e0c50$7700a8c0@spvmobile> Message-ID: MessageSimon, I had some problems with jdp the few times I worked with it. I believe you actually need to run the jBase Dict Configurator at least once for it to work... The Dict Configurator is not part of a standard jbase (Win32) install. You need to select "Custom" and then select "Dict Configurator" then install. A couple of other issues: The Dict Configurator appears to read "all" dicts for files in your jedifilepath and MD (i.e.: "Q" pointers, "F" pointers) before it actually loads. For my dev environment, this meant I had to wait 2 to 5 minutes before it would load; i.e.: best to work with a limited file set when testing. Also, JDP failed completely if it couldn't resolve dictionaries; i.e.: if there was a translate to a file that it couldn't find, or if the dictionary was otherwise invalid. Otherwise, once you run jDC, create a new Data Source (I believe I did this straight from MSExcel via Get External Data, but can also be done via Admin Tools -> Data Sources): Driver type is Attunity Connect Description can be (I believe) anything appropriate... I believe you can probably use THEENTIRESYSTEM (the default?) for the actual data source, or you can click the "New" button to define your own. You can probably just "EDIT" the THEENTIRESYSTEM entry to see how these are defined: The source can either be local or remote: remote needs to have the Attunity Connect server running. I believe, but am not certain, that the "Attunity Connect Data Source Name" refers to the name defined via jDC (Dict Configurator..) Datasource Type: JDP (not in drop down list...) Connect String: I have "TABLEFILE=C:\HOME\LOCAL.JDP.TABLE" - where the Table File is a jBase File where each item represents a filename that jDP can see, where Attrib 1 is the Path to that file, and Attrib 2 is the Path to the Dict of that file. The Connect String is not necessary but the TABLEFILE is used to limit the number of files jDP will look at; i.e.: the files defined in the table file are the only files visible via the given data source.... At this point I believe you cross your fingers and click "Finish". Last I tested (last spring/summer) the "ReadOnly" flags (set via jDC) weren't working. I reported this to devsup, but never heard whether it was actually fixed. Haven't looked again. Also, note: jDC writes extraneous information to the DICTS of your files; i.e.: in attribs 30-47 (?) of existing DICT items. Tom -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com]On Behalf Of Simon Verona Sent: Thursday, January 01, 2004 7:20 AM To: tech@listserver.jbase.com Subject: Walkthrough on setting up jDP I'm trying to play with jDP over the new year. I'm using jBase 4.1.3 and jbase 3.4.5 (I have both installed on my development system). I'm looking for a simple walkthrough to get jDP up and running - I simply want to be able to demonstrate importing data into Excel (or some other application) using ODBC from my jBase data file. Anybody got any pointers for me to start?? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.5.5 - Release Date: 30/12/2003 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040101/ee5a0474/attachment.htm From simon at dmservices.co.uk Thu Jan 1 12:53:27 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Thu Jan 1 12:53:52 2004 Subject: Walkthrough on setting up jDP In-Reply-To: Message-ID: <004e01c3d090$2952dbf0$7700a8c0@spvmobile> Tom Thanks for the speedy and detailed reply... I'll give it a go. Regards Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: HYPERLINK "mailto:simon@dmservices.co.uk"simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at HYPERLINK "mailto:info@dmservices.co.uk"info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Tom Turkington Sent: 01 January 2004 17:07 To: tech@listserver.jbase.com Subject: RE: Walkthrough on setting up jDP Simon, I had some problems with jdp the few times I worked with it. I believe you actually need to run the jBase Dict Configurator at least once for it to work... The Dict Configurator is not part of a standard jbase (Win32) install. You need to select "Custom" and then select "Dict Configurator" then install. A couple of other issues: The Dict Configurator appears to read "all" dicts for files in your jedifilepath and MD (i.e.: "Q" pointers, "F" pointers) before it actually loads. For my dev environment, this meant I had to wait 2 to 5 minutes before it would load; i.e.: best to work with a limited file set when testing. Also, JDP failed completely if it couldn't resolve dictionaries; i.e.: if there was a translate to a file that it couldn't find, or if the dictionary was otherwise invalid. Otherwise, once you run jDC, create a new Data Source (I believe I did this straight from MSExcel via Get External Data, but can also be done via Admin Tools -> Data Sources): Driver type is Attunity Connect Description can be (I believe) anything appropriate... I believe you can probably use THEENTIRESYSTEM (the default?) for the actual data source, or you can click the "New" button to define your own. You can probably just "EDIT" the THEENTIRESYSTEM entry to see how these are defined: The source can either be local or remote: remote needs to have the Attunity Connect server running. I believe, but am not certain, that the "Attunity Connect Data Source Name" refers to the name defined via jDC (Dict Configurator..) Datasource Type: JDP (not in drop down list...) Connect String: I have "TABLEFILE=C:\HOME\LOCAL.JDP.TABLE" - where the Table File is a jBase File where each item represents a filename that jDP can see, where Attrib 1 is the Path to that file, and Attrib 2 is the Path to the Dict of that file. The Connect String is not necessary but the TABLEFILE is used to limit the number of files jDP will look at; i.e.: the files defined in the table file are the only files visible via the given data source.... At this point I believe you cross your fingers and click "Finish". Last I tested (last spring/summer) the "ReadOnly" flags (set via jDC) weren't working. I reported this to devsup, but never heard whether it was actually fixed. Haven't looked again. Also, note: jDC writes extraneous information to the DICTS of your files; i.e.: in attribs 30-47 (?) of existing DICT items. Tom -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com]On Behalf Of Simon Verona Sent: Thursday, January 01, 2004 7:20 AM To: tech@listserver.jbase.com Subject: Walkthrough on setting up jDP I'm trying to play with jDP over the new year. I'm using jBase 4.1.3 and jbase 3.4.5 (I have both installed on my development system). I'm looking for a simple walkthrough to get jDP up and running - I simply want to be able to demonstrate importing data into Excel (or some other application) using ODBC from my jBase data file. Anybody got any pointers for me to start?? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: HYPERLINK "mailto:simon@dmservices.co.uk"simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at HYPERLINK "mailto:info@dmservices.co.uk"info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.5.5 - Release Date: 30/12/2003 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.5.5 - Release Date: 30/12/2003 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.5.5 - Release Date: 30/12/2003 -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040101/f27e8bc3/attachment.htm From dfiler at cookvascular.com Mon Jan 5 08:45:53 2004 From: dfiler at cookvascular.com (Darrin Filer) Date: Mon Jan 5 08:49:51 2004 Subject: Walkthrough on setting up jDP In-Reply-To: <004e01c3d090$2952dbf0$7700a8c0@spvmobile> References: Message-ID: <5.1.0.14.2.20040105082522.00b29dc0@pop3.cookvascular.com> Also note (at least on our RH6.2 box with jbase 3.4.2) that DICTs with any non-absolute file paths in T conversions will cause any jDP query involving that dictionary to fail. Whew... that could save you hours of time. ;-) Darrin Filer >Thanks for the speedy and detailed reply... I'll give it a go. From lburst at dynamicsys.com Mon Jan 5 16:17:03 2004 From: lburst at dynamicsys.com (Lee H. Burstein) Date: Mon Jan 5 16:17:08 2004 Subject: Independent Again Message-ID: Many of you may know me as the Director of Professional Services for jBASE International, Inc. While there, I have worked with many VARs and end-users on various training and consulting projects. Prior to joining jBASE I had my own consulting/training company where I developed much of the jBASE training material in use today. As of the New Year, I am no longer employed by jBASE and have reactivated Dynamic Systems full time. Please do not hesitate to contact me if I may be of any assistance to you, your customers or your end-users. Have a healthy, happy and prosperous New Year. Lee H. Burstein President Dynamic Systems, Inc. 302-477-0180 FAX: 413-653-9316 www.dynamicsys.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 1972 bytes Desc: not available Url : http://listserver.jbase.com/pipermail/tech/attachments/20040105/fb989c53/winmail.bin From Results at KeyAlly.com Mon Jan 5 16:56:30 2004 From: Results at KeyAlly.com (Results) Date: Mon Jan 5 16:56:26 2004 Subject: Independent Again In-Reply-To: References: Message-ID: <3FF9DD8E.8000506@KeyAlly.com> Lee, Best of luck. I'm sorry to hear that you and jBASE parted ways. - Charles Barouch Results@KeyAlly.com Lee H. Burstein wrote: >Many of you may know me as the Director of Professional Services for jBASE >International, Inc. While there, I have worked with many VARs and end-users >on various training and consulting projects. > >Prior to joining jBASE I had my own consulting/training company where I >developed much of the jBASE training material in use today. As of the New >Year, I am no longer employed by jBASE and have reactivated Dynamic Systems >full time. > >Please do not hesitate to contact me if I may be of any assistance to you, >your customers or your end-users. > >Have a healthy, happy and prosperous New Year. > >Lee H. Burstein >President >Dynamic Systems, Inc. >302-477-0180 >FAX: 413-653-9316 >www.dynamicsys.com > > > From AMassey at Trustee.bc.ca Mon Jan 5 18:10:59 2004 From: AMassey at Trustee.bc.ca (Massey, Aiden) Date: Mon Jan 5 18:11:06 2004 Subject: Active Form Queue Message-ID: <909DA7929DF95E4AA7240C8733562EE5018CC7EC@opt02.pgt.local> JBC how do get the name of the currently active form queue for the current user. Is a function or system variable available? Cheers Aiden -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040105/2e810e1c/attachment.htm From mark at proman.com Mon Jan 5 18:33:26 2004 From: mark at proman.com (Mark Hogden) Date: Mon Jan 5 18:35:37 2004 Subject: Active Form Queue In-Reply-To: <909DA7929DF95E4AA7240C8733562EE5018CC7EC@opt02.pgt.local> Message-ID: <20040105233327.8F56039E8B@mail.blarg.net> The spooler function, SPOOLER(n{, Port|User}), is probably what you need. http://www.jbase.com/knowledgebase/manuals/3.0/30manpages/man/jbc2_SPOOLER.h tm Mark Hogden Proco, Inc. ________________________________ From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Massey, Aiden Sent: Monday, January 05, 2004 3:11 PM To: tech@listserver.jbase.com Subject: Active Form Queue JBC how do get the name of the currently active form queue for the current user. Is a function or system variable available? Cheers Aiden From danielk at jbase.com Mon Jan 5 18:41:12 2004 From: danielk at jbase.com (Daniel Klein) Date: Mon Jan 5 18:41:15 2004 Subject: Active Form Queue Message-ID: The problem with this question is there could be more than one active formqueue in use at any one particular moment because the user could be logged in and printing from more than one port and/or on multiple print channels. That said, SPOOLER(2) contains a detailed list of all print jobs, including the status and user information. But which one is it? ;-) What is the actual problem you are trying to solve? Dan -----Original Message----- From: Massey, Aiden [mailto:AMassey@Trustee.bc.ca] Sent: Monday, January 05, 2004 3:11 PM To: tech@listserver.jbase.com Subject: Active Form Queue JBC how do get the name of the currently active form queue for the current user. Is a function or system variable available? Cheers Aiden -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040105/da8a4ea4/attachment.htm From PerryT at zirmed.com Mon Jan 5 18:41:58 2004 From: PerryT at zirmed.com (Perry Taylor) Date: Mon Jan 5 18:42:23 2004 Subject: Active Form Queue Message-ID: This might be what you're looking for.... http://www.jbase.com/knowledgebase/manuals/3.0/30manpages/man/jbc2_SPOOLER.htm Perry Taylor Zirmed, Inc. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com]On Behalf Of Massey, Aiden Sent: Monday, January 05, 2004 4:11 PM To: tech@listserver.jbase.com Subject: Active Form Queue JBC how do get the name of the currently active form queue for the current user. Is a function or system variable available? Cheers Aiden CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed.com, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040105/6ac0c3b7/attachment.htm From call.srs at verizon.net Mon Jan 5 20:57:24 2004 From: call.srs at verizon.net (Peter Mowatt) Date: Mon Jan 5 20:56:47 2004 Subject: Active Form Queue In-Reply-To: <909DA7929DF95E4AA7240C8733562EE5018CC7EC@opt02.pgt.local> References: <909DA7929DF95E4AA7240C8733562EE5018CC7EC@opt02.pgt.local> Message-ID: <3FFA1604.6000406@verizon.net> Hello Aiden. I am pretty sure that what you are talking about can be captured from SP-ASSIGN ? at TCL. I wrote a program that basicly executes the SP-ASSIGN ? and captures the output. Then I extract that. Give it a go. Peter Massey, Aiden wrote: > JBC how do get the name of the currently active form queue for the > current user. Is a function or system variable available? > > Cheers > Aiden > From kevin at pricetrak.com Tue Jan 6 06:17:41 2004 From: kevin at pricetrak.com (Kevin Thorpe) Date: Tue Jan 6 07:06:32 2004 Subject: Problems with SYSTEM files on a Samba share Message-ID: <3FFA9955.3060304@pricetrak.com> I have an application residing on a Samba share (J:). There are some shared files in the root of this share and several user accounts in sub-directories: J:\Pricetrak - shared files and code J:\Pricetrak_UK - UK database J:\Pricetrak_RSA - RSA database I have an MD file in each user account with Q-pointers to the shared files: in: J:\Pricetrak\Pricetrak_UK MD PRODUCTS 001 Q 002 Pricetrak 003 PRODUCTS I have a SYSTEM file (j:\WINSYSTEM to differentiate from real SYSTEM) in: J:\Pricetrak WINSYSTEM Pricetrak 001 D 002 J:\Pricetrak I have the following in jsetkey JBCRELEASEDIR=C:\JBASE30 JBCGLOBALDIR=C:\JBASE30 JBC_PATCHLEVEL=0082 JBC_VERSION=3.2.3 JBC_PROCESSOR_ARCHITECTURE=ix86 HOME=J:\Pricetrak_UK JEDIFILENAME_SYSTEM=J:\WINSYSTEM JEDIFILENAME_MD=J:\Pricetrak_UK\MD I can: LIST J:\PRODUCTS LIST J:\WINSYSTEM LIST MD ....but LIST PRODUCTS comes up with a 201 file not found. can anyone explain why? -- Kevin Thorpe Head of IT *Purchasing Index (UK) Limited * ------------------------------------------------------------------------ All views or opinions expressed in this message are solely those of the author. Accordingly, Purchasing Index Ltd does not accept responsibility for the contents of the message unless specifically stated otherwise. If you have received this message in error, please notify the sender and delete the message immediately. From kevin at pricetrak.com Tue Jan 6 07:20:20 2004 From: kevin at pricetrak.com (Kevin Thorpe) Date: Tue Jan 6 07:18:48 2004 Subject: Problems with SYSTEM files on a Samba share In-Reply-To: <3FFA9955.3060304@pricetrak.com> References: <3FFA9955.3060304@pricetrak.com> Message-ID: <3FFAA804.6010904@pricetrak.com> Kevin Thorpe wrote: Never mind - brain addled from Christmas and New Year (hic). Corrections follow: > I have an application residing on a Samba share (J:). There are some > shared files in the root of this share and several user accounts in > sub-directories: > J:\Pricetrak - shared files and code > J:\Pricetrak_UK - UK database > J:\Pricetrak_RSA - RSA database J:\ - shared files J:\Pricetrak_UK - UK database J:\Pricetrak_RSA - RSA database > > I have an MD file in each user account with Q-pointers to the shared > files: > in: J:\Pricetrak_UK MD > PRODUCTS > 001 Q > 002 Pricetrak > 003 PRODUCTS > > I have a SYSTEM file (j:\WINSYSTEM to differentiate from real SYSTEM) > in: J:\ WINSYSTEM > Pricetrak > 001 D > 002 J:\Pricetrak 002 J:\ > > I have the following in jsetkey > JBCRELEASEDIR=C:\JBASE30 > JBCGLOBALDIR=C:\JBASE30 > JBC_PATCHLEVEL=0082 > JBC_VERSION=3.2.3 > JBC_PROCESSOR_ARCHITECTURE=ix86 > HOME=J:\Pricetrak_UK > JEDIFILENAME_SYSTEM=J:\WINSYSTEM > JEDIFILENAME_MD=J:\Pricetrak_UK\MD > > I can: > LIST J:\PRODUCTS > LIST J:\WINSYSTEM > LIST MD > ....but > LIST PRODUCTS comes up with a 201 file not found. > > can anyone explain why? Too many beers ;-) -- Kevin Thorpe Head of IT *Purchasing Index (UK) Limited * ------------------------------------------------------------------------ All views or opinions expressed in this message are solely those of the author. Accordingly, Purchasing Index Ltd does not accept responsibility for the contents of the message unless specifically stated otherwise. If you have received this message in error, please notify the sender and delete the message immediately. From LPata at dgn-marketing.com Tue Jan 6 10:10:20 2004 From: LPata at dgn-marketing.com (Lucian Pata) Date: Tue Jan 6 10:10:28 2004 Subject: Problems with SYSTEM files on a Samba share Message-ID: <3A3924FD0ABE3A4D9C7D52055D4F2D4104341A@dgnexchange01.dgn-marketing.com> Hi Kevin, It looks like you want to have a Q pointer to Q pointer reference. Check the "Pricetrak" definition. I don't think that "D" is a valid type. Pricetrak 001 D 002 J:\Pricetrak PRODUCTS 001 Q 002 Pricetrak 003 PRODUCTS Q pointer to Q pointer references are not resolved by default. To enable this feature you have to set the environment variable JEDIENABLEQ2Q. "I have a SYSTEM file (j:\WINSYSTEM to differentiate from real SYSTEM)" It's not clear if "j:\WINSYSTEM" is seen by jBASE or not, probably not. Try changing PRODUCTS to PRODUCTS 001 Q 002 J:\Pricetrak 003 PRODUCTS or better, if you want to keep the "Pricetrak" outside the scope of the SYSTEM file, use a F pointer PRODUCTS 001 F 002 J:\Pricetrak\PRODUCTS 003 J:\Pricetrak\PRODUCTS]D For more info also check http://www.jbase.com/knowledgebase/manuals/3.0/30manpages/man/sup22_QPOINTERS.htm Hope this helps, Lucian -----Original Message----- From: Kevin Thorpe [mailto:kevin@pricetrak.com] Sent: Tuesday, January 06, 2004 7:20 AM To: tech@listserver.jbase.com Subject: Re: Problems with SYSTEM files on a Samba share Kevin Thorpe wrote: Never mind - brain addled from Christmas and New Year (hic). Corrections follow: > I have an application residing on a Samba share (J:). There are some > shared files in the root of this share and several user accounts in > sub-directories: > J:\Pricetrak - shared files and code > J:\Pricetrak_UK - UK database > J:\Pricetrak_RSA - RSA database J:\ - shared files J:\Pricetrak_UK - UK database J:\Pricetrak_RSA - RSA database > > I have an MD file in each user account with Q-pointers to the shared > files: > in: J:\Pricetrak_UK MD > PRODUCTS > 001 Q > 002 Pricetrak > 003 PRODUCTS > > I have a SYSTEM file (j:\WINSYSTEM to differentiate from real SYSTEM) > in: J:\ WINSYSTEM > Pricetrak > 001 D > 002 J:\Pricetrak 002 J:\ > > I have the following in jsetkey > JBCRELEASEDIR=C:\JBASE30 > JBCGLOBALDIR=C:\JBASE30 > JBC_PATCHLEVEL=0082 > JBC_VERSION=3.2.3 > JBC_PROCESSOR_ARCHITECTURE=ix86 > HOME=J:\Pricetrak_UK > JEDIFILENAME_SYSTEM=J:\WINSYSTEM > JEDIFILENAME_MD=J:\Pricetrak_UK\MD > > I can: > LIST J:\PRODUCTS > LIST J:\WINSYSTEM > LIST MD > ....but > LIST PRODUCTS comes up with a 201 file not found. > > can anyone explain why? Too many beers ;-) -- Kevin Thorpe Head of IT *Purchasing Index (UK) Limited * ------------------------------------------------------------------------ All views or opinions expressed in this message are solely those of the author. Accordingly, Purchasing Index Ltd does not accept responsibility for the contents of the message unless specifically stated otherwise. If you have received this message in error, please notify the sender and delete the message immediately. From gcalvin at kenwoodusa.com Tue Jan 6 15:20:03 2004 From: gcalvin at kenwoodusa.com (Gary Calvin) Date: Tue Jan 6 15:20:57 2004 Subject: Problems with SYSTEM files on a Samba share Message-ID: Of course, to do this "the jBASE way" you might do something like: JBCRELEASEDIR=C:\JBASE30 JBCGLOBALDIR=C:\JBASE30 JBC_PATCHLEVEL=0082 JBC_VERSION=3.2.3 JBC_PROCESSOR_ARCHITECTURE=ix86 HOME=J:\Pricetrak_UK JEDIFILEPATH=%HOME%;%JEDIFILEPATH% or maybe... JEDIFILEPATH=%JEDIFILEPATH%;%HOME% (because you might not want to have a network path at the beginning of your file search path.) and forget about the MD and SYSTEM setup altogether. This has the advantage (or disadvantage, depending on what you want) that any new file dropped into the HOME directory will be usable without creating any Q-pointers. -Gary- From AMassey at Trustee.bc.ca Tue Jan 6 15:41:14 2004 From: AMassey at Trustee.bc.ca (Massey, Aiden) Date: Tue Jan 6 15:41:25 2004 Subject: Active Form Queue Message-ID: <909DA7929DF95E4AA7240C8733562EE5019B77CC@opt02.pgt.local> I was asked to state the problem so BACKGROUND Converting from Universe 10 to Jbase, windows 2000 server, windows 2000 clients 30+ printers. Various types laser jets, dedicated cheque printers etc. Various combinations of letter and legal paper, single side and duplex printing Multiple page lengths and width Multiple line spacing Multiple fonts ISSUE Trying to duplicate functionality of Universe SETPTR command in Universe. All references to SETPTR mean Universe style SETPTR. By writing a replacement program for Universe style SETPTR no changes required to existing system. Also using SETPTR MODE 3 in Universe to direct print output to a hold file. The output is used for file transfers and as email attachments. Thanks to Dan at Jbase I have this part working. SOLUTION Wrote a replacement program for SETPTR called JSETPTR. Parse SETPTR style arguments passed to JSETPTR Channel Always 0 Page Length and Width Can determine which jspform_ to use to control page length and width. Naming convention for jspform_ printernameLnnWnn. Example jspform_crmL60W132, printer crm page length 60 page width 132 If the required jspform_ does not exist the program creates it. Line Spacing JSETPTR sends control codes to printer Fonts JSETPTR sends control codes to printer The following are already controlled by windows printing based on printer name. Each physical printer has multiple Windows printer names Paper size Orientation Single sided or duplex Note. The existing system has 80+ possible windows printer definitions but each user only has 2 or 3 printers defined for their work station. PROBLEM 1. Universe SETPTR parameters are optional. Calling program might only specify changing page width. No printer name or page length passed. Changing page length would require a different jspform_. I need to know current form name to parse printer name and width to change active form queue used. May also require creating new jspform_ if first time requested. 2. Need to know if form queue name already exists otherwise SP-CREATE generates error message. Assume I can use spooler() to get that information QUESTION Commands SP-LOOK or SP-STATUS ? return the information I require to get JSETPTR working. I just want to use the same logic these commands use inside a program. Parsing the results of EXECUTE "SP-LOOK" CAPTURING RESULTS works but it means getting passed the column header information and other stuff to return the 1 piece of information I require. Also paranoid that SP-LOOK etc might change output format in future releases. Internal functions less likely to change. Universe documentation for !SET.PTR http://www-306.ibm.com/software/data/u2/pubs/library/100univ/8744.pdf page 1340 Apologies if I screwed up some terminology, new to Jbase. Cheers Aiden Massey -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040106/ccae8fe5/attachment.htm From danny.ruckel at activant.com Tue Jan 6 15:53:08 2004 From: danny.ruckel at activant.com (Danny Ruckel) Date: Tue Jan 6 15:51:08 2004 Subject: Active Form Queue Message-ID: <08BF8C21477B3A449ED45635C75A307CED8ECD@exch3-dc-aus.northamerica.corporate-domain.net> Skipped content of type multipart/alternative-------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: image/jpeg Size: 2208 bytes Desc: image001.jpg Url : http://listserver.jbase.com/pipermail/tech/attachments/20040106/9a31a09b/attachment.jpg From kevin at pricetrak.com Wed Jan 7 07:46:44 2004 From: kevin at pricetrak.com (Kevin Thorpe) Date: Wed Jan 7 07:45:12 2004 Subject: Problems with SYSTEM files on a Samba share In-Reply-To: References: Message-ID: <3FFBFFB4.4000105@pricetrak.com> Gary Calvin wrote: >Of course, to do this "the jBASE way" you might do something like: > > JBCRELEASEDIR=C:\JBASE30 > JBCGLOBALDIR=C:\JBASE30 > JBC_PATCHLEVEL=0082 > JBC_VERSION=3.2.3 > JBC_PROCESSOR_ARCHITECTURE=ix86 > HOME=J:\Pricetrak_UK > JEDIFILEPATH=%HOME%;%JEDIFILEPATH% > >or maybe... > > JEDIFILEPATH=%JEDIFILEPATH%;%HOME% > (because you might not want to have a network path at the > beginning of your file search path.) > >and forget about the MD and SYSTEM setup altogether. This has the >advantage (or disadvantage, depending on what you want) that any >new file dropped into the HOME directory will be usable without >creating any Q-pointers. > > Sounds like a good idea to me. I didn't realise that I could specify several paths for opening files. That makes it easy, simply add .. (dot dot) to the filepath. Any files not in the current home dir will be found in the directory above. The hard part about jBase is to selectively forget all you've learned about PICK. -- Kevin Thorpe Head of IT *Purchasing Index (UK) Limited * ------------------------------------------------------------------------ All views or opinions expressed in this message are solely those of the author. Accordingly, Purchasing Index Ltd does not accept responsibility for the contents of the message unless specifically stated otherwise. If you have received this message in error, please notify the sender and delete the message immediately. From dthiot at mavsys.com Wed Jan 7 09:03:09 2004 From: dthiot at mavsys.com (Dick Thiot) Date: Wed Jan 7 09:02:36 2004 Subject: Problems with SYSTEM files on a Samba share In-Reply-To: <3FFBFFB4.4000105@pricetrak.com> Message-ID: <200401070801609.SM08748@ltdthiot> Kevin Thorpe wrote: >The hard part about jBase is to selectively forget all you've learned about PICK. This may be the most insightful comment ever made on this newsgroup! From kerid at jbase.com Fri Jan 9 10:52:03 2004 From: kerid at jbase.com (Keri Duffy) Date: Fri Jan 9 11:07:48 2004 Subject: jDP Training Message-ID: jDP Training Open your user's world to XML, OLE DB, JDBC... You've heard the buzz words, now put them to work for you! It's not too late...space still available! Register for 4 days working with jBASE Data Provider - the link to standards like ODBC, OLE DB, XML, etc. Students will learn the various installation and server/client configuration options available in the jBASE Data Provider (jDP) product. Additionally, various data access methods will be covered, such as: ODBC, JDBC and XML. Client applications like ASP, Visual Basic, Excel, Access and Crystal Reports will be discussed and/or used. Includes configuration and mapping of Multivalue Data. February 17-20, 2004 Pleasanton, CA Register today! For more information contact: jBASE International Phone: +1 518 581 1242 Fax: +1 508 628 4078 Email: training@jBASE.com URL: http://www.jBASE.com (c) Copyright 2004 jBASE International. jBASE(r) and the jBASE logo are registered trademarks of TEMENOS Holdings NV. These trademarks are owned by TEMENOS Holdings NV. Copyright in the jBASE logos, OBjEX, jBASE jEDI, and jBC is Copyright (c) 2004 TEMENOS Holdings NV. All other trademarks are the property of their respective owners. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040109/44d0ffc0/attachment.htm From AMassey at Trustee.bc.ca Fri Jan 9 12:07:55 2004 From: AMassey at Trustee.bc.ca (Massey, Aiden) Date: Fri Jan 9 12:08:04 2004 Subject: Printing Problem Message-ID: <909DA7929DF95E4AA7240C8733562EE5018CC7F0@opt02.pgt.local> Jbase 3.4.6 Windows 2000 Server Printing not working. Print jobs appear to go through spooler ok but print nowhere. Tested Form queue using deflt form and main printer as device. Where do I start looking for problems? Spooler initialization documentation states "The spooler can be set up as a service on Windows NT or Windows 2000 .". Is this required and if so what is the service name? Cheers Aiden -------------- next part -------------- An HTML attachment was scrubbed... URL: http://listserver.jbase.com/pipermail/tech/attachments/20040109/f1f70e65/attachment.htm From pprivately at wp.pl Mon Jan 12 05:23:16 2004 From: pprivately at wp.pl (Pawel (privately)) Date: Mon Jan 12 05:25:27 2004 Subject: CATALOG details Message-ID: <4002759470c6e@wp.pl> Hello! Can anyone tell me what exactly does jBASE "CATALOG" command? Please give me as much as details you can. Unfortunately I am running on AIX and do not have sufficient rights to run "trace" to get this knowledge (in fact do not know "trace" command well - I have used recently "strace" on *nix machines). Kindly regards Pawel ---------------------------------------------------- Leonardo da Vinci w Warszawie! Geniusz i jego machiny na wystawie w Pa?acu Kultury! Zobacz koniecznie: http://klik.wp.pl/?adr=www.leonardo.wp.pl&sid=91 From simon at dmservices.co.uk Mon Jan 12 05:49:43 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Mon Jan 12 05:50:04 2004 Subject: CATALOG details In-Reply-To: <4002759470c6e@wp.pl> Message-ID: <007801c3d8f9$c9ecedf0$7700a8c0@spvmobile> I don't know the exact technicalities, but. The catalog command takes the object created by the BASIC command (stored in the program file as the program name preceded with a $ sign), and passes this through to the c-compiler to build/link and either build an executeable or a shared library/dll (depending on whether it's Windows or Unix. I think running CATALOG with a (V option will show more in depth actually what goes on. Also, check out http://www.jbase.com/knowledgebase/manuals/3.0/30manpages/man/sup42_CATALOG. htm HTH Regards Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Pawel (privately) Sent: 12 January 2004 10:23 To: tech@listserver.jbase.com Subject: CATALOG details Hello! Can anyone tell me what exactly does jBASE "CATALOG" command? Please give me as much as details you can. Unfortunately I am running on AIX and do not have sufficient rights to run "trace" to get this knowledge (in fact do not know "trace" command well - I have used recently "strace" on *nix machines). Kindly regards Pawel ---------------------------------------------------- Leonardo da Vinci w Warszawie! Geniusz i jego machiny na wystawie w Pa?acu Kultury! Zobacz koniecznie: http://klik.wp.pl/?adr=www.leonardo.wp.pl&sid=91 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From pprivately at wp.pl Mon Jan 12 07:14:46 2004 From: pprivately at wp.pl (Pawel (privately)) Date: Mon Jan 12 07:14:56 2004 Subject: CATALOG details In-Reply-To: <007801c3d8f9$c9ecedf0$7700a8c0@spvmobile> References: <007801c3d8f9$c9ecedf0$7700a8c0@spvmobile> Message-ID: <40028fb63a63f@wp.pl> Hello! Thanks for answer. Good for start, but my friend (co-worker) would like to know more details. So if he get any other details than these mentioned by you or in documentation I will post an email. Regards Pawel ---------------------------------------------------- Leonardo da Vinci w Warszawie! Geniusz i jego machiny na wystawie w Pa?acu Kultury! Zobacz koniecznie: http://klik.wp.pl/?adr=www.leonardo.wp.pl&sid=91 From eduardo.fuentealba at geoffpenney.com.au Mon Jan 12 16:31:10 2004 From: eduardo.fuentealba at geoffpenney.com.au (Eduardo Jacob Fuentealba) Date: Mon Jan 12 16:14:14 2004 Subject: asp.net and jBase Message-ID: <02b401c3d953$65831bf0$0c011dac@gpa.pennet> Hi There, Anyone have some examples of calling a jBase subroutine using OBjEX from an asp.net page? Regards, Eduardo From simon at dmservices.co.uk Mon Jan 12 16:25:43 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Mon Jan 12 16:26:06 2004 Subject: Logging Changes in Editor In-Reply-To: <40028fb63a63f@wp.pl> Message-ID: <012401c3d952$a30d7660$7700a8c0@spvmobile> Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From gcalvin at kenwoodusa.com Mon Jan 12 16:42:34 2004 From: gcalvin at kenwoodusa.com (Gary Calvin) Date: Mon Jan 12 16:42:06 2004 Subject: Logging Changes in Editor Message-ID: > From: Simon Verona > > I'm trying to automatically log changes made to all files made by our > support staff using the editor (ED/JED). I thought about > writing a wrapper > around the ED/JED commands to do the job, but the more I > think about it, the > more difficult it gets.. > Yeah, this does seem a little tricky. My first inclination would be to use a write trigger, but you want this to apply to ALL files. Still, the wrapper approach isn't TOO horrible, is it? You can test to see if there is a select list active, and process it appropriately -- except how do you deal with an 'exk' exit from JED? I wonder if there's any way to detect that. -Gary- From doug at s7.com Mon Jan 12 16:49:56 2004 From: doug at s7.com (Doug Miller) Date: Mon Jan 12 16:48:43 2004 Subject: Logging Changes in Editor In-Reply-To: <012401c3d952$a30d7660$7700a8c0@spvmobile> References: <40028fb63a63f@wp.pl> <012401c3d952$a30d7660$7700a8c0@spvmobile> Message-ID: <6.0.0.22.0.20040112154854.02569ea8@localhost> Sounds like a job for a trigger. You will just need to confirm the command coming in is from the editor and not from a normal BASIC write. -Doug At 03:25 PM 1/12/2004, you wrote: >Hi > >I'm trying to automatically log changes made to all files made by our >support staff using the editor (ED/JED). I thought about writing a wrapper >around the ED/JED commands to do the job, but the more I think about it, the >more difficult it gets.. > >For example, if I parse ED FILENAME item1 item2 item3 then it's pretty >simple for me to pre-parse the statement, read in the "befores" then run the >"real" editor followed by reading and logging the changes made. > >However, this won't work with a statement such as: > > > SELECT FILE WITH ATT = "Something" > > ED FILE > >Does anybody have any thoughts on how I could achieve logging of all changes >made using the editor??? > >Thanks in advance. > > >Simon Verona >Dealer Management Services Ltd >The Old Cross >Woodfall Lane >Low Bradfield >South Yorkshire >S6 6LB > >Tel: 0870 735 0010 >Fax: 0870 169 6747 >Email: simon@dmservices.co.uk > >This email and any files transmitted with it are confidential and intended >solely for the use of the individual or entity to whom they are addressed. >If you are not the intended addressee, you must not disclose, copy or take >any action in reliance of this transmission. > >The Company reserves the right to monitor all telecommunications that make >use of or passes through the Company facilities. This includes, but is not >limited to, E-mail, Internet, Facsimiles, Company Telephones and Company >Mobile Telephones. Please be advised that your telecommunication may be >intercepted, read, copied, deleted or retrieved by authorised personnel, >other than the sender or recipient of the original telecommunication, as the >Company sees fit. > >Although this message and its contents have been scanned for viruses and no >viruses were detected, no responsibility whatsoever is accepted by the >Company, or any of its offices or companies for any loss or damage arising >in any way from receipt or use thereof. > >If you have received this email in error please delete this message and >notify the DMS System Administrator at info@dmservices.co.uk. > > >-- >Outgoing mail is certified Virus Free. >Checked by AVG Anti-Virus (http://www.grisoft.com). >Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 > From mark at proman.com Mon Jan 12 17:39:49 2004 From: mark at proman.com (Mark Hogden) Date: Mon Jan 12 17:40:02 2004 Subject: Logging Changes in Editor In-Reply-To: <6.0.0.22.0.20040112154854.02569ea8@localhost> Message-ID: <20040112223950.BFDEE381F6@mail.blarg.net> We use triggers which call Perforce (see numerous jimi posts), works like a dream. Mark Hogden Proco -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Doug Miller Sent: Monday, January 12, 2004 1:50 PM To: tech@listserver.jbase.com Subject: Re: Logging Changes in Editor Sounds like a job for a trigger. You will just need to confirm the command coming in is from the editor and not from a normal BASIC write. -Doug At 03:25 PM 1/12/2004, you wrote: >Hi > >I'm trying to automatically log changes made to all files made by our >support staff using the editor (ED/JED). I thought about writing a wrapper >around the ED/JED commands to do the job, but the more I think about >it, the more difficult it gets.. > >For example, if I parse ED FILENAME item1 item2 item3 then it's pretty >simple for me to pre-parse the statement, read in the "befores" then >run the "real" editor followed by reading and logging the changes made. > >However, this won't work with a statement such as: > > > SELECT FILE WITH ATT = "Something" > > ED FILE > >Does anybody have any thoughts on how I could achieve logging of all >changes made using the editor??? > >Thanks in advance. > > >Simon Verona >Dealer Management Services Ltd >The Old Cross >Woodfall Lane >Low Bradfield >South Yorkshire >S6 6LB > >Tel: 0870 735 0010 >Fax: 0870 169 6747 >Email: simon@dmservices.co.uk > >This email and any files transmitted with it are confidential and >intended solely for the use of the individual or entity to whom they are addressed. >If you are not the intended addressee, you must not disclose, copy or >take any action in reliance of this transmission. > >The Company reserves the right to monitor all telecommunications that >make use of or passes through the Company facilities. This includes, >but is not limited to, E-mail, Internet, Facsimiles, Company Telephones >and Company Mobile Telephones. Please be advised that your >telecommunication may be intercepted, read, copied, deleted or >retrieved by authorised personnel, other than the sender or recipient >of the original telecommunication, as the Company sees fit. > >Although this message and its contents have been scanned for viruses >and no viruses were detected, no responsibility whatsoever is accepted >by the Company, or any of its offices or companies for any loss or >damage arising in any way from receipt or use thereof. > >If you have received this email in error please delete this message and >notify the DMS System Administrator at info@dmservices.co.uk. > > >-- >Outgoing mail is certified Virus Free. >Checked by AVG Anti-Virus (http://www.grisoft.com). >Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 > From LPata at dgn-marketing.com Mon Jan 12 18:02:12 2004 From: LPata at dgn-marketing.com (Lucian Pata) Date: Mon Jan 12 18:02:26 2004 Subject: Logging Changes in Editor Message-ID: <3A3924FD0ABE3A4D9C7D52055D4F2D41043423@dgnexchange01.dgn-marketing.com> Hi Simon, The following is based on the fact that the MD is searched first and then the path is searched. In your MD create a record called JED, as follows: MD << JED >> 001 PQ 002 HXJED 003 A(5,22) 004 P Then create the following program called XJED. * 12-JAN-2004 Lucian Pata * This program will save the record before is opened by JED * then, if the record is changed, will save the changed record * in a log file EQU AM TO CHAR(254) CMD = SENTENCE() CMD = UPCASE(TRIM(CMD)) CONVERT ' ' TO AM IN CMD FNAME = CMD<2> DEL CMD<1> DEL CMD<1> IF SYSTEM(11) THEN SELECT TO SEL.LIST END ELSE SELECT CMD TO SEL.LIST END SNAME = 'JED-LOG-FI LE' ;* Log file OPEN SNAME TO SFILE ELSE EXECUTE 'CREATE-FILE ':SNAME:' 1 11' CAPTURING ZZZ OPEN SNAME TO SFILE ELSE PRINT 'ERROR - Cannot open ':SNAME STOP END END OPEN FNAME TO FILE ELSE PRINT 'ERROR - Cannot open ':FNAME STOP END TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required LOOP READNEXT ID FROM SEL.LIST ELSE EXIT *----- Before JED STAT = 'C' ;* Status CHANGED READ OLD.REC FROM FILE, ID ELSE OLD.REC = '' STAT = 'N' ;* Status NEW END *----- JED EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID *----- After JED XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() READ NEW.REC FROM FILE, ID THEN IF NEW.REC = OLD.REC THEN IF STAT = 'C' THEN CONTINUE ;* The record existed before END END ELSE STAT = 'D' ;* Status DELETED END WRITE OLD.REC ON SFILE, XID REPEAT END Then, you can type in any of the following formats 1) Selected list SELECT FILE JED FILE 2) Single item JED FILE A 3) Multiple items JED FILE X Y Z Note that the actual JED should be executed with full path EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID. If you look at the XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() you have all you need to backtrack the activity, you have the file name, record id, type of change, user, date and time and of course a copy of the original record. Hope this helps, Lucian -----Original Message----- From: Simon Verona [mailto:simon@dmservices.co.uk] Sent: Monday, January 12, 2004 4:26 PM To: tech@listserver.jbase.com Subject: Logging Changes in Editor Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From LPata at dgn-marketing.com Tue Jan 13 09:49:13 2004 From: LPata at dgn-marketing.com (Lucian Pata) Date: Tue Jan 13 09:49:24 2004 Subject: Logging Changes in Editor Message-ID: <3A3924FD0ABE3A4D9C7D52055D4F2D41043424@dgnexchange01.dgn-marketing.com> Simon, I forgot to mention that in the XJED program you should choose between the statements below. TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required If USER is not unique enough then you might use the port instead. Please put USER = SYSTEM(18), if you choose to do so, instead of TEMP = SYSTEM(18). Sorry for the typo. Lucian -----Original Message----- From: Lucian Pata Sent: Monday, January 12, 2004 6:02 PM To: 'tech@listserver.jbase.com' Subject: RE: Logging Changes in Editor Hi Simon, The following is based on the fact that the MD is searched first and then the path is searched. In your MD create a record called JED, as follows: MD << JED >> 001 PQ 002 HXJED 003 A(5,22) 004 P Then create the following program called XJED. * 12-JAN-2004 Lucian Pata * This program will save the record before is opened by JED * then, if the record is changed, will save the changed record * in a log file EQU AM TO CHAR(254) CMD = SENTENCE() CMD = UPCASE(TRIM(CMD)) CONVERT ' ' TO AM IN CMD FNAME = CMD<2> DEL CMD<1> DEL CMD<1> IF SYSTEM(11) THEN SELECT TO SEL.LIST END ELSE SELECT CMD TO SEL.LIST END SNAME = 'JED-LOG-FI LE' ;* Log file OPEN SNAME TO SFILE ELSE EXECUTE 'CREATE-FILE ':SNAME:' 1 11' CAPTURING ZZZ OPEN SNAME TO SFILE ELSE PRINT 'ERROR - Cannot open ':SNAME STOP END END OPEN FNAME TO FILE ELSE PRINT 'ERROR - Cannot open ':FNAME STOP END TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required LOOP READNEXT ID FROM SEL.LIST ELSE EXIT *----- Before JED STAT = 'C' ;* Status CHANGED READ OLD.REC FROM FILE, ID ELSE OLD.REC = '' STAT = 'N' ;* Status NEW END *----- JED EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID *----- After JED XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() READ NEW.REC FROM FILE, ID THEN IF NEW.REC = OLD.REC THEN IF STAT = 'C' THEN CONTINUE ;* The record existed before END END ELSE STAT = 'D' ;* Status DELETED END WRITE OLD.REC ON SFILE, XID REPEAT END Then, you can type in any of the following formats 1) Selected list SELECT FILE JED FILE 2) Single item JED FILE A 3) Multiple items JED FILE X Y Z Note that the actual JED should be executed with full path EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID. If you look at the XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() you have all you need to backtrack the activity, you have the file name, record id, type of change, user, date and time and of course a copy of the original record. Hope this helps, Lucian -----Original Message----- From: Simon Verona [mailto:simon@dmservices.co.uk] Sent: Monday, January 12, 2004 4:26 PM To: tech@listserver.jbase.com Subject: Logging Changes in Editor Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From LPata at dgn-marketing.com Tue Jan 13 10:04:32 2004 From: LPata at dgn-marketing.com (Lucian Pata) Date: Tue Jan 13 10:04:40 2004 Subject: Recall: Logging Changes in Editor Message-ID: <3A3924FD0ABE3A4D9C7D52055D4F2D41014D80A3@dgnexchange01.dgn-marketing.com> Lucian Pata would like to recall the message, "Logging Changes in Editor". From LPata at dgn-marketing.com Tue Jan 13 10:11:14 2004 From: LPata at dgn-marketing.com (Lucian Pata) Date: Tue Jan 13 10:11:22 2004 Subject: Logging Changes in Editor Message-ID: <3A3924FD0ABE3A4D9C7D52055D4F2D41014D80A4@dgnexchange01.dgn-marketing.com> Simon, I forgot to mention that in the XJED program you should choose between the statements below. TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required If USER is not unique enough then you might use the port instead. TEMP is a typo so please put USER = SYSTEM(18), if you choose to do so, instead of TEMP = SYSTEM(18) Erata: Please move line XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() just before the WRITE statement. Lucian -----Original Message----- From: Lucian Pata Sent: Monday, January 12, 2004 6:02 PM To: 'tech@listserver.jbase.com' Subject: RE: Logging Changes in Editor Hi Simon, The following is based on the fact that the MD is searched first and then the path is searched. In your MD create a record called JED, as follows: MD << JED >> 001 PQ 002 HXJED 003 A(5,22) 004 P Then create the following program called XJED. * 12-JAN-2004 Lucian Pata * This program will save the record before is opened by JED * then, if the record is changed, will save the changed record * in a log file EQU AM TO CHAR(254) CMD = SENTENCE() CMD = UPCASE(TRIM(CMD)) CONVERT ' ' TO AM IN CMD FNAME = CMD<2> DEL CMD<1> DEL CMD<1> IF SYSTEM(11) THEN SELECT TO SEL.LIST END ELSE SELECT CMD TO SEL.LIST END SNAME = 'JED-LOG-FI LE' ;* Log file OPEN SNAME TO SFILE ELSE EXECUTE 'CREATE-FILE ':SNAME:' 1 11' CAPTURING ZZZ OPEN SNAME TO SFILE ELSE PRINT 'ERROR - Cannot open ':SNAME STOP END END OPEN FNAME TO FILE ELSE PRINT 'ERROR - Cannot open ':FNAME STOP END TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required LOOP READNEXT ID FROM SEL.LIST ELSE EXIT *----- Before JED STAT = 'C' ;* Status CHANGED READ OLD.REC FROM FILE, ID ELSE OLD.REC = '' STAT = 'N' ;* Status NEW END *----- JED EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID *----- After JED XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() READ NEW.REC FROM FILE, ID THEN IF NEW.REC = OLD.REC THEN IF STAT = 'C' THEN CONTINUE ;* The record existed before END END ELSE STAT = 'D' ;* Status DELETED END WRITE OLD.REC ON SFILE, XID REPEAT END Then, you can type in any of the following formats 1) Selected list SELECT FILE JED FILE 2) Single item JED FILE A 3) Multiple items JED FILE X Y Z Note that the actual JED should be executed with full path EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID. If you look at the XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() you have all you need to backtrack the activity, you have the file name, record id, type of change, user, date and time and of course a copy of the original record. Hope this helps, Lucian -----Original Message----- From: Simon Verona [mailto:simon@dmservices.co.uk] Sent: Monday, January 12, 2004 4:26 PM To: tech@listserver.jbase.com Subject: Logging Changes in Editor Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From simon at dmservices.co.uk Tue Jan 13 11:08:56 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Tue Jan 13 11:09:07 2004 Subject: Logging Changes in Editor In-Reply-To: <3A3924FD0ABE3A4D9C7D52055D4F2D41014D80A4@dgnexchange01.dgn-marketing.com> Message-ID: <002101c3d9ef$8c5779a0$7700a8c0@spvmobile> Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Lucian Pata Sent: 13 January 2004 15:11 To: tech@listserver.jbase.com Subject: RE: Logging Changes in Editor Simon, I forgot to mention that in the XJED program you should choose between the statements below. TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required If USER is not unique enough then you might use the port instead. TEMP is a typo so please put USER = SYSTEM(18), if you choose to do so, instead of TEMP = SYSTEM(18) Erata: Please move line XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() just before the WRITE statement. Lucian -----Original Message----- From: Lucian Pata Sent: Monday, January 12, 2004 6:02 PM To: 'tech@listserver.jbase.com' Subject: RE: Logging Changes in Editor Hi Simon, The following is based on the fact that the MD is searched first and then the path is searched. In your MD create a record called JED, as follows: MD << JED >> 001 PQ 002 HXJED 003 A(5,22) 004 P Then create the following program called XJED. * 12-JAN-2004 Lucian Pata * This program will save the record before is opened by JED * then, if the record is changed, will save the changed record * in a log file EQU AM TO CHAR(254) CMD = SENTENCE() CMD = UPCASE(TRIM(CMD)) CONVERT ' ' TO AM IN CMD FNAME = CMD<2> DEL CMD<1> DEL CMD<1> IF SYSTEM(11) THEN SELECT TO SEL.LIST END ELSE SELECT CMD TO SEL.LIST END SNAME = 'JED-LOG-FI LE' ;* Log file OPEN SNAME TO SFILE ELSE EXECUTE 'CREATE-FILE ':SNAME:' 1 11' CAPTURING ZZZ OPEN SNAME TO SFILE ELSE PRINT 'ERROR - Cannot open ':SNAME STOP END END OPEN FNAME TO FILE ELSE PRINT 'ERROR - Cannot open ':FNAME STOP END TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required LOOP READNEXT ID FROM SEL.LIST ELSE EXIT *----- Before JED STAT = 'C' ;* Status CHANGED READ OLD.REC FROM FILE, ID ELSE OLD.REC = '' STAT = 'N' ;* Status NEW END *----- JED EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID *----- After JED XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() READ NEW.REC FROM FILE, ID THEN IF NEW.REC = OLD.REC THEN IF STAT = 'C' THEN CONTINUE ;* The record existed before END END ELSE STAT = 'D' ;* Status DELETED END WRITE OLD.REC ON SFILE, XID REPEAT END Then, you can type in any of the following formats 1) Selected list SELECT FILE JED FILE 2) Single item JED FILE A 3) Multiple items JED FILE X Y Z Note that the actual JED should be executed with full path EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID. If you look at the XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() you have all you need to backtrack the activity, you have the file name, record id, type of change, user, date and time and of course a copy of the original record. Hope this helps, Lucian -----Original Message----- From: Simon Verona [mailto:simon@dmservices.co.uk] Sent: Monday, January 12, 2004 4:26 PM To: tech@listserver.jbase.com Subject: Logging Changes in Editor Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From simon at dmservices.co.uk Tue Jan 13 11:13:19 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Tue Jan 13 11:13:31 2004 Subject: Logging Changes in Editor In-Reply-To: <3A3924FD0ABE3A4D9C7D52055D4F2D41043423@dgnexchange01.dgn-marketing.com> Message-ID: <002201c3d9f0$29ae19c0$7700a8c0@spvmobile> Lucian Don't know why I didn't thin of this solution... Simple! Thanks The only problem is that EXK won't work.... Though I might re-engineer the solution to read in all the records, then do the full ED by regenerating the selectlist if required and then reading them back in again after. Still not satisfactory as some other process might change the record. I can see how a trigger would also work, but this would mean a trigger being created for every file, and I presume there would be a small performance penalty on every write. Thanks for the thoughts. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Lucian Pata Sent: 12 January 2004 23:02 To: tech@listserver.jbase.com Subject: RE: Logging Changes in Editor Hi Simon, The following is based on the fact that the MD is searched first and then the path is searched. In your MD create a record called JED, as follows: MD << JED >> 001 PQ 002 HXJED 003 A(5,22) 004 P Then create the following program called XJED. * 12-JAN-2004 Lucian Pata * This program will save the record before is opened by JED * then, if the record is changed, will save the changed record * in a log file EQU AM TO CHAR(254) CMD = SENTENCE() CMD = UPCASE(TRIM(CMD)) CONVERT ' ' TO AM IN CMD FNAME = CMD<2> DEL CMD<1> DEL CMD<1> IF SYSTEM(11) THEN SELECT TO SEL.LIST END ELSE SELECT CMD TO SEL.LIST END SNAME = 'JED-LOG-FI LE' ;* Log file OPEN SNAME TO SFILE ELSE EXECUTE 'CREATE-FILE ':SNAME:' 1 11' CAPTURING ZZZ OPEN SNAME TO SFILE ELSE PRINT 'ERROR - Cannot open ':SNAME STOP END END OPEN FNAME TO FILE ELSE PRINT 'ERROR - Cannot open ':FNAME STOP END TEMP = SYSTEM(18) ;* Port number USER = GETENV('USERNAME') ;* Adjust this statement as required LOOP READNEXT ID FROM SEL.LIST ELSE EXIT *----- Before JED STAT = 'C' ;* Status CHANGED READ OLD.REC FROM FILE, ID ELSE OLD.REC = '' STAT = 'N' ;* Status NEW END *----- JED EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID *----- After JED XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() READ NEW.REC FROM FILE, ID THEN IF NEW.REC = OLD.REC THEN IF STAT = 'C' THEN CONTINUE ;* The record existed before END END ELSE STAT = 'D' ;* Status DELETED END WRITE OLD.REC ON SFILE, XID REPEAT END Then, you can type in any of the following formats 1) Selected list SELECT FILE JED FILE 2) Single item JED FILE A 3) Multiple items JED FILE X Y Z Note that the actual JED should be executed with full path EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID. If you look at the XID = FNAME:'|':ID:'|':STAT:'|':USER:'|':DATE():'|':TIME() you have all you need to backtrack the activity, you have the file name, record id, type of change, user, date and time and of course a copy of the original record. Hope this helps, Lucian -----Original Message----- From: Simon Verona [mailto:simon@dmservices.co.uk] Sent: Monday, January 12, 2004 4:26 PM To: tech@listserver.jbase.com Subject: Logging Changes in Editor Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From LPata at dgn-marketing.com Tue Jan 13 15:45:33 2004 From: LPata at dgn-marketing.com (Lucian Pata) Date: Tue Jan 13 15:45:42 2004 Subject: Logging Changes in Editor Message-ID: <3A3924FD0ABE3A4D9C7D52055D4F2D41043426@dgnexchange01.dgn-marketing.com> Simon, You should try the JED execute with the RETURNING clause. EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID RETURNING ERR ERR<1,4> will hold the exit status of the JED editor. Possibly that would be enough to solve your issue. Regards, Lucian From simon at dmservices.co.uk Tue Jan 13 16:39:44 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Tue Jan 13 16:39:56 2004 Subject: Logging Changes in Editor In-Reply-To: <3A3924FD0ABE3A4D9C7D52055D4F2D41043426@dgnexchange01.dgn-marketing.com> Message-ID: <003601c3da1d$c34ce890$7700a8c0@spvmobile> I'll give that a go!.. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Lucian Pata Sent: 13 January 2004 20:46 To: tech@listserver.jbase.com Subject: RE: Logging Changes in Editor Simon, You should try the JED execute with the RETURNING clause. EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID RETURNING ERR ERR<1,4> will hold the exit status of the JED editor. Possibly that would be enough to solve your issue. Regards, Lucian -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From simon at dmservices.co.uk Tue Jan 13 16:42:50 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Tue Jan 13 16:43:00 2004 Subject: Logging Changes in Editor In-Reply-To: <3A3924FD0ABE3A4D9C7D52055D4F2D41043426@dgnexchange01.dgn-marketing.com> Message-ID: <003701c3da1e$31a1fec0$7700a8c0@spvmobile> Sorry, tried that, EX and EXK both exit returning the same error.... I think I'm getting on the right lines now, it just needs a little more thought... Regards Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Lucian Pata Sent: 13 January 2004 20:46 To: tech@listserver.jbase.com Subject: RE: Logging Changes in Editor Simon, You should try the JED execute with the RETURNING clause. EXECUTE 'C:\Jbase30\bin\JED.EXE ':FNAME:' ':ID RETURNING ERR ERR<1,4> will hold the exit status of the JED editor. Possibly that would be enough to solve your issue. Regards, Lucian -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From brucewillmore at comcast.net Tue Jan 13 18:32:37 2004 From: brucewillmore at comcast.net (brucewillmore@comcast.net) Date: Tue Jan 13 18:32:44 2004 Subject: Logging Changes in Editor Message-ID: <011320042332.16407.62f@comcast.net> Probably could just write your own ED. Shouldn't be too difficult, as ED in jBASE isn't exactly feature-rich (by their own admission). You could even make it behave like udt's AE, which is an excellent line editor. > Hi > > I'm trying to automatically log changes made to all files made by our > support staff using the editor (ED/JED). I thought about writing a wrapper > around the ED/JED commands to do the job, but the more I think about it, the > more difficult it gets.. > > For example, if I parse ED FILENAME item1 item2 item3 then it's pretty > simple for me to pre-parse the statement, read in the "befores" then run the > "real" editor followed by reading and logging the changes made. > > However, this won't work with a statement such as: > > > SELECT FILE WITH ATT = "Something" > > ED FILE > > Does anybody have any thoughts on how I could achieve logging of all changes > made using the editor??? > > Thanks in advance. > > > Simon Verona > Dealer Management Services Ltd > The Old Cross > Woodfall Lane > Low Bradfield > South Yorkshire > S6 6LB > > Tel: 0870 735 0010 > Fax: 0870 169 6747 > Email: simon@dmservices.co.uk > > This email and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. > If you are not the intended addressee, you must not disclose, copy or take > any action in reliance of this transmission. > > The Company reserves the right to monitor all telecommunications that make > use of or passes through the Company facilities. This includes, but is not > limited to, E-mail, Internet, Facsimiles, Company Telephones and Company > Mobile Telephones. Please be advised that your telecommunication may be > intercepted, read, copied, deleted or retrieved by authorised personnel, > other than the sender or recipient of the original telecommunication, as the > Company sees fit. > > Although this message and its contents have been scanned for viruses and no > viruses were detected, no responsibility whatsoever is accepted by the > Company, or any of its offices or companies for any loss or damage arising > in any way from receipt or use thereof. > > If you have received this email in error please delete this message and > notify the DMS System Administrator at info@dmservices.co.uk. > > > -- > Outgoing mail is certified Virus Free. > Checked by AVG Anti-Virus (http://www.grisoft.com). > Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 > > From SGray at wakefield.gov.uk Wed Jan 14 08:53:54 2004 From: SGray at wakefield.gov.uk (Gray, Steve) Date: Wed Jan 14 08:54:28 2004 Subject: Logging Changes in Editor Message-ID: Why not find out from jBase what their Transaction Journalling would cost you? We have used it for years for this and all other updates. Steve Gray ICT Technical Support Supervisor Wakefield Metropolitan District Council. -----Original Message----- From: Simon Verona [mailto:simon@dmservices.co.uk] Sent: 12 January 2004 21:26 To: tech@listserver.jbase.com Subject: Logging Changes in Editor Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 This communication is from Wakefield Metropolitan District Council. Confidentiality: This communication may contain information that is confidential and/or privileged and is for the exclusive use of the intended recipient(s). Any form of distribution, copying or use of this communication by anyone else is strictly prohibited. If you have received this communication in error please reply to postmaster@wakefield.gov.uk or telephone +44 (0) 1924 305444, and destroy any copies of this communication. Security: This communication has been created and is sent in the knowledge that Internet e-mail is not secure. We strongly advise you to understand and be aware of this lack of security when e-mailing us. If you communicate with us by Internet e-mail, we will assume that you accept the security risk and that you authorise us to communicate with you in the same format. Viruses: Although this e-mail and its attachments are believed to be free from any virus, it is the responsibility of the recipient(s) to conduct their own virus checks on all parts of this communication. From simon at dmservices.co.uk Wed Jan 14 12:50:18 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Wed Jan 14 12:50:25 2004 Subject: Logging Changes in Editor In-Reply-To: <011320042332.16407.62f@comcast.net> Message-ID: <006201c3dac6$e03b0550$7700a8c0@spvmobile> To be honest, ED and JED provide between them all the features that we need on customers systems. I'm just trying to build a log of changes made by our support staff on customer systems so we can refer and roll them back if we need to... I wasn't really into re-inventing the wheel - Personally, I use the "Crimson" freeware Windows editor if I really have to edit a program (fortunately most of my code is vb.net these days and the MS IDE is excellent!). Regards Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of brucewillmore@comcast.net Sent: 13 January 2004 23:33 To: tech@listserver.jbase.com Subject: Re: Logging Changes in Editor Probably could just write your own ED. Shouldn't be too difficult, as ED in jBASE isn't exactly feature-rich (by their own admission). You could even make it behave like udt's AE, which is an excellent line editor. > Hi > > I'm trying to automatically log changes made to all files made by our > support staff using the editor (ED/JED). I thought about writing a wrapper > around the ED/JED commands to do the job, but the more I think about > it, the more difficult it gets.. > > For example, if I parse ED FILENAME item1 item2 item3 then it's pretty > simple for me to pre-parse the statement, read in the "befores" then > run the "real" editor followed by reading and logging the changes > made. > > However, this won't work with a statement such as: > > > SELECT FILE WITH ATT = "Something" > > ED FILE > > Does anybody have any thoughts on how I could achieve logging of all > changes made using the editor??? > > Thanks in advance. > > > Simon Verona > Dealer Management Services Ltd > The Old Cross > Woodfall Lane > Low Bradfield > South Yorkshire > S6 6LB > > Tel: 0870 735 0010 > Fax: 0870 169 6747 > Email: simon@dmservices.co.uk > > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you are not the intended addressee, you must not > disclose, copy or take any action in reliance of this transmission. > > The Company reserves the right to monitor all telecommunications that > make use of or passes through the Company facilities. This includes, > but is not limited to, E-mail, Internet, Facsimiles, Company > Telephones and Company Mobile Telephones. Please be advised that your > telecommunication may be intercepted, read, copied, deleted or > retrieved by authorised personnel, other than the sender or recipient > of the original telecommunication, as the Company sees fit. > > Although this message and its contents have been scanned for viruses > and no viruses were detected, no responsibility whatsoever is accepted > by the Company, or any of its offices or companies for any loss or > damage arising in any way from receipt or use thereof. > > If you have received this email in error please delete this message > and notify the DMS System Administrator at info@dmservices.co.uk. > > > -- > Outgoing mail is certified Virus Free. > Checked by AVG Anti-Virus (http://www.grisoft.com). > Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 > > -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From simon at dmservices.co.uk Wed Jan 14 12:52:23 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Wed Jan 14 12:52:30 2004 Subject: Logging Changes in Editor In-Reply-To: Message-ID: <006301c3dac7$2b5b59e0$7700a8c0@spvmobile> TJ is excellent, but again a bit of overkill... I'm talking about customer systems, not our own. The price of putting TJ on all the systems for the benefit of logging updates would be prohibitively expensive... Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Gray, Steve Sent: 14 January 2004 13:54 To: tech@listserver.jbase.com Subject: RE: Logging Changes in Editor Why not find out from jBase what their Transaction Journalling would cost you? We have used it for years for this and all other updates. Steve Gray ICT Technical Support Supervisor Wakefield Metropolitan District Council. -----Original Message----- From: Simon Verona [mailto:simon@dmservices.co.uk] Sent: 12 January 2004 21:26 To: tech@listserver.jbase.com Subject: Logging Changes in Editor Hi I'm trying to automatically log changes made to all files made by our support staff using the editor (ED/JED). I thought about writing a wrapper around the ED/JED commands to do the job, but the more I think about it, the more difficult it gets.. For example, if I parse ED FILENAME item1 item2 item3 then it's pretty simple for me to pre-parse the statement, read in the "befores" then run the "real" editor followed by reading and logging the changes made. However, this won't work with a statement such as: > SELECT FILE WITH ATT = "Something" > ED FILE Does anybody have any thoughts on how I could achieve logging of all changes made using the editor??? Thanks in advance. Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 This communication is from Wakefield Metropolitan District Council. Confidentiality: This communication may contain information that is confidential and/or privileged and is for the exclusive use of the intended recipient(s). Any form of distribution, copying or use of this communication by anyone else is strictly prohibited. If you have received this communication in error please reply to postmaster@wakefield.gov.uk or telephone +44 (0) 1924 305444, and destroy any copies of this communication. Security: This communication has been created and is sent in the knowledge that Internet e-mail is not secure. We strongly advise you to understand and be aware of this lack of security when e-mailing us. If you communicate with us by Internet e-mail, we will assume that you accept the security risk and that you authorise us to communicate with you in the same format. Viruses: Although this e-mail and its attachments are believed to be free from any virus, it is the responsibility of the recipient(s) to conduct their own virus checks on all parts of this communication. -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.209 / Virus Database: 261.6.1 - Release Date: 08/01/2004 From him at comp-ware.net Wed Jan 14 23:47:15 2004 From: him at comp-ware.net (Richard Kann) Date: Wed Jan 14 23:50:42 2004 Subject: JRFS Message-ID: <40061B53.3000104@comp-ware.net> Is there anyone sucessfully running JRFS over the internet. Is there anything special I need to do for intenet connections other than standard DSL with a fixed IP address? Rich Kann Comp-Ware Systems, Inc. From simon at dmservices.co.uk Thu Jan 15 06:35:03 2004 From: simon at dmservices.co.uk (Simon Verona) Date: Thu Jan 15 06:35:14 2004 Subject: JRFS In-Reply-To: <40061B53.3000104@comp-ware.net> Message-ID: <000e01c3db5b$9ff66da0$7700a8c0@spvmobile> I use jRFS pretty regularly using VPN over the internet which works well.. It should work fine over the net, the only thing you need to make sure is that the jRFS port is cleared through any firewalls. Regards Simon Verona Dealer Management Services Ltd The Old Cross Woodfall Lane Low Bradfield South Yorkshire S6 6LB Tel: 0870 735 0010 Fax: 0870 169 6747 Email: simon@dmservices.co.uk This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. The Company reserves the right to monitor all telecommunications that make use of or passes through the Company facilities. This includes, but is not limited to, E-mail, Internet, Facsimiles, Company Telephones and Company Mobile Telephones. Please be advised that your telecommunication may be intercepted, read, copied, deleted or retrieved by authorised personnel, other than the sender or recipient of the original telecommunication, as the Company sees fit. Although this message and its contents have been scanned for viruses and no viruses were detected, no responsibility whatsoever is accepted by the Company, or any of its offices or companies for any loss or damage arising in any way from receipt or use thereof. If you have received this email in error please delete this message and notify the DMS System Administrator at info@dmservices.co.uk. -----Original Message----- From: tech-bounces@listserver.jbase.com [mailto:tech-bounces@listserver.jbase.com] On Behalf Of Richard Kann Sent: 15 January 2004 04:47 To: tech@listserver.jbase.com Subject: JRFS Is there anyone sucessfully running JRFS over the internet. Is there anything special I need to do for intenet connections other than standard DSL with a fixed IP address? Rich Kann Comp-Ware Systems, Inc. -- Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.6.2 - Release Date: 13/01/2004 -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.211 / Virus Database: 261.6.2 - Release Date: 13/01/2004 From charlie.noah at inlandtruck.com Fri Jan 16 09:07:32 2004 From: charlie.noah at inlandtruck.com (Charlie Noah) Date: Fri Jan 16 09:08:24 2004 Subject: Red Rat Display Problem Message-ID: <4007F024.6000202@inlandtruck.com> I just upgraded to Red Hat Interprise WS Release 3 (first new workstation in 5 years!) and have discovered that, using the same xterm font I used before, characters above ASCII 127 display as spaces. They used to display properly, and I really depend on being able to see value and subvalue marks. I use xterm -fn 9x15, which xfd -fn 9x15 shows to be -Misc-Fixed-Medium-R-Normal--15-140-75-75-C-90-ISO8859-1 on both machines. In xfd, the entire character set shows as it should on both, with subvalue marks as umlauted u and value marks as accented y. I have tried as many other fonts as I could with the same result. Any assistance or advice from the gurus would be greatly appreciated. Charlie Noah Inland Truck Parts From j_banker at affiliated.org Fri Jan 16 11:36:49 2004 From: j_banker at affiliated.org (Jerry Banker) Date: Fri Jan 16 11:37:01 2004 Subject: Red Rat Display Problem References: <4007F024.6000202@inlandtruck.com> Message-ID: <002a01c3dc4e$f2024260$516f6f6f@ad.affiliated.org> Strange you asking for help from a Guru when in much of this you are considered one. But, I guess we all have limits. ----- Original Message ----- From: "Charlie Noah" To: "Jbase Tech Listserver" Sent: Friday, January 16, 2004 8:07 AM Subject: Red Rat Display Problem I just upgraded to Red Hat Interprise WS Release 3 (first new workstation in 5 years!) and have discovered that, using the same xterm font I used before, characters above ASCII 127 display as spaces. They used to display properly, and I really depend on being able to see value and subvalue marks. I use xterm -fn 9x15, which xfd -fn 9x15 shows to be -Misc-Fixed-Medium-R-Normal--15-140-75-75-C-90-ISO8859-1 on both machines. In xfd, the entire character set shows as it should on both, with subvalue marks as umlauted u and value marks as accented y. I have tried as many other fonts as I could with t