3937506 Newbie

select top 10 * from table should work for this. I was able to get the first 10 employees in the employees table with: select top 10 * from employees

Sorry, ignore last post. I think that was specific to my client, not ODBC in general

Hi Scott, try, select current_date;

Hello Dave, can you please contact support to have one of our reps help investigte this with you and post your case number back on this thread? It's difficult to say without looking at the customizations in your account whether or not this is a Defect.

TRUNC with zero decimals places, in my formula, is the equivalent of taking the FLOOR of a number (rounding down) as I was interested in how many complete hours have past (e.g. 3 hours and 45 minutes would mean, in my use case, that only 3 hours have past). The sample I gave was taken from an old Saved Search of mine so…

You can use LAST_DAY to negate the first of the month portion of the TimeOfDay object by using it on both SYSDATE and your custom TimeOfDay field and then calulating the difference. I have a use case where I store both the date and time of date as two seperate fields on an Issue Record and I calculate the age of the Issue…

I believe your are referring to the NetSuite SuiteScript IDE for Eclipse. If so, the link is: http://suitesource.netsuite.com/s.nl/it.A/id.82/.f

Defect 152647 has been filed for this use case.

Hello PC15, the new logs should have no impact on execution constraints on scheduled scripts. If your scheduled script is terminating before 10 minutes or 10,000 units, can you contact support to help investigate further and post your case number on this thread.? If you have not done so already, you may want to add the…

It looks like you may have an undeclared variable in your code as you never set a value for the variable 'count' i.e. var SalesOrder = nlapiLoadRecord(searchresults[i ].getRecordType(),searchresults[count].getId()); should probably be: var SalesOrder = nlapiLoadRecord(searchresults[i…

i apologize, wrong thread.

Support has filed Defect 150332: SuiteScript > nlapiGetFieldValue on a Multi Select field type returns a string with a delimiter of chr(5) and not an array to address this concern. If any users are being affected by this Defect, please call into Support to have a case created and attached to this Defect.

There are a few differnent ways to implement this. One way might be to host a Suitelet that will search for existing quantity for a passed in item ID and render the message depending on your condition. You can then insert the Suitelet output as an Iframe in your template and pass the item ID of the item via the URL call to…

Sorry, the link to the doc should be http://acct-java001.svale.netledger.com/help/helpcenter/en_US/Output/Help/SuiteFlex/SuiteScript/SSR__5.html?NS_VER=2008.1.0

the '_frequency' field on the 'calendarevent' record doesn't appear to supported as an editable field via SuiteScript according the latest documentation https://system.netsuite.com/app/help/helpcenter.nl?topic=EDIT_EVENT Please contact Product Support to have a Enhancement entered for your account to have this field…

For any other users that are encountering issue, Defect 142683 was filed for this behavior. Please call into Product Support to have a case attached to this Defect.

Has anyone ever tried Suitelet integration with any of the Google apps? I haven't used Google apps specifically but I have used external JS API libraries with Suitelet with a fair degree of success. I know the Calendar app has a JavaScript API that should be compatible with Suitelet/UI object intgration…

We have a couple of full C# WS apps w/source at http://www.netsuite.com/portal/developers/resources/suitetalk-sample-applications.shtml These may be useful to help you get started. You may need to comment out the applicationid assignment though //_appInfo.applicationId = "100200"; before runtime as I believe that this ID…

Did you get a case number for your call? I've seen the error in past when the soft limit on record submission is exceeded. Based on p12 of the latest SuiteTalk Platform Guide, during peak hours (6am -6pm PST) ADD/ADDLIST has a limit of 100 records per request and off-peak hours has a limit of 200 records per request. The…

Steve, I couldn't reproduce the error in my own VS 2008 Express/3.5 Framework environment when upgrading the Web Reference in one of my C# apps to the new WSDL, https://webservices.netsuite.com/wsdl/v2008_1_0/netsuite.wsdl. However, I did file Defect 144758 to have this behaviour investigated further. If anyone else is…

I have recently been using a freeware application for SOAP capture. I just tried it with one of my C# WS apps and it allows me to capture SOAP request and responses, in real-time, from my application without having to alter any of my source code or change port values Here’s the link:…

Looks like there was an updated Platform Guide PDF uploaded on April 2, 2008. You might have an older copy. Here's the direct link https://system.netsuite.com/help/helpcenter/en_US/PDF/SuiteTalkWebServicesPlatformGuide.pdf

There's another example on page 101-102 of the same guide Customer customer = new Customer(); // Get nsKey for update _console.write("\nEnter nsKey for customer record to be updated : "); customer.setInternalId(_console.readLn().toUpperCase()); // Set name and email customer.setEntityId("XYZ 2 Inc");…

There's some sample Java code on page 95 of the latest SuiteTalk Platform Guide of reading the address from a customer record: if (response.getStatus().isIsSuccess()) { _console.info("\nThe following customer was added successfully:" + "\nkey=" + ((RecordRef) response.getBaseRef()).getInternalId() + "\nentityId=" +…

Case# 766419 has been filed with support.

Support has filed Defect 150332: SuiteScript > nlapiGetFieldValue on a Multi Select field type returns a string with a delimiter of chr(5) and not an array to address this concern. If any users are being affected by this Defect, please call into Support to have a case created and attached to this Defect

I'm wondering if this might have been a misunderstanding on our end where we had the impression that you were remoting into a server. Can you try the following steps? Go to Outlook > Help > About Miicrosoft Outllook Click Disabled Items button Highlight Netsuite Intergration Click Enable Restart Outlook This might have…

There's two different ways to do this: One is in IE, when prompted to load both secure and non-secure items, just hit 'No'. When you view the page, look for any images that didn't load (empty spaces). The other method is in Firefox, navigate to Tools > Page Info > Media and look for any images/media that has a link that…

Hi Jeff, I visited the site http://www.justpaperroses.com and received the warning as well when checking out. I'm pretty sure the warning is being caused by the logo in the top right hand corner "Free Anniversary Gift Guide", http://www.justpaperroses.com/site/images/body-header-promo.gif. You should replace this link with…

Damon, we have filed Defect 145584 this morning for further investigate your ongoing issue. It has been attached to case 724009.