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