Hi Bruce, Are you saying I should get rid of the lines below?Patti
SET SINGLE=NULLSET SINGLE='_'SET MANY=NULLSET MANY='%'SET IDQUOTES=NULLSET
IDQUOTES='`'SET CURRENCY '$' PREF 2 Bedit this out?--> DISCONNECTedit this
out?--> SET STATICDB OFFedit this out?--> SET ROWLOCKS ONedit this out?--> SET
FASTLOCK OFFedit this out?--> CREATE SCHEMA AUTHOR HEALTHY PUBLICCREATE 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?
#yiv3759705103 #yiv3759705103 --body{font-size:12pt;}#yiv3759705103 Patti:
>From within your development database, have you tried:
OUTPUT TransferHumptyTable_t.rmdUNLOAD ALL FOR HumptyTable_tOUTPUT 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.rmdBROWSE * FROM HumptyTable_t
... from the R> Prompt?
Since this is a new table, your only concern would be duplicate column
names/definitions.
Bruce ChitieaSafeSectors, Inc.909.238.9012 Mobile
------ Original Message ------Sent: 2/23/2017 11:36:46 AMSubject: [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:...DISCONNECTSET STATICDB OFFSET
ROWLOCKS ONSET FASTLOCK OFFCONNECT Healthy.RB1CREATE SCHEMA AUTHOR HEALTHY
PUBLICCREATE 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.
