Re: [RBASE-L] - Crystal Reports ODBC Error 08004

2017-08-24 Thread A. Razzak Memon 

Doug,

Did you know that you can design and deploy very cool and complex 
R:BASE reports using R:BASE X
and R:BASE XE (Version 10) Report Designer? Have you explored all 
possibilities in RBGX/RBGXE?


FWIW ...

When sharing a database in a LAN environment with fully licensed 
version of RBGX/RBGXE on each
workstation, each workstation MUST be configured with defined System 
DSN or DSN-Less connection.


If everyone is using the RBGX/RBGXE on sever (Server installation), 
then the server itself MUST

be configured with System DSN or DSN-Less Connection.

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

Very Best R:egards,

Razzak

At 05:31 PM 8/24/2017, Doug Hamilton wrote:


Trying to make an ODBC connection from Crystal Reports to R:Base 9.5.
Works ok on local copy of db, but when trying to connect to 
production R:Base db on server,
get DB Connection error: '08004:[RBTI][R:Base 9.5 ODBC Driver] 
...unavailable - it is

open with STATICDB set ON.'

True, STATICDB is ON for all users, but we we're only reading data.
I'm obviously missing something.
Any clues for the blues?

Thanks,
Doug


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Crystal Reports ODBC Error 08004

2017-08-24 Thread Lena Dammstrom 
Shot in the dark.
Is the Oterro95_32.cfg on the server setting STATICDB OFF?

Regards
Lena



Lena Dammstrom
Software Developer

Email:ldammst...@qmiusa.com
Toll Free: 800-446-2500
International: 01 630-529-7111
Extension: 1037

www.qmiusa.com

--
The information transmitted, including attachments, is intended only for the 
person(s) or entity to which it is addressed and may contain confidential 
and/or privileged material.  Any review, retransmission, dissemination or other 
use of, or taking of any action in reliance upon this information by persons or 
entities other than the intended recipient is prohibited.  If you received this 
in error, please contact the sender and destroy any copies of this information.

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Doug Hamilton
Sent: Thursday, August 24, 2017 4:31 PM
To: R:Base List
Subject: [RBASE-L] - Crystal Reports ODBC Error 08004

Trying to make an ODBC connection from Crystal Reports to R:Base 9.5.
Works ok on local copy of db, but when trying to connect to production R:Base 
db on server, get DB Connection error: '08004:[RBTI][R:Base 9.5 ODBC Driver] 
...unavailable - it is open with STATICDB set ON.'

True, STATICDB is ON for all users, but we we're only reading data.
I'm obviously missing something.
Any clues for the blues?

Thanks,
Doug

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Crystal Reports ODBC Error 08004

2017-08-24 Thread Doug Hamilton 

Trying to make an ODBC connection from Crystal Reports to R:Base 9.5.
Works ok on local copy of db, but when trying to connect to production 
R:Base db on server,
get DB Connection error: '08004:[RBTI][R:Base 9.5 ODBC Driver] 
...unavailable - it is

open with STATICDB set ON.'

True, STATICDB is ON for all users, but we we're only reading data.
I'm obviously missing something.
Any clues for the blues?

Thanks,
Doug

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Another Enhanced DB Grid Question

2017-08-24 Thread A. Razzak Memon 

Paul,

How about RECALC VARIABLES and Enhanced DB Grid's 
associated Table Row Setting options?


[x] Replace Existing Rows
[x] Automatic Replacement

Very Best R:egards,

Razzak


At 08:48 AM 8/24/2017, Paul C. Buckley wrote:


Razzak,

Well I thought that would be it. I've taken out 
all the saverow's and I still get prompted to 
save changes when I change cells in the Enhanced DB grid.


Any other suggestions?

Thanks,
Paul

-Original Message-
From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley

Sent: August 24, 2017 8:39 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

Razzak,

That's it, I'll pull them out.

I appreciate the help,

Paul

-Original Message-
From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon

Sent: August 24, 2017 8:37 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

Paul,

While in form designer, carefully review the 
[Code] section of the form and make sure that 
you are not using the SAVEROW option on each click of the DB Grid Column.


See attached screen shot for the exact location for [Code] option.

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

Very Best R:egards,

Razzak


At 08:18 AM 8/24/2017, Paul C. Buckley wrote:

