Patti:
See R:azzak's reply first.
Bruce
------ Original Message ------
Sent: 2/23/2017 12:21:19 PM
Subject: Re: [RBASE-L] - Why can't we input a table anymore?
From: "'Patti Jakusz' via RBASE-L" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
Hi Bruce, Are you saying I should get rid of the lines below?
Patti
SET SINGLE=NULL
SET SINGLE='_'
SET MANY=NULL
SET MANY='%'
SET IDQUOTES=NULL
SET IDQUOTES='`'
SET CURRENCY '$' PREF 2 B
edit this out?--> DISCONNECT
edit this out?--> SET STATICDB OFF
edit this out?--> SET ROWLOCKS ON
edit this out?--> SET FASTLOCK OFF
edit this out?--> CREATE SCHEMA AUTHOR HEALTHY PUBLIC
CREATE TABLE `newVR` +
(`ssnum` TEXT (11), +
`momdob` DATE, +
--------------------------------------------------------------------------------
From: Bruce Chitiea <[email protected]>
To:[email protected]
Sent: Thursday, February 23, 2017 3:13 PM
Subject: Re: [RBASE-L] - Why can't we input a table anymore?
Patti:
From within your development database, have you tried:
OUTPUT TransferHumptyTable_t.rmd
UNLOAD ALL FOR HumptyTable_t
OUTPUT Screen
... editing out the few lines of schema creation commands, disconnecting
from the development database, connecting to the production database,
then performing:
RUN TransferHumptyTable_t.rmd
BROWSE * FROM HumptyTable_t
... from the R> Prompt?
Since this is a new table, your only concern would be duplicate column
names/definitions.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 2/23/2017 11:36:46 AM
Subject: [RBASE-L] - Why can't we input a table anymore?
From: "'Patti Jakusz' via RBASE-L" <[email protected]>
To: "Karentellef via RBASE-L" <[email protected]>; "RBASE-L
Mailing List" <[email protected]>; "[email protected]"
<[email protected]>
Cc:
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 [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.
--
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.
