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

2017-05-11 Thread Paul C. Buckley
Of A. Razzak Memon Sent: May 10, 2017 7:43 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Modifying SQL Tables with R:BASE Using ODBC Connection Paul, A few questions ... 01. That custom table created by your ERP vendor is the actual Table or a View? 02. Do you have full user privileges

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

2017-05-10 Thread 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:

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

2017-05-10 Thread 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