>Claudine,
>
>That was the first thing I tried. This isn̢۪t happenpening closing the
>form it happens going from one field to the next in the Enhanced DB
>grid.
>
>Thanks,
>Paul
>
>From: rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
>Sent: August 23, 2017 5:32 PM
>To: rbase-l@googlegroups.com
>Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question
>
>Check  the “Don’t Show Save Diave Dialog† in the FORM PROPERTIES
>Attributes
>
>From:
>rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
>Sent: Wednesday, August 23, 2017 3:14 PM
>To: rbase-l@googlegroups.com
>Subject: [RBASE-L] - Another Enhanced DB Grid Question
>
>Good afternoon,
>
>I'm probably missing something simple, I'm using the latest R:BASE X
>Enterprise and I have an Enhanced DB grid based on a single table view.
>Thanks to Karen, I̢۪ve got the dirty flag and primarmary key working so I
>can update changes from a push button. Here̢۪s my di dilemma, if I click
>on a cell and make a change and then click on another cell (same row or
>different row, it doesn̢۪t matter) I get a popup mesmessage the data has
>changed, do I want to save the data. I̢۪m handling tg the updates from a
>push button and looking at the dirty flag. I̢۪ve tritried everywhere I
>can think of and I have found to not “ask to save chananges† and this
>continues to popup.
>
>Any blues clues would be greatly appreciated,
>
>Paul Buckley

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php

---
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.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Another Enhanced DB Grid Question

2017-08-24 Thread karentellef via RBASE-L 
Paul:  is this happening only after someone selects your "update" button?  If 
the "update" button is changing the table data, are you then refreshing the 
data in the grid?  If you aren't, then that's the problem.

Have the button do its updating code then either   PROPERTY TABLE  
'REFRESH' or if that doesn't work do a 'CLOSE' / 'OPEN'

Otherwise, what RBase is telling you is that the button updated the underlying 
code, but your grid still shows the previous values so it's correctly letting 
you know of the mismatch.

Karen


 

 

 

-Original Message-
From: Paul C. Buckley 
To: rbase-l 
Sent: Thu, Aug 24, 2017 7:19 am
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question



Claudine,
 
That was the first thing I tried. This isn’t happening closing the form it 
happens going from one field to the next in the Enhanced DB grid.
 
Thanks,
Paul
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: August 23, 2017 5:32 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

 
Check  the “Don’t Show Save Dialog” in the FORM PROPERTIES Attributes
 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Paul C. Buckley
Sent: Wednesday, August 23, 2017 3:14 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Another Enhanced DB Grid Question

 
Good afternoon,
 
I'm probably missing something simple, I'm using the latest R:BASE X Enterprise 
and I have an Enhanced DB grid based on a single table view. Thanks to Karen, 
I’ve got the dirty flag and primary key working so I can update changes from a 
push button. Here’s my dilemma, if I click on a cell and make a change and then 
click on another cell (same row or different row, it doesn’t matter) I get a 
popup message the data has changed, do I want to save the data. I’m handling 
the updates from a push button and looking at the dirty flag. I’ve tried 
everywhere I can think of and I have found to not “ask to save changes” and 
this continues to popup.
 
Any blues clues would be greatly appreciated,
 
Paul Buckley
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.
-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.



-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Another Enhanced DB Grid Question

2017-08-24 Thread Paul C. Buckley 
Razzak,

Well I thought that would be it. I've taken out all the saverow's and I still 
get prompted to save changes when I change cells in the Enhanced DB grid.

Any other suggestions?

Thanks,
Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Paul C. Buckley
Sent: August 24, 2017 8:39 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

Razzak,

That's it, I'll pull them out.

I appreciate the help,

Paul

-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
A. Razzak Memon
Sent: August 24, 2017 8:37 AM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

Paul,

While in form designer, carefully review the [Code] section of the form and 
make sure that you are not using the SAVEROW option on each click of the DB 
Grid Column.

See attached screen shot for the exact location for [Code] option.

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

Very Best R:egards,

Razzak


At 08:18 AM 8/24/2017, Paul C. Buckley wrote:

