Hmm, my previous post got not posted because the correct address wasn't set.
Can't get a grip on this board yet :)
A duplicate is not created if there was an error.
And if the name already exists but that would generate an error as well.
You might have been mistaken since there is a sort in the tablenames (?)
I know the gui is not 100%, the technical part is more important for me now.
Writting a better gui can always be done in the future.
There are enough parts in the code i wouldn't publish.
The bottlenecks are the table rebuilds and duplicates+data.
In both cases the table is copied to a new one.
All data *must* be equal as before of course.
pbsdbms transfers data in the X' HEX ' format and should be safe.
But still, databases are very important and if a mistake is made you might
never find out until...?
Therefore the warnings and this extra testing.
Don't forget to check the help, import is a nice feature, all OLEDB/ADO
stuff can be read in (i hope :) )
Give the QBE part a try, it's clean and simple.
Looks like access QBE.
The result query can be copied onto the clipboard and placed in a view or
whatever.
The querydef's are maintained in an 'hidden' table.
(It's made hidden in pbsdbms only of course)
Version 2 is rather obsolete, are there more people interested in v2.8
support?
And why?
Afaik only the blob part might be troublesome for me.
Maybe no NUL char support.
Not my favourite, i like sqlite3 as it is now very.
----- Original Message -----
From: "Andrew Brampton" <[EMAIL PROTECTED]>
To: "Edwin Knoppert" <[EMAIL PROTECTED]>
Sent: Tuesday, August 16, 2005 10:12 PM
Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i
wrote.
Hi again,
ok I just tested Duplicate again and it did work, but I swear 10minutes
ago it didn't. Maybe there is some odd situation that caused that :/
Mail me back and I'll write you out the list.
What does that mean, you're no longer testing?
Sorry I meant, if you want me to give you feedback on the GUI mail me back
and I'll write out a list. I didn't want to write out the list if you
didn't want it (because in your orginal email you said "not what to change
like gui changes".
Oh as for the open sourcing I'm not going to convince you to, but I'm
curious as to why you want to stay closed?
So far I've not found any "critical" bugs, only the little things I
already mentioned. It seems pretty good, and with a few minor tweaks I'm
sure it be ready to release.
oh another idea!. Any chance for SQLite 2 and 3 support?
Thanks
Andrew
----- Original Message -----
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: "Andrew Brampton" <[EMAIL PROTECTED]>
Sent: Tuesday, August 16, 2005 9:00 PM
Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool i
wrote.
All those things you mention might change in the future.
Main idea about this test to find serious issues.
The table create and a few others is not preferred by me either.
But has no serious impact on it's use at this time.
Duplicate does duplicate a table with or without it's contents, should
work.
Ok name is a random one but it should be identical, if not... ?
I'm considering to rewrite the listview 'engine' to make use of
sqlitre_prepare() instead of .. gettable()
This will have impact on the virtual grid and in the future i might
rewrite that part completely + including a way to edit the contents.
And yes with an optional binary edittor for BLOB data as well.
That's far from now (if ever).
That combo.. well i wanted that myself but at this time that grid is not
able to handle both edit and combo.
Otherwise it would be in right-away.
Mail me back and I'll write you out the list.
What does that mean, you're no longer testing?
Source will not be public no.
----- Original Message -----
From: "Andrew Brampton" <[EMAIL PROTECTED]>
To: "Edwin Knoppert" <[EMAIL PROTECTED]>
Sent: Tuesday, August 16, 2005 9:52 PM
Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool
i wrote.
Hi,
I've received it now... I had a quick play with it and I couldn't find
any way to crash it.
A few comments:
1) When I add a table why does a default table get made? Can't I select
some options before its created?
2) When I duplicate structure why can't I chose its name before its
created?
3) Duplicate doesn't seem to do anything. No message, no error, no
change.
4) Is there a way for me to edit the records in the database?
I haven't played with the Views, Triggers, Indexes or Query Builder yet,
but I will soon
I had some comments about the GUI, but you say you dont' want to hear
about them. They were general HCI comment ie ("I would like drop down
box for the types in the table editor), as opposed to "I don't like the
look of blah, etc", so you may find them useful. Mail me back and I'll
write you out the list.
Ok hope these comments are useful.
Andrew
P.S I see the warning saying its freeware, have you considered open
sourcing it?
----- Original Message -----
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: "Andrew Brampton" <[EMAIL PROTECTED]>
Sent: Tuesday, August 16, 2005 8:30 PM
Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS tool
i wrote.
Just sent it.
I had a few more people so i must be confused somehow :)
Hope you like it.
----- Original Message -----
From: "Andrew Brampton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 16, 2005 6:38 PM
Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS
tool i wrote.
Hi,
Just mailing you off the list...
I haven't received any files... I checked my spam filter and I can't
see it.
What email address did you send from? or if it bounced because of the
attachment maybe you can send me a URL to it.
Thanks
Andrew
----- Original Message -----
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 16, 2005 10:56 AM
Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS
tool i wrote.
Sent..
----- Original Message -----
From: "Andrew Brampton" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 16, 2005 10:38 AM
Subject: Re: [sqlite] I need one or two testers for my SQLITE3 DBMS
tool i wrote.
Sure I'll help out.
Andrew
----- Original Message -----
From: "Edwin Knoppert" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 16, 2005 8:29 AM
Subject: [sqlite] I need one or two testers for my SQLITE3 DBMS tool
i wrote.
I only need a list what i need to correct like critical errors, not
what to change like gui changes or similar.
It's a freeware tool and not being released before it had a better
test than i did.
Mail me if you want to help.
App consists from exe, hlp and sqlite3 dll.
hope you'll look into the help as well.
Here is an image:
http://www.hellobasic.com/images/pbsdbms.jpg
Thanks!
