Method Community

Hi Dave, I think I can see a way forward from here. Thanks a lot. Jason

 Hi Jason L, We do not grant programmatic SQL access. That would be a severe security policy violation (among other issues....). The synchronization between your method account and quickbooks is handled via the method synchronization engine. (You can read up on that in the documentation at ...

And this may seem like a stretch, but I even tried SQL script of ISNULL(viewCustomer.Notes,'') and this didn't work, either.

I've successfully added another column for my Addresses.  I needed the SQL override for this column since it conatined multiple items (Address, City, State, and Zip), and it's working just fine.  Here's the script I used to that: SQL script: ISNULL(viewContacts.BillAddressAddr3,'') + '<br />' + ...

[quote user="Jason_L"]Can you give me ideas on how I can do that?[/quote] I'm going to move this thread to the API forum and I can say I don't think what you're trying to do is possible ouside the Method API.  From my knowledge there is no direct access to our database without going through the API.

As part of our business plan, we are devloping a java applet that will be run atuomatically and needs to write to our SQL database directly, without human interaction. Therefore, we need to be able to connect with the database directly. We're using Java and the JDBC standards. I've found the correct MS SQL driver for the database, but ...

[quote user="SMFletcher91"]I'm trying to add a column to my lead list.[/quote] On step 2 of 9 while editing a grid you should be able to add additional columns to your grid here.  Is there a reason why you're using SQL overrides to show columns that exist in the table the screen is based on?  You should be able to ...

 A small correction to my earlier post. The opportunity is always saved properly.  In case (1), an estimate is created.  In case (2), a sales order is created instead of an estimate.

I have a customized New Opportunity screen, a customized Estimates screen, and a customized Sales Order screen, amoung others.  I added a button to the New Opportunity screen, 'Save & Create Estimate', whose purpose is to save the opportunity, then create an estimate from the opportunity, save the estimate and go to the ...

It is a stock screen. It is the first time that I try to use that screen. Thank you.