Re: [U2] UV ODBC Oddity

2008-02-10 Thread Ray Wurlod
UniVerse does not have a timestamp data type. This is at the heart of your problem. Find some Microsoft documentation that mentions that MS Query now generates a timestamp instead of the date it used to generate, and bleat long and loud to Microsoft about it. Meanwhile, since that will be

Re: [U2] question(s)

2008-02-10 Thread Ray Wurlod
Printer memory segment removed occurs when you attempt to attach to a printer shared memory segment that was formerly owned by a now logged-out process but insufficient time has gone by for it to be cleaned up. It's an alert, and may be safely ignored. --- u2-users mailing list

Re: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread Ray Wurlod
The only legal way is DROP SCHEMA followed by CREATE SCHEMA. - Original Message - From: David Jordan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Change SCHEMA name in UniVerse SQL Date: Sun, 3 Feb 2008 10:45:47 +1100 Does anyone know how to change the SQL

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread David Jordan
Hi Ray To drop schema means that you have to drop all the tables as well? The moving of scemas, copying schemas, etc in UniVerse is very painfull, there must be better ways. Ie copying a test account. Regards David Jordan Managing Consultant -Original Message- From: [EMAIL

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread LeRoy Dreyfuss
Hi David, The reason for Ray's response is due to the SQL catalog, which itself is a schema. It is a major effort like you say because of the information about each schema and table that is stored in the catalog. There is no simple method I am aware of. Regards, LeRoy -Original

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread phil walker
The schema name is stored in the header of the VOC file as well as in the UV SQL Catalog, plus it may also be stored in the headers of any files/tables in the account. You could do it manually, but it you would need to know what you were doing!!! -Original Message- From: [EMAIL