Re: [RBASE-L] - Can not connect to database "ERROR"

[michael]

It was a network issue. Windows 10 updates caused an issue with "Write 
Permissions"

Thank you Dan, and thank you Razzak for the help. 

On Wednesday, May 10, 2017 at 6:40:09 PM UTC-5, michael wrote:
>
> Are you talking about users of the network, or users and passwords in 
> Rbase?
>
> Michael Brookes
> Maxima Enterprises
> 37 NE 29th Street
> Oklahoma City, OK. 73105
> 405-525-8899
> 405-525-5329 Faxwww.maximaonline.com
>
> On 5/10/2017 6:35 PM, A. Razzak Memon wrote:
>
> Michael, 
>
> Check the user access and privileges of all users using those computers on 
> the network. 
>
> They all need full access (Read/Write) to the folder with R:BASE database, 
> etc. 
>
> Hope that provides you with some blue's clues ... 
>
> Very Best R:egards, 
>
> Razzak 
>
>
> At 07:18 PM 5/10/2017, michael wrote: 
>
> I have a single seat, and a 5 seat addon, and as of today, when I try to 
> access the database from any computer in the network other than the 
> computer that the database resides on, I get the following message. 
>
> "The database is currently unavailable- It is probably open with MULTI set 
> OFF" 
>
> I have not changed any setting from when it was working properly for Many 
> years and continued up updating, and I am currently using Rbase X, and have 
> been for over a year. I do not have the most current update. My 1 year ran 
> out 2 days before the last update. 
>
> I disconnected all databases, and I "Set Multi On" several times. Even set 
> it off and back on a number of times. 
>
> Its not a network problem, because I can see all of the directories and 
> the files on the server computer. but the database will not connect. After 
> the error, the application loads, but no data. 
>
> Please help... My employees will not be able to work tomorrow morning 
> without the database running. 
>
> -- 
> 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  
> rbase-l+unsubscr...@googlegroups.com
> .
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Can not connect to database "ERROR"

[Michael Brookes]

I have never had any users listed. This just started today. I don't even 
have a user set for myself on the server computer. "Which is just a 
computer that is networked with all the others".. Not Workgroup, but 
networked.


Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
www.maximaonline.com

On 5/10/2017 6:35 PM, A. Razzak Memon wrote:

Michael,

Check the user access and privileges of all users using those 
computers on the network.


They all need full access (Read/Write) to the folder with R:BASE 
database, etc.


Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak


At 07:18 PM 5/10/2017, michael wrote:

I have a single seat, and a 5 seat addon, and as of today, when I try 
to access the database from any computer in the network other than 
the computer that the database resides on, I get the following message.


"The database is currently unavailable- It is probably open with 
MULTI set OFF"


I have not changed any setting from when it was working properly for 
Many years and continued up updating, and I am currently using Rbase 
X, and have been for over a year. I do not have the most current 
update. My 1 year ran out 2 days before the last update.


I disconnected all databases, and I "Set Multi On" several times. 
Even set it off and back on a number of times.


Its not a network problem, because I can see all of the directories 
and the files on the server computer. but the database will not 
connect. After the error, the application loads, but no data.


Please help... My employees will not be able to work tomorrow morning 
without the database running.


--
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Can not connect to database "ERROR"

[A. Razzak Memon]

Michael,

Check the user access and privileges of all users using those 
computers on the network.


They all need full access (Read/Write) to the folder with R:BASE database, etc.

Hope that provides you with some blue's clues ...

Very Best R:egards,

Razzak


At 07:18 PM 5/10/2017, michael wrote:

I have a single seat, and a 5 seat addon, and as of today, when I 
try to access the database from any computer in the network other 
than the computer that the database resides on, I get the following message.


"The database is currently unavailable- It is probably open with 
MULTI set OFF"


I have not changed any setting from when it was working properly for 
Many years and continued up updating, and I am currently using Rbase 
X, and have been for over a year. I do not have the most current 
update. My 1 year ran out 2 days before the last update.


I disconnected all databases, and I "Set Multi On" several times. 
Even set it off and back on a number of times.


Its not a network problem, because I can see all of the directories 
and the files on the server computer. but the database will not 
connect. After the error, the application loads, but no data.


