corrupt database

[Elizabeth Robar]

I'm on a PowerPC, OS X - 10.2.3, using primarily REALBasic 4.5.1 to 
work with the Valentina (1.9.6) database.  As for ViSQL, it's 1.1a22 
(compiled by RB 4.5.2 with Valentina 1.9.6).

I just tried reproducing it with a brand new database (one table with 2 
fields).  This is curious: the statement
	SELECT * FROM sysitem WHERE value <> 0
worked without a problem, but
	SELECT * FROM sysitem WHERE value<>0
(without the spaces) caused the same old crash.  I've done this at 
least 2 times now, with brand new databases, created both through code 
and through Valentina Carbon.

Are you interested enough that you'd like a look at the crash log?

Liz

On Friday, January 31, 2003, at 05:31  PM, Ruslan Zasukhin wrote:

> on 2/1/03 12:10 AM, Elizabeth Robar at erobar at earthlink.net wrote:
>
>> I know it sounds strange - to have a good database, then issue a 
>> SELECT
>> (Read) statement, and have it croak - but I've even reproduced it!
>
> You use Win/mac ?
> What version ?
> What product ?
> What version of viSQL?
>
> Can you really reproduce this few times and describe way how to do 
> this?
> Only some special db or any db ?
>
>
>> My (uneducated, wild) guess is that the system table sysitems didn't 
>> like it
>> somehow... whereas a normal, user-defined table might not have taken 
>> it so
>> poorly.
>
> What about system tables you speak?
> Valentina system tables?
> But they are changed only if you change db structure.
> SELECT do not touch them in any way.
>
>> Unfortunately, I was using one-file mode - so the below method won't
>> help in restoring the data.  I did have a backup, so it's not
>> essential... but I'm interested in possible restoration methods for 
>> the
>> future.  Along with development, I'm doing a lot of manual input, and 
>> I
>> only make copies every so often... maybe I'll increase the frequency.
>
> First of all will be great if you teach me how to reproduce and I will 
> fix
> this problem.
>
> -- 
> 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://listserv.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>