[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== can't link table columns to form (OpenInsight 32-bit Specific) ====
=== At 13 OCT 2009 07:29:19PM Yun Lee wrote: ===
{{tag>"OpenInsight 32-bit Specific"}}
I created form and trying to set table columns to controls. But I can select table but not columns in the database association. I deleted table, copied clean table from other db, attached and added some new table columns. I have still same problem. How can I link form to table and what is the problem? Can someone help me?
----
=== At 14 OCT 2009 12:56AM Ray Chan wrote: ===
After you select the table and try to select a column what happens? Do you get any message? What version of OI? Also, are you having this problem with only one form? Are other forms okay?
Ray Chan
----
=== At 27 OCT 2009 11:34PM Yun Lee wrote: ===
Sorry Ray,
I gave up.
My OI version is 8.0.1.
After selecting table there is no column at all in drop down box.
All forms which are linked with this table have same problem.
----
=== At 28 OCT 2009 10:21AM Simon Wilmot wrote: ===
Have you got a %RECORDS% record in the data table. If so delete it.
HTH,
Simon
----
=== At 15 NOV 2009 06:17PM Yun Lee wrote: ===
Sorry I had to do other things urgently.
No, the data table has not %RECORDS%. I have still same problem.
I think this happens after dictionary upgrade. Do you have any ideas?
----
=== At 16 NOV 2009 03:53AM Simon Wilmot wrote: ===
Sorry - mis-read the previous message, what about %RECORDS% on the dict
Any MFSes attached to the dict ??
If you open the dict in system editor, do you see the fields ??
Are there any with '%'s ??
Simon
----
=== At 16 NOV 2009 04:46AM Bill Caisley wrote: ===
If you have a Quickdex.mfs on the DICT. then remove it and redo any indexes.
----
=== At 17 NOV 2009 06:33PM Yun Lee wrote: ===
Hello Simon,
We don't use MFS.
When I open the dict.student Row has %FIELDS%, %PROTECT.SPEC%, %SK%, %WINDOWS% and fileld names.
----
=== At 17 NOV 2009 06:34PM Yun Lee wrote: ===
Hello Bill
I cannot see Quickdex.mfs on the DICT.STUDENT.
----
=== At 18 NOV 2009 04:58PM Ray Chan wrote: ===
Hi Yun,
Just a thought, but what do you think about just remaking the Table and start fresh. Is this possible?
FWIW,
Ray Chan
----
=== At 22 NOV 2009 04:50PM Yun Lee wrote: ===
Hello Ray,
If I copy the same table from other systems. It is all right. But If I upgrade dictionary with that table, same problem happens.
For the dictionary upgrade, the other people's system are all fine.
At that time when it happened I tried to use ODBC connection to MS Access. I tested several times and I had problems with ODBC. Do you think is it related?
Making new table is very hard b/c it has over 2000columns. I will copy old version table, make new dictionary upgrade patch and upgrade.
----
=== At 22 NOV 2009 05:11PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote: ===
Are you using UTF8 mode? If so this is a known bug - bug 1245 in the tracker.
[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]
[url=http://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]
[i]World leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 24 NOV 2009 08:20PM Yun Lee wrote: ===
So is there a solution?
----
=== At 25 NOV 2009 03:46AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote: ===
It will be addressed in the next OI release. A workaround would be to copy a pile of dictionary items out with deletion, paint your form then copy them back in.
[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]
[url=http://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]
[i]World leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 25 NOV 2009 11:32AM Ray Chan wrote: ===
Mr. Sprezz,
You always have the answer! Good job in diagnosing the problem.
Happy Thanksgiving!
Ray
----
=== At 25 NOV 2009 12:07PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote: ===
Why thank you Mr Chan Sir! We tend to see this more than most as our European clients tend to use UTF8 and so run into issues like this.
All the best for a joyous Thanksgiving Weekend.
[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]
[url=http://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]
[i]World leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 26 NOV 2009 02:04PM Yun Lee wrote: ===
Thank you all very much for your help
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=2EF5E3F6A0113BE58525764E008106DE|View this thread on the forum...]]