Please help... My employees will not be able to work tomorrow 
morning without the database running.


--
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Can not connect to database "ERROR"

[Dan Goldberg]

It is probably a network permission issue then. Not a database issue because if 
you go to the R> and type in list. You will see the users at 2 when you have 2 
sessions open.

Dan

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Michael Brookes
Sent: Wednesday, May 10, 2017 4:27 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - Can not connect to database "ERROR"


Yes I can...



Michael Brookes

Maxima Enterprises

37 NE 29th Street

Oklahoma City, OK. 73105

405-525-8899

405-525-5329 Fax

www.maximaonline.com
On 5/10/2017 6:23 PM, Dan Goldberg wrote:
Can you open two rbase sessions to the same database on the computer that has 
the database?

Dan

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of michael
Sent: Wednesday, May 10, 2017 4:19 PM
To: RBASE-L 
Subject: [RBASE-L] - Can not connect to database "ERROR"

I have a single seat, and a 5 seat addon, and as of today, when I try to access 
the database from any computer in the network other than the computer that the 
database resides on, I get the following message.

"The database is currently unavailable- It is probably open with MULTI set OFF"

I have not changed any setting from when it was working properly for Many years 
and continued up updating, and I am currently using Rbase X, and have been for 
over a year. I do not have the most current update. My 1 year ran out 2 days 
before the last update.

I disconnected all databases, and I "Set Multi On" several times. Even set it 
off and back on a number of times.

Its not a network problem, because I can see all of the directories and the 
files on the server computer. but the database will not connect. After the 
error, the application loads, but no data.

Please help... My employees will not be able to work tomorrow morning without 
the database running.
--
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 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[AVG logo]


This email has been checked for viruses by AVG antivirus software.
www.avg.com



--
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 
rbase-l+unsubscr...@googlegroups.com.
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Can not connect to database "ERROR"

[Michael Brookes]

Yes I can...


Michael Brookes
Maxima Enterprises
37 NE 29th Street
Oklahoma City, OK. 73105
405-525-8899
405-525-5329 Fax
www.maximaonline.com

On 5/10/2017 6:23 PM, Dan Goldberg wrote:


Can you open two rbase sessions to the same database on the computer 
that has the database?


Dan

*From:* rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] *On 
Behalf Of *michael

*Sent:* Wednesday, May 10, 2017 4:19 PM
*To:* RBASE-L 
*Subject:* [RBASE-L] - Can not connect to database "ERROR"

I have a single seat, and a 5 seat addon, and as of today, when I try 
to access the database from any computer in the network other than the 
computer that the database resides on, I get the following message.


"The database is currently unavailable- It is probably open with MULTI 
set OFF"


I have not changed any setting from when it was working properly for 
Many years and continued up updating, and I am currently using Rbase 
X, and have been for over a year. I do not have the most current 
update. My 1 year ran out 2 days before the last update.


I disconnected all databases, and I "Set Multi On" several times. Even 
set it off and back on a number of times.


Its not a network problem, because I can see all of the directories 
and the files on the server computer. but the database will not 
connect. After the error, the application loads, but no data.


Please help... My employees will not be able to work tomorrow morning 
without the database running.


--
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 rbase-l+unsubscr...@googlegroups.com 
.

For more options, visit https://groups.google.com/d/optout.




AVG logo    

This email has been checked for viruses by AVG antivirus software.
www.avg.com 


<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
--
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 rbase-l+unsubscr...@googlegroups.com 
.

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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Can not connect to database "ERROR"

[Dan Goldberg]

Can you open two rbase sessions to the same database on the computer that has 
the database?

Dan

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
michael
Sent: Wednesday, May 10, 2017 4:19 PM
To: RBASE-L 
Subject: [RBASE-L] - Can not connect to database "ERROR"

I have a single seat, and a 5 seat addon, and as of today, when I try to access 
the database from any computer in the network other than the computer that the 
database resides on, I get the following message.

"The database is currently unavailable- It is probably open with MULTI set OFF"

I have not changed any setting from when it was working properly for Many years 
and continued up updating, and I am currently using Rbase X, and have been for 
over a year. I do not have the most current update. My 1 year ran out 2 days 
before the last update.

