[ud] TOADS
Hi, anyone out there who knows how I should do to make TOADS work in my newly created Unidataaccount. I have a catalogstructure like this: /data/TOADS.MASTER /data/TOADS /data/TOAD.BEGIN and my new account is in /data/data2/newaccout Björn Eklund ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ODBC Set Up Universe
Okay ... HS.FILE.ACCESS is the file used to define ODBC access rights to a non-sql account. It should be created automatically when you convert an account to ODBC access. And HS.UPDATE.FILEINFO is that program that processes the HS.FILE.ACCCESS file. It creates some hidden file used by the odbc software so that it knows which files and fields it is supposed to make visible to an odbc client. So if you make any changes to the account from within UV, they are invisible to odbc until you update HS.FILE.ACCESS (if relevant) and rerun HS.UPDATE.FILEINFO Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Reid Sent: 27 January 2004 19:14 To: '[EMAIL PROTECTED]' Subject: RE: ODBC Set Up Universe Group, I had the trigger on a table on a development system until it got overwritten on the week-end. However, we never had a file named HS_FILE_ACCESS. I had created it, but I don't feel that its presence had much to do with whatever success I had. Is it supposed to 'MATERIALIZE'? My objective is to create a trigger on an existing file. Try as I might, I am unable to re-create what I did before. Could someone go over the steps one more time? And possibly, could someone state the function of the HS.UPDATE.FILEINFO? I'm not against reading what ever I need to read, but it seems that at least some people have had negative rewards for their reading efforts. thanks. john reid -Original Message- From: Tony Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 5:57 PM To: [EMAIL PROTECTED] Subject: Re: ODBC Set Up Universe Anthony, Do you have NLS turned on? Does anyone have NLS turned on with ODBC on UniVerse? Regards, T. - Original Message - From: Anthony Dzikiewicz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 23, 2004 1:58 AM Subject: RE: ODBC Set Up Universe Thanks for the replys on this issue. The problem was that I did a CREATE SCHEMA in the account I was connecting to. I must have done this because I was reading thru the ODBC guide and the SQL docs and merged the two in my brain. Anyway, I guess if the account is a schema, then the files must be present in the UV_TABLES file. So, my fix was to DROP SCHEMA in the account. I then 'undid' the ODBC access and started from scratch without the CREATE SCHEMA. Now, I can see the files. Now it is just a matter of the HS_FILE_ACCESS and @SELECT that was mentioned. I placed a piece of red tape over the CREATE SCHEMA button so this wont happen again. Thanks Anthony -Original Message- From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 4:52 PM To: [EMAIL PROTECTED] Subject: RE: ODBC Set Up Universe OK I just got back to messing with the ODBC problem. There was one file in particular that I was trying to make accessible called 'CR.TRANS'. I did everything by the book and I still cant access it. As I mentioned, I didn't see this file listed in UV_TABLES. There was a HS_FILE_ACCESS created in the account. Anyway, I thought to just create a new file. So I did. I did it thru the SQL command 'CREATE TABLE ANTHONY (MY_KEY PRIMARY KEY); I did a HS.UPDATE.FILEINFO. I tried again via Microsoft query and I was able to see ANTHONY with MY_KEY as a field. It worked ! I also noticed that UV_TABLES has a new entry for this file. So, it looks like what I missed is the fact that files that need to be accessible via ODBC should have entries in the UV_TABLES file. Is this true ? If so, is there a utility that can get an existing file added as a table ? Obviously, I cant CREATE TABLE to do this. The file(s) already exist. Id rather not have to do REVISE UV_TABLES and have to type everything manually. So, what did I miss in the part about converting existing accounts into schemas ? Does any one know the magic word to get existing files into the ODBC arena ? Thanks Anthony Dzikiewicz -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 5:39 AM To: [EMAIL PROTECTED] Subject: RE: ODBC Set Up Universe And make sure that you don't have more files than you need in the account. HS.SCRUB has a habit of abending without any errors (UV 9.6), which can be a real pig when you're wondering why a certain file does not appear to be exported ... there's a system multi-level file that seems always to cause us grief. Can't remember what it's called - we delete the voc pointer every time we see it - something to do with pterm iirc. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 21:56 To: [EMAIL PROTECTED] Subject: RE: ODBC Set Up Universe Dictionarys of the files you wish to access must have an @SELECT PH item listing the fields that will be accessable in attribute 2 seperated by spaces. Like this: DICT ENAMES02:52:08pm 20 Jan 2004 Page1
SV: [ud] TOADS
Tack så mycket, nu är jag uppe och kör! Björn Eklund Anknytning 2088 -Ursprungligt meddelande- Från: Mats Carlid [mailto:[EMAIL PROTECTED] Skickat: den 28 januari 2004 11:06 Till: U2 Users Discussion List Ämne: Re: [ud] TOADS Björn go to an account where toads is already set up, copy all file pointers that point to TOADS.MASTER or TOADS to the new account. Then - unless toads is globally cataloged - also copy all program entries that belongs to toads. How do I know wich ones belong to toads, You ask. The answer is unless they are globally cataloged their cataloged name all start with the same prefix and You find it in any toad program VOC entry e.g. MASTER.TOAD Also look in Your login paragraph for toads initialization programs in uv we have TD.SET.DIMENSIONS there. I think that is about it - but it sure is a long time Anyway try that as a start and come back with the dignosis if any adn we'll continue from there. There is/should be a shell script somewhere that initializes an account - at least for uv - can't remember it's name :-( /Mats Björn Eklund wrote: Hi, anyone out there who knows how I should do to make TOADS work in my newly created Unidataaccount. I have a catalogstructure like this: /data/TOADS.MASTER /data/TOADS /data/TOAD.BEGIN and my new account is in /data/data2/newaccout Björn Eklund ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VERITAS
Hi Piotr, We are on those releases, and we have not had a problem. The AIX box is a client, and a WIN2K is the master. We do selective restores once per month, to check the file integrity. We back up from a SAN, to 8mm tape. Regards, Steve Ferries -Original Message- From: Piotr KIRYLUK [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 9:05 AM To: [EMAIL PROTECTED] Subject: VERITAS Hello, We are trying to find any site using following Veritas software on IBM AIX 5.1 and UniVerse 9.6.2.10 (or any other release). Does it work without problem ? VERITAS Foundation Suite VERITAS FlashSNAP VERITAS Cluster Server Thanks and regards Piotr ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: uvsql and Dynamic files
What's the definition for @ID? Horacio --- Barry Rogen [EMAIL PROTECTED] escribió: We have an ORDER file in our uvsql account. This file is a dynamic file. The select statement below works fine. however --- If I run that same select statement, but use a q-pointer to the ORDER file in my production UV account, it chokes on the 'LIKE' statement. SELECT @ID, F1, F2, F31, F32, F35, F36, F150, F24 FROM ORDER WHERE @ID LIKE '1234567'; The error message is... The LIKE operator may only be used with character data Any ideas will be mucho appreciated. Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] _ The quality of a person's life is in direct proportion to their commitment to excellence regardless of their chosen field of endeavor vince lombardi _ ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Los mejores usados y las más tentadoras ofertas de 0km están en Yahoo! Autos. Comprá o vendé tu auto en http://autos.yahoo.com.ar ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: mkdbfile: create file in another account
That syntax worked for me (sh -c on Linux rather than DOC /C) but, it doesn't make a DICT file, so the file isn't accessible through TCL commands. I had to add a DICT to the VOC entry I also had to add as the command doesn't create either a DICT file or the VOC entry... I repeat myself. Karl On Tue, 2004-01-27 at 19:31, Kate Stanton wrote: MessageThanks. That (using DOS \C rather than sh -c) got rid of the error message, but it did not seem to create a file. Looks like I have the wrong syntax, but it is rather hard to look up the documentation! I still feel uncomfortable using an undocumented feature - no security it will not disappear or change. - Original Message - From: Daly, Mark To: 'U2 Users Discussion List' Sent: Wednesday, January 28, 2004 10:23 AM Subject: RE: mkdbfile: create file in another account Well, I just posed this question - and mkdbfile was the suggestion that won! However, I didn't create a VOC entry. The idea (I believe) is to execute this command at the OS prompt - not TCL. Since it looks like you're on Windows it would be something like so: EXECUTE 'sh -c cd C:\BeaconUV\DevelData\XXINV\KKINV; ':SYSTEM(32):'\bin\mkdbfile DATA \XXINV\KKINV 30 1 4 20 50 80 1068' It's not documented, since it's really an internal UV command - as opposed to a TCL statement of BASIC function. The CREATE.FILE verb needs to be enhanced to perform this function - and prevent us from dabbling in the 'bin' directory. But until then - this is the way to go. HTH, Mark. Original Message- From: Kate Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 4:17 PM To: [EMAIL PROTECTED] Subject: mkdbfile: create file in another account Does anyone know anything about using mkdbfile (from UV bin) to create a file in an account other than the current user account? A colleague told me about it, but it does not seem to be documented, and does not seem to work on my UV 10.0.17 system on Windows 2000, as it does on his UV 9.5.2.1 on Windows something. I tried, according to his instructions: VOC mkdbfile 0001: V 0002: mkdbfile 0003: E 0004: FG 0005: 0006: PICK.FORMAT Then, from TCL: mkdbfile C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068 where: C:\BeaconUV\DevelData\XXINV\KKINV is pathname of file to create 30 is file type 1 is modulo 4 is separation 20 is hash type 50 is max load 80 is split load 1096 is large record size This gave error message: invalid filetype specified I feel very nervous about using something that is not documented, so presumably may not be reliably supported. Anyone know anything, please? Cheers, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland, New Zealand ph +64 9 360 5310 fax +64 9 376 0750 ah +64 9 378 9594 [EMAIL PROTECTED] -- ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: SV: [ud] TOADS
Esecially for those of us in the U.S. who emmigrated from Sweden a couple generations ago. I've only been back once. I know, you can't go back to where you've never been, so, I've been to Sweden once. It was very nice, though I doubt I could bear to live there (personal political reasons). Karl On Wed, 2004-01-28 at 06:40, Donald Kibbey wrote: It's good for us to see some Swedish in the morning! [EMAIL PROTECTED] 01/28/04 08:22AM Väl bekomme! ( = You're wellcome ) But we're supposed to write in english here aren't we? /Mats Björn Eklund wrote: Tack så mycket, nu är jag uppe och kör! = Thanks a lot, I'm up and running now. Björn Eklund Anknytning 2088 Connection 2088 -Ursprungligt meddelande- Från: Mats Carlid [mailto:[EMAIL PROTECTED] Skickat: den 28 januari 2004 11:06 Till: U2 Users Discussion List Ämne: Re: [ud] TOADS Björn go to an account where toads is already set up, copy all file pointers that point to TOADS.MASTER or TOADS to the new account. Then - unless toads is globally cataloged - also copy all program entries that belongs to toads. How do I know wich ones belong to toads, You ask. The answer is unless they are globally cataloged their cataloged name all start with the same prefix and You find it in any toad program VOC entry e.g. MASTER.TOAD Also look in Your login paragraph for toads initialization programs in uv we have TD.SET.DIMENSIONS there. I think that is about it - but it sure is a long time Anyway try that as a start and come back with the dignosis if any adn we'll continue from there. There is/should be a shell script somewhere that initializes an account - at least for uv - can't remember it's name :-( /Mats Björn Eklund wrote: Hi, anyone out there who knows how I should do to make TOADS work in my newly created Unidataaccount. I have a catalogstructure like this: /data/TOADS.MASTER /data/TOADS /data/TOAD.BEGIN and my new account is in /data/data2/newaccout Björn Eklund ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: RF Bar Code Scanners
You might want to look into TCP wrapper: http://www.ccd.bnl.gov/pdsdir/pds/9410-tcp-wrapper.html -Original Message- From: Karl L Pearson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 12:11 PM To: U2 Users Discussion List Subject: Re: RF Bar Code Scanners I have been here just over a year and wondered why the system was setup for an open, plain-text telnet session from anywhere. I've been monitoring it for the entire time I've been here, and so far, no break-ins, or attempted break-ins as far as I can tell. As the IT Director, it's my responsibility to make sure we are secure, so I'm feeling the pressure. So, what does all this mean? We aren't secure and I'd much rather use some type of SSL/SSH application, though I haven't found one for the scanners. I think that's because the scanners run DR. DOS and have a version of Novell's TCP/IP stack to connect. I'm also using a java telnet applet run off our server through any browser that supports java (not javascript). For those without scanners who want access to our site, it's very nice and requires nothing installed on their PCs. That product is free and DOES have SSL/SSH capability, and I'm slowly moving clients over as they are willing to learn and try it. Karl On Wed, 2004-01-28 at 12:05, [EMAIL PROTECTED] wrote: Karl, That sounds like a great application. Could you share what steps you take to secure the telnet session, to keep the wrong people our of your server? Harman Armstrong Karl L Pearson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/28/2004 11:54 AM Please respond to U2 Users Discussion List To: U2 Users Discussion List [EMAIL PROTECTED] cc: Subject:Re: RF Bar Code Scanners We use the Symbol PDT3146US model of handheld and have found them to be quite reliable. We install VTL46K VT emulation software and then just telnet into our server. We provide them for our clients who use them in their tool cribs for checking out tools to employees. The nice thing is that they are logged into our system here in Salt Lake City (most of them are in Arizona), and when they hit a pre-determined minimum quantity, our system kicks out an order and the process is started for a replenishment order to be shipped. We buy the scanners for them, so they use them, but the amount of product we move more than pays for the scanners, even though one set, including the access point (802.11b currently) costs us around 3K USD. On Wed, 2004-01-28 at 09:26, Ray Buchner wrote: What kind of RF bar code scanners are popular out there for Pick apps. I'm running universe 10 on NT. I would prefer an 802.11 solution with a screen capable of running a telnet session back to the server. TIA, Ray ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: mkdbfile: create file in another account
Nice catch, Karl. My jBASE-thinking brain completely spaced off the need for F pointers on Universe. It's good to know you're still willing to correct my mistakes ~8^) Tom Firl Columbia Ultimate -Original Message- From: Karl L Pearson [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 10:33 AM To: U2 Users Discussion List Subject: Re: mkdbfile: create file in another account That syntax worked for me (sh -c on Linux rather than DOC /C) but, it doesn't make a DICT file, so the file isn't accessible through TCL commands. I had to add a DICT to the VOC entry I also had to add as the command doesn't create either a DICT file or the VOC entry... I repeat myself. Karl On Tue, 2004-01-27 at 19:31, Kate Stanton wrote: MessageThanks. That (using DOS \C rather than sh -c) got rid of the error message, but it did not seem to create a file. Looks like I have the wrong syntax, but it is rather hard to look up the documentation! I still feel uncomfortable using an undocumented feature - no security it will not disappear or change. - Original Message - From: Daly, Mark To: 'U2 Users Discussion List' Sent: Wednesday, January 28, 2004 10:23 AM Subject: RE: mkdbfile: create file in another account Well, I just posed this question - and mkdbfile was the suggestion that won! However, I didn't create a VOC entry. The idea (I believe) is to execute this command at the OS prompt - not TCL. Since it looks like you're on Windows it would be something like so: EXECUTE 'sh -c cd C:\BeaconUV\DevelData\XXINV\KKINV; ':SYSTEM(32):'\bin\mkdbfile DATA \XXINV\KKINV 30 1 4 20 50 80 1068' It's not documented, since it's really an internal UV command - as opposed to a TCL statement of BASIC function. The CREATE.FILE verb needs to be enhanced to perform this function - and prevent us from dabbling in the 'bin' directory. But until then - this is the way to go. HTH, Mark. Original Message- From: Kate Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 4:17 PM To: [EMAIL PROTECTED] Subject: mkdbfile: create file in another account Does anyone know anything about using mkdbfile (from UV bin) to create a file in an account other than the current user account? A colleague told me about it, but it does not seem to be documented, and does not seem to work on my UV 10.0.17 system on Windows 2000, as it does on his UV 9.5.2.1 on Windows something. I tried, according to his instructions: VOC mkdbfile 0001: V 0002: mkdbfile 0003: E 0004: FG 0005: 0006: PICK.FORMAT Then, from TCL: mkdbfile C:\BeaconUV\DevelData\XXINV\KKINV 30 1 4 20 50 80 1068 where: C:\BeaconUV\DevelData\XXINV\KKINV is pathname of file to create 30 is file type 1 is modulo 4 is separation 20 is hash type 50 is max load 80 is split load 1096 is large record size This gave error message: invalid filetype specified I feel very nervous about using something that is not documented, so presumably may not be reliably supported. Anyone know anything, please? Cheers, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland, New Zealand ph +64 9 360 5310 fax +64 9 376 0750 ah +64 9 378 9594 [EMAIL PROTECTED] -- ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: command shell quoting [was:UNCLASSIFIED RE: mkdbfile: create file in another account]
Title: Message A question: does this quote mangling behaviour occur at real TCL or just from an SB+ SH.SHELL prompt.The SH.SHELL mangles double quotes - so that may be your problem. Note that the double quoteswork without nesting or escaping them in the following command(tested on UV10.0.4 10.0.10): DOS/C "NET USER anuser anuserpassword /ADD /FULLNAME:"an user" /COMMENT:"an applicationuser." /HOMEDIR:E:\uvaccounts\anaccount" -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of HENDERSON MICHAEL MRSent: Wednesday, 28 January 2004 13:54To: 'U2 Users Discussion List'Subject: UNCLASSIFIED RE: mkdbfile: create file in another account Kate You may be striking a bug in the UV "dos /c ..." command, which has some, err, foibles ... 1) The command string MUST be enclosed in single quotes (this is not documented anywhere) so, you must say DOS /c 'my DOS command string', not DOS /c "my DOS command string" 2)If you try to pass a parameter enclosed in double quotes, you are in trouble :-( So DOS /c 'blat.exe -s:"a subject with spaces" ...' just doesn't work, the double quotes get mangled. I have cases opened on both issues with IBM, and have tested a patched version of UV that solves the second problem. I understand this will be released with the next windows 10.0.x version, and presumably included in the subsequent 10.1.x. Dunno when, if ever, the documentation issue will be addressed. The work-round for the second problem that is least awful is to generate a batch file (DOS .bat extension) on the fly in your UniBasic program, and then run that .bat file from the DOS /c command. Call me on (04) 2371828 if you want a better explanation! HTH Mike ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Help with UniObjects
Hello List. I'm hoping that someone out there can help me. I have an application in Visual Basic that uses UniObjects. There is a text box that prompts for a record id. In the lost focus event of the record id's text box, I am opening a file, reading a record, and populating all of the other text boxes on the form. At the end of the SUB, it closes the file, and disconnects from the ObjSession. Sounds easy enough right? Wrong! The first pass through goes fine. I enter an ID and the boxes are populated. However, when I go back to enter a second record id, it appears that the .OPENFILE method in the lost focus event fails. The FileObj is set to NOTHING. However, the .ERROR property of the ObjSession is set to 0 (zero) so it also seems that no error occurred. Either way, I cannot use the File Object as all of the subsequent methods of the File Object fails. I have searched the UVDocs documentation and, according to it, I am using all of the objects and methods correctly. Universe 9.6.1.3 on NT Thanks, in advance, for any help that anyone can offer. _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help with UniObjects
Check the vb code for a fatal. Make sure you have some on error statements in the subroutines. It sounds like something has caused a fatal and continued due to a resume next statement, but that the ObjSessiont is now nothing. Check and see if the ObjSessionis still active or is now set for nothing. Also this could be that the ObjSession is in a class that was dropped after the first run through. There is a quirk in VBA for excel which can cause the ObjSession to be set to nothing. For whatever reason, your VB code has probably caused the ObjSession to be set to nothing, so if you can find that yoou will proabably resolve the issue. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of UmFooFoo Murphy Sent: Thursday, 29 January 2004 3:44 PM To: [EMAIL PROTECTED] Subject: Help with UniObjects Hello List. I'm hoping that someone out there can help me. I have an application in Visual Basic that uses UniObjects. There is a text box that prompts for a record id. In the lost focus event of the record id's text box, I am opening a file, reading a record, and populating all of the other text boxes on the form. At the end of the SUB, it closes the file, and disconnects from the ObjSession. Sounds easy enough right? Wrong! The first pass through goes fine. I enter an ID and the boxes are populated. However, when I go back to enter a second record id, it appears that the .OPENFILE method in the lost focus event fails. The FileObj is set to NOTHING. However, the .ERROR property of the ObjSession is set to 0 (zero) so it also seems that no error occurred. Either way, I cannot use the File Object as all of the subsequent methods of the File Object fails. I have searched the UVDocs documentation and, according to it, I am using all of the objects and methods correctly. Universe 9.6.1.3 on NT Thanks, in advance, for any help that anyone can offer. _ Rethink your business approach for the new year with the helpful tips here. http://special.msn.com/bcentral/prep04.armx ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users