Razzak, To answer your questions: 01 - it is a table 02 - I do have full rights to update the table 03 - I was able to successfully project a table from the SQL table.
Here's what I did figure out yesterday. I will definitely need to get the datatype changed from nvarchar(max) so I can even see the data - that shouldn't be a problem the longest text/note in any column right now is 90 characters. I was able to do an SSQL update on the SQL table yesterday I just can't open the SQL table and modify columns interactively - no problem. What I'm probably going to do is right a custom front end and form to search for the data I need to modify and make changes to a projected R:BASE table then update the SQL table accordingly with SSQL code. Thanks for the feedback, Paul Buckley -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: May 10, 2017 7:43 PM To: [email protected] 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 to update that custom table? 03. After successfully SATTACHing that custom table in R:BASE X Enterprise database, are you able to PROJECT to a real R:BASE Table (or Temporary Table)? Hope that provides you with some blue's clues ... Feel free to reach out to me if you need further assistance in making R:BASE X Enterprise a Front-End for your SQL ERP system. Very Best R:egards, Razzak At 10:19 AM 5/10/2017, 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 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 -- 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. -- 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.