I disconnected all databases, and I "Set Multi On" several times. Even set it 
off and back on a number of times.

Its not a network problem, because I can see all of the directories and the 
files on the server computer. but the database will not connect. After the 
error, the application loads, but no data.

Please help... My employees will not be able to work tomorrow morning without 
the database running.
--
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - Can not connect to database "ERROR"

[michael]

I have a single seat, and a 5 seat addon, and as of today, when I try to 
access the database from any computer in the network other than the 
computer that the database resides on, I get the following message.

"The database is currently unavailable- It is probably open with MULTI set 
OFF"

I have not changed any setting from when it was working properly for Many 
years and continued up updating, and I am currently using Rbase X, and have 
been for over a year. I do not have the most current update. My 1 year ran 
out 2 days before the last update. 

I disconnected all databases, and I "Set Multi On" several times. Even set 
it off and back on a number of times.

Its not a network problem, because I can see all of the directories and the 
files on the server computer. but the database will not connect. After the 
error, the application loads, but no data.

Please help... My employees will not be able to work tomorrow morning 
without the database running.

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re[4]: [RBASE-L] - Quickbooks

[Bruce Chitiea]

Claudine:

I hear R:azzak muttering: "there are NO boring details in R:BASE!"

Given the potential for integrating R:BASE with a small-business 
accounting system which holds up its end cheerfully, I'd say the details 
might really make somebody's day.


I like Karen's follow-on to your message: do you know if the current 
Sage/Peachtree is up to it?


Thanks

Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile

-- Original Message --
Sent: 5/10/2017 1:21:14 PM
Subject: RE: Re[2]: [RBASE-L] - Quickbooks
From: "Claudine Robbins" 
To: "rbase-l@googlegroups.com" 
Cc:

We use PeachTree for A/R, A/P and G/L.  We export A/R and A/P data from 
R:BASE and upload to PeachTree.  It’s primitive but has worked reliably 
for many years.  Let me know if anyone wants the boring details.




Claudine



From:rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On 
Behalf Of Bruce Chitiea

Sent: Tuesday, May 09, 2017 11:55 AM
To:rbase-l@googlegroups.com
Subject: Re[2]: [RBASE-L] - Quickbooks



Ok then, looking forward.



Is anyone aware of - or had any direct experience with - ANY accounting 
system in QuickBooks' market segment (Peachtree, perhaps) which hosts 
dead-bang, SQL-compliant import/export capabilities; with or without 
resort to third-party "translators"?




Bruce Chitiea

SafeSectors, Inc.

909.238.9012 Mobile



-- Original Message --

Sent: 5/9/2017 8:47:08 AM

Subject: Re: [RBASE-L] - Quickbooks

From: "Bill Downall" 

To: rbase-l@googlegroups.com 

Cc:



I've built a bridge between R:BASE and QB through a 3rd party product 
called Transaction Pro Importer out of Bay State Consulting. It's been 
working well for years, but Karen is right: when QB gets upgraded or 
moved from desktop to cloud, the TPI product may have to change and the 
R:BASE end reworked, too.




That company's experience with trying to move from QB Desktop to QB 
Online was a disaster, as others have described. (Would have had to 
archive/abandon historical details, and it still took over 24 hours to 
convert in testing.)  I've also seen a non-profit I have worked with 
abandon efforts to improve their QB by moving it to QB Online.




Frank's story  -- a company spending 6 figures to learn that moving to 
XXX was not an improvement in the end -- is one many people have shared 
and heard over and over again when R:BASE developers got together.




On Tue, May 9, 2017 at 11:31 AM, karentellef via RBASE-L 
 wrote:


Thanks for the two cents.   Just confirms everything I've heard that QB 
does not want to talk to other programs.  The vertical market app 
they're looking at apparently has a separate add-on program you can buy 
to make the transfer, but who knows what version of QB it interfaces 
with.Gonna share your post (but not your name) with the company.


Karen







-Original Message-
From: Frank Massimo 
To: rbase-l 
Sent: Tue, May 9, 2017 10:21 am
Subject: Re: [RBASE-L] - Quickbooks

Karen,



