Welcome, Guest. Please
Login
.
05/09/25 at 06:01:20
News:
|
IS Tech Support
|
Evo~ERP
|
Evo Wiki
|
Forum
|
ISTech Support Forum
›
Evo-ERP and DBA Classic
›
Problem Reports - Repeatable
‹
Previous topic
|
Next topic
›
Pages: 1
IS.NOTE.ALPHA cant find this in ISNOTES after upda (Read 1081 times)
shadowcaster
Active Member
I'm not here because
I know what to do.
Posts: 678
Gender:
IS.NOTE.ALPHA cant find this in ISNOTES after upda
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 ?
Back to top
IP Logged
Kelloggs
Active Member
Do crazy people know
they are crazy?
Posts: 784
Gender:
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #1 -
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.
Kelloggs
Back to top
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
IP Logged
shadowcaster
Active Member
I'm not here because
I know what to do.
Posts: 678
Gender:
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #2 -
07/15/13 at 11:14:24
Thanks between that and relinking the table im good to go
JW
Back to top
IP Logged
Kelloggs
Active Member
Do crazy people know
they are crazy?
Posts: 784
Gender:
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #3 -
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
Back to top
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
IP Logged
shadowcaster
Active Member
I'm not here because
I know what to do.
Posts: 678
Gender:
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #4 -
07/15/13 at 17:14:05
whats the advantage ?
Back to top
IP Logged
Kelloggs
Active Member
Do crazy people know
they are crazy?
Posts: 784
Gender:
Re: IS.NOTE.ALPHA cant find this in ISNOTES after
Reply #5 -
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.
Kelloggs
Back to top
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
IP Logged
Pages: 1
ISTech Support Forum
›
Evo-ERP and DBA Classic
›
Problem Reports - Repeatable
‹
Previous topic
|
Next topic
›
Forum Jump:
-----------------------------
Evo-ERP and DBA Classic
-----------------------------
- User Polls
- EvoERP Flash Videos
=> Problem Reports - Repeatable
- Problem Reports - Sporadic
- Manufacturing
- Items
- Sales
- Accounting
- System Manager
- Payroll
- Bar Code & Hand Held Interface
- RTM Reports & Editing
- Evo Menu & Evo-ERP
- Installation
- Suggestions for Updates
- General DBA Topics
- DBA & Evo Local User Groups
- IS Tech Symposium & Training
- Program Offerings
- Jobs
- Source Code and Programming in TAS
- Web Storefront
-----------------------------
Windows & Network Issues
-----------------------------
- General Windows & Network Issues
-----------------------------
Pervasive SQL
-----------------------------
- PSQL General Issues
-----------------------------
Crystal Reports, ODBC & Access
-----------------------------
- Crystal Reports General Issues
- ODBC General Issues
- Access General Issues
-----------------------------
General
-----------------------------
- What is IS Tech Support?
- News
- Prizes for Active Forum Users
- EziJobz/Next Generation
- Fun Stuff
ISTech Support Forum
» Powered by
YaBB 2.1
!
YaBB
© 2000-2005. All Rights Reserved.