Method:Classic General Q&A

Re: SQL Override table name

MikeH — Sat, 22 Feb 2014 00:14:33 GMT

So if it is a Method-only table I should use 'view' and if it is a QuickBooks table I should use 'viewacc'. I'll keep that in mind.

Thanks for the help!

Re: SQL Override table name

Method_Greg — Fri, 21 Feb 2014 22:54:46 GMT

Hello Mike,

I have been told I was wrong. 'view' tables are ones that store information that is not for QuickBooks, but for Method. 'viewacc' tables store accounting information from QuickBooks. You can ignore my previous post.

Re: SQL Override table name

Method_Greg — Fri, 21 Feb 2014 21:35:14 GMT

Hello Mike,

I'm not sure the techincalities of the database structure. My thoughts were that the 'view' prefix is for a temporary table holding the fields for the view and the 'acc' prefix denotes the actual tables.

- Greg

SQL Override table name

MikeH — Thu, 20 Feb 2014 00:17:41 GMT

I was having a problem with the SQL Override in a grid and found the solution, however, I don't understand why it works and hope someone can help clarify the naming convention.

I have a grid based on a table called "ProductFamily". I was getting a record count in another table called "Item" with the following:

"SELECT Count(viewaccItem.RecordID) FROM viewaccItem WHERE viewaccItem.ProductFamily_RecordID = viewaccProductFamily.RecordID"

There was an error generating the grid and I found that the problem was due to how I was referencing the ProductFamily table (the table the grid is based on). I removed "acc" from the table name and everything worked perfect (viewProductFamily instead of viewaccProductFamily).

Does anyone know why the "acc" is dropped from a table name reference when it is the table for the grid (use view[table name] instead of viewacc[table name])? The only thing I could think is that "acc" tells the system to look for an external table but if that is the case, why would you need to put "view"?

Thanks!