Paul After changing the datatype of the column you may have to SDETACH and then SATTACH the table.
Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Paul Buckley Sent: Wednesday, May 10, 2017 10:20 AM To: [email protected] 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 [email protected] <mailto:[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.
