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 <[email protected]> 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. > > > <image001.png> > > 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 [email protected] > <mailto:[email protected]>. > For more options, visit https://groups.google.com/d/optout > <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.
