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.
