ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> IS.NOTE.ALPHA cant find this in ISNOTES after upda
http://www.istechforum.com/YaBB.pl?num=1373908635

Message started by shadowcaster on 07/15/13 at 10:17:15

Title: IS.NOTE.ALPHA cant find this in ISNOTES after upda
Post by shadowcaster on 07/15/13 at 10:17:15

updated to the latest thing

cant see this field in the database using access

IS.NOTE.ALPHA

isn't it supposed to be in the ISNOTES table ?

Title: Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Post by Kelloggs on 07/15/13 at 10:42:28

It is there (ISNOTES)

After you update to the latest thing, did you run EVOUTIL?

It seem that your DDF and ODBC needs to be update.

:P

Kelloggs

Title: Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Post by shadowcaster on 07/15/13 at 11:14:24

Thanks between that and relinking the table im good to go

JW

Title: Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Post by Kelloggs on 07/15/13 at 12:32:35

I personally don't like to link tables. I use pass-through queries.
You can even modify them via VBA

var_sql = "SELECT * FROM MY_TABLE WHERE MY_FIELD = 12345"
CurrentDb.QueryDefs("DBA").SQL = var_sql

;)

Kelloggs

Title: Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Post by shadowcaster on 07/15/13 at 17:14:05

whats the advantage ?

Title: Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Post by Kelloggs on 07/16/13 at 07:20:21

For this simple reason:

Quote:

Properly used pass-through queries are faster, as the query runs on the server and only passes back the matching records.

Also:
No-record locking issues
No risk of users accidentally deleting or editing.

:P

Kelloggs