>Claudine,
>
>That was the first thing I tried. This isn’t happening closing the 
>form it happens going from one field to the next in the Enhanced DB 
>grid.
>
>Thanks,
>Paul
>
>From: rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
>Sent: August 23, 2017 5:32 PM
>To: rbase-l@googlegroups.com
>Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question
>
>Check  the “Don’t Show Save Dialog† in the FORM PROPERTIES 
>Attributes
>
>From: 
>rbase-l@googlegroups.com
>[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
>Sent: Wednesday, August 23, 2017 3:14 PM
>To: rbase-l@googlegroups.com
>Subject: [RBASE-L] - Another Enhanced DB Grid Question
>
>Good afternoon,
>
>I'm probably missing something simple, I'm using the latest R:BASE X 
>Enterprise and I have an Enhanced DB grid based on a single table view.
>Thanks to Karen, I’ve got the dirty flag and primary key working so I 
>can update changes from a push button. Here’s my dilemma, if I click 
>on a cell and make a change and then click on another cell (same row or 
>different row, it doesn’t matter) I get a popup message the data has 
>changed, do I want to save the data. I’m handling the updates from a 
>push button and looking at the dirty flag. I’ve tried everywhere I 
>can think of and I have found to not “ask to save changes† and this 
>continues to popup.
>
>Any blues clues would be greatly appreciated,
>
>Paul Buckley

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Another Enhanced DB Grid Question

2017-08-24 Thread A. Razzak Memon 

Paul,

While in form designer, carefully review the 
[Code] section of the form and make sure that you 
are not using the SAVEROW option on each click of the DB Grid Column.


See attached screen shot for the exact location for [Code] option.

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

Very Best R:egards,

Razzak


At 08:18 AM 8/24/2017, Paul C. Buckley wrote:


Claudine,

That was the first thing I tried. This isn’t 
happening closing the form it happens going from 
one field to the next in the Enhanced DB grid.


Thanks,
Paul

From: rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins

Sent: August 23, 2017 5:32 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

Check  the “Don’t Show Save Dialog† in the FORM PROPERTIES Attributes

From: 
rbase-l@googlegroups.com 
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley

Sent: Wednesday, August 23, 2017 3:14 PM
To: rbase-l@googlegroups.com
Subject: [RBASE-L] - Another Enhanced DB Grid Question

Good afternoon,

I'm probably missing something simple, I'm using 
the latest R:BASE X Enterprise and I have an 
Enhanced DB grid based on a single table view. 
Thanks to Karen, I’ve got the dirty flag and 
primary key working so I can update changes from 
a push button. Here’s my dilemma, if I click 
on a cell and make a change and then click on 
another cell (same row or different row, it 
doesn’t matter) I get a popup message the data 
has changed, do I want to save the data. I’m 
handling the updates from a push button and 
looking at the dirty flag. I’ve tried 
everywhere I can think of and I have found to 
not “ask to save changes† and this continues to popup.


Any blues clues would be greatly appreciated,

Paul Buckley


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Another Enhanced DB Grid Question

2017-08-24 Thread Paul C. Buckley 
Claudine,

 

That was the first thing I tried. This isn’t happening closing the form it 
happens going from one field to the next in the Enhanced DB grid.

 

Thanks,

Paul

 

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Claudine Robbins
Sent: August 23, 2017 5:32 PM
To: rbase-l@googlegroups.com
Subject: RE: [RBASE-L] - Another Enhanced DB Grid Question

 

Check  the “Don’t Show Save Dialog” in the FORM PROPERTIES Attributes

 

From: rbase-l@googlegroups.com   
[mailto:rbase-l@googlegroups.com] On Behalf Of Paul C. Buckley
Sent: Wednesday, August 23, 2017 3:14 PM
To: rbase-l@googlegroups.com  
Subject: [RBASE-L] - Another Enhanced DB Grid Question

 

Good afternoon,

 

I'm probably missing something simple, I'm using the latest R:BASE X Enterprise 
and I have an Enhanced DB grid based on a single table view. Thanks to Karen, 
I’ve got the dirty flag and primary key working so I can update changes from a 
push button. Here’s my dilemma, if I click on a cell and make a change and then 
click on another cell (same row or different row, it doesn’t matter) I get a 
popup message the data has changed, do I want to save the data. I’m handling 
the updates from a push button and looking at the dirty flag. I’ve tried 
everywhere I can think of and I have found to not “ask to save changes” and 
this continues to popup.

 

Any blues clues would be greatly appreciated,

 

Paul Buckley

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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] - Tip of the Day: Added "Apply" Button to Form Properties Dialog

2017-08-24 Thread A. Razzak Memon 

Thursday, August 24 2017

Tip of the Day: Added "Apply" Button to Form Properties Dialog
Product...: R:BASE X and R:BASE X Enterprise (Version 10)
Build.: 10.0.2.20731 or higher
Section...: Forms
Keywords..: Form Designer, Form Properties

Did you know the Form Properties dialog was improved to include an 
appropriate "Apply" button,

to preserve and/or visualize the effects of each new change?

Every tab in the Form Properties dialog now include an Apply button 
to see any changes without

having to exit the dialog.

Within the Form Properties users can customize the form size, 
caption, caption buttons, color,
closing behavior, and much more. The Form Properties can be accessed 
directly from any form
background space by right clicking on the background and selecting 
"Object Property". In some
forms, you may have less room after placing a great number of 
objects. Another method to open
the Form Properties is by using the "Edit" toolbar and selecting the 
"Form Properties" button.
You can also set the Form Properties by selecting "Tools" > "Object 
Property" from the main

Menu Bar, or by simply pressing the [F11] key.

http://www.razzak.com/tips/FormProp_Properties.jpg

One of the most important aspects in business growth is your 
company's data, and no one else
has more invested in your success than R:BASE Technologies. Invest 
forward with R:BASE!


Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
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.