Problem with TTable using a view which returns a memo and using indexfieldnames

ji...@my-dejanews.com

Delphi Developer

Fri, 02 Nov 2001 03:00:00 GMT

Problem with TTable using a view which returns a memo and using indexfieldnames

I am converting a project from Delphi 1 to Delphi 4.03. I am using SQL
Anywhere 5.04. There is code which has a ttable which references a view. The
view returns a memo field and I am using the indexfieldnames property to
order the results.

If I then call the append method I get an access violation. It is actually
caused by the call to DbiGetBookmark in the GetRecord procedure in the
TBDEDataSet object.

It seems to be the combination of a view, the memo field and the
indexfieldnames which causes the error.

Has anyone discovered this behaviour and if so what was the remedy??

--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---

David Rifki

Delphi Developer

Fri, 02 Nov 2001 03:00:00 GMT

Re:Problem with TTable using a view which returns a memo and using indexfieldnames

Quote

On Mon, 17 May 1999 15:24:02 GMT, ji...@my-dejanews.com wrote:
>I am converting a project from Delphi 1 to Delphi 4.03. I am using SQL
>Anywhere 5.04. There is code which has a ttable which references a view. The
>view returns a memo field and I am using the indexfieldnames property to
>order the results.

>If I then call the append method I get an access violation. It is actually
>caused by the call to DbiGetBookmark in the GetRecord procedure in the
>TBDEDataSet object.

>It seems to be the combination of a view, the memo field and the
>indexfieldnames which causes the error.

>Has anyone discovered this behaviour and if so what was the remedy??

Do you mean SQL Anywhere 5.5.04? I've seen similar things, but not
identical. Make sure that IndexFieldNames is never blank, even when you
first open the table. You can change the order all you like, but if you
switch between indexed and non-indexed, it'll usually blow up.

--
"Generally speaking, things have gone about as far as they can possibly
go when things have got about as bad as they reasonably get."

Other Threads

1. TTable using view returning memo with indexfieldnames

2. TTable using a View with Memo and Indexfieldnames

3. TTable: Big problem when sorting with IndexFieldNames or IndexName

4. View using views

5. Access Violation Using IndexFieldNames Property

6. Using Return Key Within an OnKey Event Handler for Return Key

7. Problem vid Locate procedure when using view in a TQuery component

8. MS SQLServer 7.0 - Problems using stored procedures and views

9. Problem with Locating the File While Using Local Views

10. Problem getting return value using TADOStoredProc