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 DO.T 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@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 DO.T macserve.net
> http://listserv.macserve.net/mailman/listinfo/valentina
>
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://listserv.macserve.net/mailman/listinfo/valentina
©2003 Elizabeth Robar |