One of my clients has been using R:Base from DOS through Enterprise 10 
(nearly 20 years). Their accountant felt that the AR portion of the 
R:Base application should be handled through Quickbooks (Enterprise Ver 
14). They have been using QB as a check writer for years. I made a 
number of arguments against it, as they produce 1000-1300 invoices per 
day and the well-honed, specialized R:Base programs developed to create, 
track and process the ultimate payment of 1000-1300 invoices a day was 
in place and working. The only thing that was missing was integration of 
AR numbers for general ledger purposes in Quickbooks, which I pointed 
out could be produced easily on demand when the necessary reports were 
required. The accountant prevailed and the debacle began. I wrote the 
necessary programs to provide overnight data which had to be fed to QB 
via Transaction Pro because the QB process of importing the data was too 
slow. On the AR side, all of the specialized functionality of the custom 
R:Base programs was lost so the AR staff had to learn (the hard way) 
that QB had pretty screens and some neat features but it took them twice 
as long to post invoices, not to mention the dozens of other glitches 
the import process encountered, the difficulty of handling incoming EDI 
payments, and all of the other oddities that R:Base let's you code 
around. That's the short version, but bottom line, I am now busily 
migrating the AR system back to R:Base.




Just my two cents. Cost them six figures to come to the same conclusion, 
though.




Frank Massimo

Tri-State Logistics, Inc.




From: karentellef via RBASE-L 
Sent: Thursday, May 4, 2017 1:17 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Quickbooks



It's been decades 

RE: Re[2]: [RBASE-L] - Quickbooks

[Claudine Robbins]

We use PeachTree for A/R, A/P and G/L.  We export A/R and A/P data from R:BASE 
and upload to PeachTree.  It’s primitive but has worked reliably for many 
years.  Let me know if anyone wants the boring details.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Bruce Chitiea
Sent: Tuesday, May 09, 2017 11:55 AM
To: rbase-l@googlegroups.com
Subject: Re[2]: [RBASE-L] - Quickbooks

Ok then, looking forward.

Is anyone aware of - or had any direct experience with - ANY accounting system 
in QuickBooks' market segment (Peachtree, perhaps) which hosts dead-bang, 
SQL-compliant import/export capabilities; with or without resort to third-party 
"translators"?

Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile

-- Original Message --
Sent: 5/9/2017 8:47:08 AM
Subject: Re: [RBASE-L] - Quickbooks
From: "Bill Downall" >
To: rbase-l@googlegroups.com
Cc:

I've built a bridge between R:BASE and QB through a 3rd party product called 
Transaction Pro Importer out of Bay State Consulting. It's been working well 
for years, but Karen is right: when QB gets upgraded or moved from desktop to 
cloud, the TPI product may have to change and the R:BASE end reworked, too.

That company's experience with trying to move from QB Desktop to QB Online was 
a disaster, as others have described. (Would have had to archive/abandon 
historical details, and it still took over 24 hours to convert in testing.)  
I've also seen a non-profit I have worked with abandon efforts to improve their 
QB by moving it to QB Online.

Frank's story  -- a company spending 6 figures to learn that moving to XXX was 
not an improvement in the end -- is one many people have shared and heard over 
and over again when R:BASE developers got together.

On Tue, May 9, 2017 at 11:31 AM, karentellef via RBASE-L 
> wrote:
Thanks for the two cents.   Just confirms everything I've heard that QB does 
not want to talk to other programs.  The vertical market app they're looking at 
apparently has a separate add-on program you can buy to make the transfer, but 
who knows what version of QB it interfaces with.Gonna share your post (but 
not your name) with the company.

Karen



-Original Message-
From: Frank Massimo >
To: rbase-l >
Sent: Tue, May 9, 2017 10:21 am
Subject: Re: [RBASE-L] - Quickbooks
Karen,

