My Stuff
Comments
-
Hi @Mikko De La Fuente-Oracle , but In Oracle documentation, scale has the minimum value -84 which is more than -127, nor did I see intermediate values, either -127 or 0+ after data analysis, also didn't find any logic, these values are not so big to round to 127 digits: it looks more like a bug or some default or…
-
fyi @Erick Dela Rosa-Oracle , double-quotes work: SELECT TOP 1 "group" FROM EntityGroupMember
-
not everything is as good as we would like ? SELECT t.level FROM CustomerGroupPricing t works fine, but SELECT t.group FROM CustomerGroupPricing t doesn't work(
-
HI @Erick Dela Rosa-Oracle , this works, thanks so much!
-
Hi Erick, There is no answer in the community. The issue is still exists. Curious why NetSuite does not support a syntax available even in the earliest versions of Oracle?
-
Hi Mikko, yes, I still need assistance on this. Just to add more context: We are implementing a replication service, The connection to Netsuite fails on a big query (eg: transaction_lines with 10M rows). the timeout is not constant, rather looks like a random value, starts from 3 hours, sometimes it can reach up to 10-20…
-
Hi Mikko, yes, sure, we use this code: _command = _connection.CreateCommand(); _command.CommandText = _commandText; _command.CommandTimeout = 0; return await _command.ExecuteReaderAsync(CommandBehavior.SingleResult); Additionally, fetching large data volume will result to timeout due to custom field limitation. See…
-
Hi Mikko, We use our dotNet client (C#) via NetSuite ODBC driver.