Jennifer I copied your structure to a dummy DB I have
I run the structure and I run the code. It works just fine It created the permanent tables ok It created the temp tables ok So I dont see any issue!??! Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För Roberts, Jennifer Skickat: den 10 februari 2010 15:04 Till: RBASE-L Mailing List Ämne: [RBASE-L] - FW: [RBASE-L] - Re: I/O error redux Sending this in again because it didnt go through the first time. I did add the a to the shortcut but still having issues. Jennifer Roberts Business Applications Specialist Ext: 5788 From: Roberts, Jennifer Sent: Friday, February 05, 2010 10:14 AM To: [email protected] Subject: RE: [RBASE-L] - Re: I/O error redux Scratch settings are set to c:/temp. All users are off site users connecting using RDP. Here is my code: SET ERROR MESSAGE 2038 OFF DROP TABLE tselecttype PROJECT TEMPORARY tselecttype FROM referraltypes + USING referraltype,description WHERE LIMIT = 0 DROP TABLE tselectagency PROJECT TEMPORARY tselectagency FROM agency + USING agencykey,agency,city WHERE LIMIT = 0 SET ERROR MESSAGE 2038 ON Here are the table structures: SET QUOTES=NULL SET QUOTES=' SET DELIMIT=NULL SET DELIMIT=',' SET LINEEND=NULL SET LINEEND='^' SET SEMI=NULL SET SEMI=';' SET PLUS=NULL SET PLUS='+' SET SINGLE=NULL SET SINGLE='_' SET MANY=NULL SET MANY='%' SET IDQUOTES=NULL SET IDQUOTES='`' SET CURRENCY '$' PREF 2 B DISCONNECT SET STATICDB OFF SET ROWLOCKS ON SET FASTLOCK OFF CREATE SCHEMA AUTHOR MSS PUBLIC CREATE TABLE `ReferralTypes` + (`ReferralType` TEXT (15) , + `Description` TEXT (30) ) COMMENT ON TABLE `ReferralTypes` IS + 'Referral types' And -> SET QUOTES=NULL SET QUOTES=' SET DELIMIT=NULL SET DELIMIT=',' SET LINEEND=NULL SET LINEEND='^' SET SEMI=NULL SET SEMI=';' SET PLUS=NULL SET PLUS='+' SET SINGLE=NULL SET SINGLE='_' SET MANY=NULL SET MANY='%' SET IDQUOTES=NULL SET IDQUOTES='`' SET CURRENCY '$' PREF 2 B DISCONNECT SET STATICDB OFF SET ROWLOCKS ON SET FASTLOCK OFF CREATE SCHEMA AUTHOR MSS PUBLIC CREATE TABLE `Agency` CASCADE + (`AgencyKEY` INTEGER NOT NULL + ('Value for column AgencyKEY cannot be null') , + `LastUpdateBy` TEXT (20) , + `AGUpdateDate` DATETIME , + `CaseManager` TEXT (20) NOT NULL + ('Please select the coordinator.') , + `Agency` TEXT (60) NOT NULL + ('Please enter a name for this agency.') , + `Address` NOTE (2042) , + `City` TEXT (20) , + `State` TEXT (2) , + `County` TEXT (15) , + `Zipcode` TEXT (10) , + `Phone` TEXT (15) , + `Phone2` TEXT (15) , + `Extension` TEXT (8) , + `Fax` TEXT (15) , + `agencytype` TEXT (15) , + `contact` NOTE , + `Comments` NOTE (2042) , + `WebAddress` TEXT (50) , + `IncomeQualifiers` NOTE , + `GeographicCoverage` NOTE , + `ApplicationReq` NOTE , + `Qualifications` NOTE , + `Limitations` NOTE , + `FeeStructure` NOTE (2042) ) ALTER TABLE `Agency` ADD PRIMARY KEY + (`AgencyKEY` ) + ('Values for rows in Agency must be unique',+ 'Cannot delete - values exist in another table',+ 'Cannot update - values exist in another table') AUTONUM `AgencyKEY` IN `Agency` USING + 13633. 1. NONUM COMMENT ON TABLE `Agency` IS + 'Agencies offering assistance' Thank you, Jennifer From: [email protected] [mailto:[email protected]] On Behalf Of Rachael Malberg Sent: Friday, February 05, 2010 10:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: I/O error redux and double check your scratch settings, if you set it to c:/temp as recommended then everyone connected via RDP is using the same directory for temp data. Just curious are these all off site users? This electronic message contains information from the Ohio Masonic Home, its operating subsidaiaries or affiliates. The information may be confidential, privileged or otherwise protected from disclosure. The information is intended to be received solely by [email protected], for use as designated in the message. If you are not the designated recipient, you are instructed not to review, disclose, copy, distribute orotherwise use of this transmission or its contents. If you have received this transmission in error, please notify the Ohio Masonic Home immediately at [email protected]; in addition, please delete your record of transmission. Sending, receiving, downloading, displaying, printing material that is harassing, fraudulent, offensive, intimidating, defamatory, or otherwise unlawful or inappropriate is strictly prohibited by The Ohio Masonic Home.
