My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() Post#1 | |
![]() Posts: 670 Joined: 19-March 09 From: Europe, SLOVAKIA, Bratislava ![]() | Hi I want to update table with CODE UPDATE TABLE SET COLUMN_NAME + chr(190) = 'AAA'; Query direkt editing.....copy/paste name and Run Query.............OK Create Query programmatically..... ľ............chr(190), character required ¾ .........wrong character, if executing query ![]() -------------------- (dBase,FoxPro,MS Access 2003,(2010=Not recommended),Office 2010+ACC.2013 ,Symbian C++), wiki-AC.Menu_Bar->,Access 2013 Error:System Resource Exceeded...?, Access 2013 System Resource...GetCurrentFreeSize=? |
![]() Post#2 | |
![]() UtterAccess VIP Posts: 6,998 Joined: 30-June 11 ![]() | I think you're going to have to explain things a little more for us to be able to understand the issue and be able to offer any advice. -------------------- Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018) Professional Help: https://www.cardaconsultants.com Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net * Design should never say "Look at me". It should always say "Look at this". -- David Craib * A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions) |
![]() Post#3 | |
![]() UtterAccess VIP Posts: 1,879 Joined: 4-June 18 From: Somerset, UK ![]() | If you are suggesting using special characters in field names (table or query), it is a bad idea. Use alphanumeric characters & if you must, underscores, only -------------------- |
![]() Post#4 | |
![]() Posts: 670 Joined: 19-March 09 From: Europe, SLOVAKIA, Bratislava ![]() | Hi, i am sorry... Table with ColumnName = 'COLUMN_NAMEľ' ..the last special character is chr(190) Query direkt editing.....copy/paste name and Run Query.............OK CODE UPDATE TABLE SET COLUMN_NAMEľ' = 'AAA'; Problem: but, the same does not work programmatically.. CODE UPDATE TABLE SET COLUMN_NAMEľ' = 'AAA'; 'if running query Error...unknown column name UPDATE TABLE SET COLUMN_NAME¾' = 'AAA'; there is some Character Conversion behind the scene... from ľ............chr(190), character required to ¾ .........wrong character, if executing query ![]() -------------------- (dBase,FoxPro,MS Access 2003,(2010=Not recommended),Office 2010+ACC.2013 ,Symbian C++), wiki-AC.Menu_Bar->,Access 2013 Error:System Resource Exceeded...?, Access 2013 System Resource...GetCurrentFreeSize=? |
![]() Post#5 | |
![]() UtterAccess VIP Posts: 11,253 Joined: 10-February 04 From: South Charleston, WV ![]() | More context might help. Can you post the program code? What happens if you do this "UPDATE TABLE SET COLUMN_NAME" & chr(190) & " = 'AAA'" ? -------------------- Robert Crouser |
![]() Post#6 | |
Posts: 368 Joined: 2-April 18 ![]() | I agree with projecttoday for more context, but I would suggest to put your field name between [ ] (it is a very curious name, both with ľ' or ¾) -------------------- Please forgive in advance my horrible English. |
![]() Post#7 | |
![]() Posts: 670 Joined: 19-March 09 From: Europe, SLOVAKIA, Bratislava ![]() | Hi, it was really very difficult... ![]() CODE For I = 128 To 65535 ' ChrW= 128–65,535 'I_EXEC = TT_GET_ROWS_COUNT("K_CDB", "LEN(TRIM(NZ([Spracovateľ])))>0") I_EXEC = 0 I_EXEC = TT_GET_ROWS_COUNT("K_CDB", "LEN(TRIM(NZ([Spracovate" & ChrW(I) & "])))>0", bIgnoreErrors:=True) If I Mod 1000 = 0 Then Debug.Print I If I_EXEC > 0 Then Debug.Print I_EXEC, I: Exit For Next I Debug.Print "END" and the MATCHCODE IS = 317 ![]() CODE [Spracovate" & ChrW(317) & "] ..the last wide character is UNICODE=317 -------------------- (dBase,FoxPro,MS Access 2003,(2010=Not recommended),Office 2010+ACC.2013 ,Symbian C++), wiki-AC.Menu_Bar->,Access 2013 Error:System Resource Exceeded...?, Access 2013 System Resource...GetCurrentFreeSize=? |
![]() Post#8 | |
![]() UtterAccess VIP Posts: 1,879 Joined: 4-June 18 From: Somerset, UK ![]() | Glad you have a solution. I'm not going to pretend I understand it! Just read you signature line and wonder why you say 2010 not recommended. I have been using that as my default development version for 10 years and in my opinion it is far better than any version before or since both in terms of the features included and the user interface. So why don't you recommend it? -------------------- |
![]() Post#9 | |
![]() UtterAccess VIP Posts: 6,998 Joined: 30-June 11 ![]() | QUOTE wonder why you say 2010 not recommended. I hadn't notice, but fully agree. My favorite versions remain 2003 (all time best!) and 2013 (closely followed by 2010, but there was an issue with format change incompatibility between SP1 and SP2 if memory serves me). I'd stay away from 2007 and any 2016+/O365 as they are simply packed with bugs! -------------------- Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018) Professional Help: https://www.cardaconsultants.com Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net * Design should never say "Look at me". It should always say "Look at this". -- David Craib * A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions) |
![]() Post#10 | |
![]() Posts: 670 Joined: 19-March 09 From: Europe, SLOVAKIA, Bratislava ![]() | Hi, QUOTE wonder why you say 2010 not recommended. because of daily Errors...System resources exceeded ![]() On msdn forum, i have posted an Test Database, ...only after many SQL.Table updates....there appears allways : System resources exceeded (This Test Database in AC 2016.....OK) Without any code changes, In WIN=10.AC 2016....no more such problems. Only sometimes,(about 1-2 times in a week) appears something like...database size is over Limit 2GB ![]() and the database size is 100% .......not over Limit. and there is NO TOOL, for checking FREE System resources... ![]() May be in my code is missing somewhere Memory cleanup...., but there is also , my opionion, AC2010 Memory Problem, or WIN 7 ? I am using very often ARRAYS... -------------------- (dBase,FoxPro,MS Access 2003,(2010=Not recommended),Office 2010+ACC.2013 ,Symbian C++), wiki-AC.Menu_Bar->,Access 2013 Error:System Resource Exceeded...?, Access 2013 System Resource...GetCurrentFreeSize=? |
![]() Post#11 | |
![]() UtterAccess VIP Posts: 1,879 Joined: 4-June 18 From: Somerset, UK ![]() | I have only rarely experienced system resource issues in 10 years of regularly working with A2010. As each version of Access is less tolerant of code errors than those before it, I would expect A2016 to have the same issues as A2010. Resource errors can be managed in various ways e.g. by checking AvailableConnections, increasing the number of MaxLocksPerFile etc. By contrast to your experience, I have found A2016/365 to have more bugs and be far more likely to crash. Are you saying there is a tool available in A2016 for checking system resources that A2010 doesn't have? If so, please enlighten me what it is. -------------------- |
![]() Post#12 | |
![]() Posts: 670 Joined: 19-March 09 From: Europe, SLOVAKIA, Bratislava ![]() | Hi QUOTE Are you saying there is a tool available in A2016 for checking system resources that A2010 doesn't have? does not exists and there is NO/NONE TOOL, for checking FREE System resources... ![]() Only indirectly, i can build VERY-LARGE-STRING-ARRAYS ....up to waiting for Error: System Resources Exceeded ![]() -------------------- (dBase,FoxPro,MS Access 2003,(2010=Not recommended),Office 2010+ACC.2013 ,Symbian C++), wiki-AC.Menu_Bar->,Access 2013 Error:System Resource Exceeded...?, Access 2013 System Resource...GetCurrentFreeSize=? |
![]() Post#13 | |
![]() UtterAccess VIP Posts: 1,879 Joined: 4-June 18 From: Somerset, UK ![]() | Sorry but I don't understand your reply. Probably a language issue. Did you look at my utility - link in previous reply? If not, see if it helps identify issues to prioritise where the design can be improved Have you tried increasing the MaxLocksPerFile settings? -------------------- |
![]() Post#14 | |
UtterAccess VIP Posts: 10,335 Joined: 30-April 10 From: Pacific NorthWet ![]() | Why are you renaming the column? That is, what will having a new column name then allow you/Access to do? (I ask because there may be more than one way to accomplish what you wish to do, but we'd need to know what that is) -------------------- Regards Jeff Boyce Microsoft Access MVP (2002-2015) Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible. |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 8th December 2019 - 04:01 AM |