It's the "disconnect" command that appeared after years of unloading all from
table, then inputting the file. I had the unloading and changing databases and
inputting all built into cmd files so the data-entry people just had to press a
button. But for the last year, we've had to edit the unloaded file and put in
a connect command.
Patti
From: A. Razzak Memon <[email protected]>
To: [email protected]
Sent: Thursday, February 23, 2017 3:54 PM
Subject: Re: [RBASE-L] - Why can't we input a table anymore?
Patti, Bruce, and Buddy,
The inclusion of the character settings and
CREATE SCHEMA syntax at the beginning of the output for the
UNLOAD has always existed. This method is
standard and has not changed. Patti, why the fake news? <gr>
Note:
You can also use the NOSCHEMA parameter of the
UNLOAD command to omit the character settings and
CREATE SCHEMA syntax from the beginning of the output.
OUTPUT TransferHumptyTable_t.rmd
UNLOAD ALL FOR HumptyTable_t NOSCHEMA
OUTPUT SCREEN
Once again, you are ONLY limited by your knowledge and experience of R:BASE!
HELP UNLOAD explains as well as illustrates it all!
Very Best R:egards,
Razzak
At 03:49 PM 2/23/2017, 'Patti Jakusz' via RBASE-L wrote:
>I took out the connect Healthy.Rb1 command and
>then got the following errors:
>
>R>input healthy_table_newVR_Data_STructure.tbl
>-ERROR- newVR is an undefined table. (2038)
>-ERROR- Duplicate database name ( 720)
>-ERROR- No database connected ( 325)
>-ERROR- No database connected ( 325)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>
>I think I have to put a connect in there
>somewhere. Rbase used to have it in there automatically.
>
>Patti
>
>
>From: Buddy Walker <[email protected]>
>To: [email protected]
>Sent: Thursday, February 23, 2017 3:42 PM
>Subject: RE: [RBASE-L] - Why can't we input a table anymore?
>
>Patti
> Take out the CONNECT Healthy
> When the command CREATE SCHEMA….. R:Base
> Creates the database and it stays connected.
>
>Buddy
>
>
>From: 'Patti Jakusz' via RBASE-L [mailto:[email protected]]
>Sent: Thursday, February 23, 2017 2:37 PM
>To: Karentellef via RBASE-L
><[email protected]>; RBASE-L Mailing List
><[email protected]>; [email protected]
>Subject: [RBASE-L] - Why can't we input a table anymore?
>
>Hello,
>
>I like to do all my coding work in a copy of our
>database. When I want to transfer any new
>tables to the live database, I used to Export
>the data & structure in the database copy and input it in the live database.
>
>For the last year or so, 9.5 wasn't letting me
>do that normally anymore. There was a
>disconnect comment in the exported table but no
>"connect Healthy.RB1" command. After a few
>trials I figured out where to stick the connect command.
>
>Now I have Rbase 10. I tried to stick the
>connect command where I thought it should go,
>just before the Create Schema command. But it
>still doesn't work. Some of the errors I see:
>
>R>input healthy_table_newVR_Data_STructure.tbl
>-ERROR- newVR is an undefined table. (2038)
>-ERROR- No database connected ( 325)
>-ERROR- No database connected ( 325)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>...
>
>
>Here is part of my exported table commands:
>...
>DISCONNECT
>SET STATICDB OFF
>SET ROWLOCKS ON
>SET FASTLOCK OFF
>CONNECT Healthy.RB1
>CREATE SCHEMA AUTHOR HEALTHY PUBLIC
>CREATE TABLE `newVR` +
>(`ssnum` TEXT (11), +
> `momdob` DATE, +...
>
>Can someone tell me what the problem is? And
>why has this gotten so difficult? Sometimes
>these files are huge and I don't think we should
>have to go in through an editor and stick our
>commands in the middle. Especially if it
>doesn't work and I have to keep hitting the tab key for 10,000 records.
>
>Thanks,
>Patti
>--
>You received this message because you are
>subscribed to the Google Groups "RBASE-L" group.
>To unsubscribe from this group and stop
>receiving emails from it, send an email to
><mailto:[email protected]>[email protected].
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.com/d/optout.
>--
>You received this message because you are
>subscribed to the Google Groups "RBASE-L" group.
>To unsubscribe from this group and stop
>receiving emails from it, send an email to
><mailto:[email protected]>[email protected].
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.com/d/optout.
>
>
>--
>You received this message because you are
>subscribed to the Google Groups "RBASE-L" group.
>To unsubscribe from this group and stop
>receiving emails from it, send an email to
><mailto:[email protected]>[email protected].
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