One of my clients has been using R:Base from DOS through Enterprise 10 (nearly 
20 years). Their accountant felt that the AR portion of the R:Base application 
should be handled through Quickbooks (Enterprise Ver 14). They have been using 
QB as a check writer for years. I made a number of arguments against it, as 
they produce 1000-1300 invoices per day and the well-honed, specialized R:Base 
programs developed to create, track and process the ultimate payment of 
1000-1300 invoices a day was in place and working. The only thing that was 
missing was integration of AR numbers for general ledger purposes in 
Quickbooks, which I pointed out could be produced easily on demand when the 
necessary reports were required. The accountant prevailed and the debacle 
began. I wrote the necessary programs to provide overnight data which had to be 
fed to QB via Transaction Pro because the QB process of importing the data was 
too slow. On the AR side, all of the specialized functionality of the custom 
R:Base programs was lost so the AR staff had to learn (the hard way) that QB 
had pretty screens and some neat features but it took them twice as long to 
post invoices, not to mention the dozens of other glitches the import process 
encountered, the difficulty of handling incoming EDI payments, and all of the 
other oddities that R:Base let's you code around. That's the short version, but 
bottom line, I am now busily migrating the AR system back to R:Base.

Just my two cents. Cost them six figures to come to the same conclusion, though.

Frank Massimo
Tri-State Logistics, Inc.


From: karentellef via RBASE-L 
>
Sent: Thursday, May 4, 2017 1:17 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Quickbooks

It's been decades since I've had to deal with Quickbooks, and it wasn't exactly 
a joy back then...

Someone just asked me about sending stuff from RBase into Quickbooks (they do 
not own QB yet, so it would be a new version of the software).

