[V4MD] 1.11 Carbon bug?

[Ruslan Zasukhin]

On 9/26/04 11:00 AM, "Daniel Crowder" <daniel at monumental-i.com> wrote:

>> Send me please just database, and the full text of above query.
>> I will try do it from viSQL
> 
> Will do. Although the queries are very very simple. Here are the actual
> dynamic queries - they all work in 1.10 and not in 1.11 using OSX V4MD
> in Director 10.1.
> 
> Here is the data:
> http://comps.monumental-i.com/example/data.zip
> 
> Here are the commands:
> 
> -- "SQL  ->  SELECT *, RecID FROM categories WHERE RecID=28"
> -- "V4MD ->  UpdateAllRecords(dbCursor,[#sequence:8])"
> -- "SQL  ->  SELECT *, RecID FROM categories WHERE RecID=2"
> -- "V4MD ->  UpdateAllRecords(dbCursor,[#sequence:8])"
> -- "SQL  ->  SELECT *, RecID FROM categories WHERE RecID=80"
> -- "V4MD ->  UpdateAllRecords(dbCursor,[#sequence:8])"
> -- "SQL  ->  SELECT *, RecID FROM categories WHERE RecID=87"
> -- "V4MD ->  UpdateAllRecords(dbCursor,[#sequence:8])"
> -- "SQL  ->  SELECT *, RecID FROM categories WHERE RecID=158"
> -- "V4MD ->  UpdateAllRecords(dbCursor,[#sequence:1])"
> -- "SQL  ->  SELECT *, RecID FROM categories WHERE RecID=164"
> -- "V4MD ->  UpdateAllRecords(dbCursor,[#sequence:1])"
> -- "SQL  ->  SELECT *, RecID FROM categories WHERE RecID=165"
> -- "V4MD ->  UpdateAllRecords(dbCursor,[#sequence:1])"

In viSQL I can see that search is fine.
So assume you have problems with UPDATE ALL?

But then check your creation of cursor.
Have you specify ReadWrite mode ?


> One favor: If I give you the database would you be so kind as to tell
> me what you would recommend the memory setting to be with that
> database? I currently have it set to  ValentinaInit( 20 * 1024 * 1024,
> "XXXXX", "XXXXXX" ) - is that too much memory?

I see that your db total take 7-8MB

So if this is all what you have then yes you can use 10 and even 5 MB.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------