Has anyone here used a new version of QB and let me know if it's easier 
nowadays to send data to QB?  For example, what kind of formats does it accept 
as an import?  Any gotchas?   We'd probably be sending over lists of "members" 
(name, address, etc), and different kinds of revenues received (member fees, 
special fees, 

RE: [RBASE-L] - Modifying SQL Tables with R:BASE Using ODBC Connection

[Buddy Walker]

Paul

  After changing the datatype of the column you may have to SDETACH and then 
SATTACH the table. 

 

Buddy

 

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Paul Buckley
Sent: Wednesday, May 10, 2017 10:20 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Modifying SQL Tables with R:BASE Using ODBC Connection

 

I need to say I am not an MS SQL expert, I MUCH prefer R:BASE, however, I have 
an ERP system using a SQL database and I’m trying to modify some tables using 
an R:BASE front end. I have the latest version R:BASE X Enterprise and I’m 
using SQL Server 2012. I had a custom table created for me by the ERP vendor 
but they created all the columns with datatype nvarchar(max). When I connect to 
the table I see no data. I have modified a couple of columns  - one to 
nvarchar(50) and one to char(50). When I open the connected table I can see the 
data but cannot modify it (I get the error shown below). The columns are 
showing as text(50) in R:BASE but I cannot modify the data. I have successfully 
connected to other tables in the SQL database with nvarchar(50) datatypes and 
have no trouble editing and saving the data.

 

Any blues clues would be greatly appreciated.

 

 



 

Thanks,

Paul Buckley

Alpha Q, Inc.

-- 
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - RE: refressing DB in the explorer

[Dan Goldberg]

I always leave mine on. I do not notice a difference In performance when in the 
db explorer.

Dan

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Wednesday, May 10, 2017 8:00 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: refressing DB in the explorer

Dan,

I think I was too concerned with the application performance when I turned this 
off.

Since I keep my application files in a separate folder for each application, I 
can have this on for my explorer settings and off for the applications.

I knew it was something simple. I have been trying to get all my settings back 
to what they were on the other computer but missed some.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Dan Goldberg
Sent: Wednesday, May 10, 2017 9:38 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: refressing DB in the explorer

Set  UINOTIF ON

automatically displays user interface updates at the Database Explorer. 
Disabling this option within an application will improve the performance.

Dan

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Jim Belisle
Sent: Wednesday, May 10, 2017 7:08 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - refressing DB in the explorer

I had to reinstall my 9.5 RBASE on a new computer. Now When in the explorer 
mode, any changes I make (like comments on table) or form changes changing the 
version number, do not show until I get out then back into another session. I 
tried reading up on all the settings to figure which setting I need to change. 
What setting do I need to change for the changes to take immediately?

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

--
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 
rbase-l+unsubscr...@googlegroups.com.
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - RE: refressing DB in the explorer

[Jim Belisle]

Dan,

I think I was too concerned with the application performance when I turned this 
off.

Since I keep my application files in a separate folder for each application, I 
can have this on for my explorer settings and off for the applications.

I knew it was something simple. I have been trying to get all my settings back 
to what they were on the other computer but missed some.

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Dan Goldberg
Sent: Wednesday, May 10, 2017 9:38 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - RE: refressing DB in the explorer

Set  UINOTIF ON

automatically displays user interface updates at the Database Explorer. 
Disabling this option within an application will improve the performance.

Dan

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Jim Belisle
Sent: Wednesday, May 10, 2017 7:08 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - refressing DB in the explorer

I had to reinstall my 9.5 RBASE on a new computer. Now When in the explorer 
mode, any changes I make (like comments on table) or form changes changing the 
version number, do not show until I get out then back into another session. I 
tried reading up on all the settings to figure which setting I need to change. 
What setting do I need to change for the changes to take immediately?

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

--
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - RE: refressing DB in the explorer

[Dan Goldberg]

Set  UINOTIF ON

automatically displays user interface updates at the Database Explorer. 
Disabling this option within an application will improve the performance.

Dan

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: Wednesday, May 10, 2017 7:08 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - refressing DB in the explorer

I had to reinstall my 9.5 RBASE on a new computer. Now When in the explorer 
mode, any changes I make (like comments on table) or form changes changing the 
version number, do not show until I get out then back into another session. I 
tried reading up on all the settings to figure which setting I need to change. 
What setting do I need to change for the changes to take immediately?

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

--
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 
rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Modifying SQL Tables with R:BASE Using ODBC Connection

[Albert Berry]

You may have to use one of the VARCHAR datatypes on the R:Base side. 
Albert
> On May 10, 2017, at 8:19 AM, Paul Buckley  wrote:
> 
> I need to say I am not an MS SQL expert, I MUCH prefer R:BASE, however, I 
> have an ERP system using a SQL database and I’m trying to modify some tables 
> using an R:BASE front end. I have the latest version R:BASE X Enterprise and 
> I’m using SQL Server 2012. I had a custom table created for me by the ERP 
> vendor but they created all the columns with datatype nvarchar(max). When I 
> connect to the table I see no data. I have modified a couple of columns  - 
> one to nvarchar(50) and one to char(50). When I open the connected table I 
> can see the data but cannot modify it (I get the error shown below). The 
> columns are showing as text(50) in R:BASE but I cannot modify the data. I 
> have successfully connected to other tables in the SQL database with 
> nvarchar(50) datatypes and have no trouble editing and saving the data.
>  
> Any blues clues would be greatly appreciated.
>  
>  
> 
>  
> Thanks,
> Paul Buckley
> Alpha Q, Inc.
> 
> -- 
> 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 rbase-l+unsubscr...@googlegroups.com 
> .
> 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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - refressing DB in the explorer

[Paul C. Buckley]

Jim,

 

Have you tried running RBG95_64_Default_Settings.exe from the R:BASE program 
folder? This should resolve it but be warned it will reset EVERYTHING to its 
defaults so if you’ve customized other settings they will disappear.

 

Paul Buckley

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Jim Belisle
Sent: May 10, 2017 10:08 AM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - refressing DB in the explorer

 

I had to reinstall my 9.5 RBASE on a new computer. Now When in the explorer 
mode, any changes I make (like comments on table) or form changes changing the 
version number, do not show until I get out then back into another session. I 
tried reading up on all the settings to figure which setting I need to change. 
What setting do I need to change for the changes to take immediately?

 

James Belisle

 

Making Information Systems People Friendly Since 1990



 

-- 
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 rbase-l+unsubscr...@googlegroups.com 
 .
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[RBASE-L] - refressing DB in the explorer

[Jim Belisle]

I had to reinstall my 9.5 RBASE on a new computer. Now When in the explorer 
mode, any changes I make (like comments on table) or form changes changing the 
version number, do not show until I get out then back into another session. I 
tried reading up on all the settings to figure which setting I need to change. 
What setting do I need to change for the changes to take immediately?

James Belisle

Making Information Systems People Friendly Since 1990
[cid:image001.jpg@01CD8CE2.FB048F50]

-- 
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.