Hi all,
Firstly, how do I define a string table field with constraints on its size?
For example Text(3), string of three characters. Secondly, how is it
enforced during updates? Many thanks!
Best Regards,
Anabell
-
To
borivoj wrote:
In an attempt to generate more interest for TWS:
You can download windows version on
http://unicast.org/archives/000508.html, follow the link "installer"
While it is still not a single exe file, it works, and it is so easy to
install. I have installed it on a Compact Flash
In an attempt to generate more interest for TWS:
You can download windows version on
http://unicast.org/archives/000508.html, follow the link "installer"
While it is still not a single exe file, it works, and it is so easy to
install. I have installed it on a Compact Flash drive to move it
> -Original Message-
> From: Peter Mathijssen [mailto:[EMAIL PROTECTED]
> Sent: 23 March 2004 20:10
> To: Greg Obleshchuk; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite and Visual Basic
>
> Greg Obleshchuk schreef:
> > You can't use sqlite in a VB app (VB, VB.net, C#) without a
>
> -Original Message-
> From: Rubens Jr. [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 23, 2004 5:00 PM
>
> I read the OnLine Doc many times and I do not notice this :
> "SQLite expects the SQL string that you pass in to be
> unchanged until the
> SQL has finished executing."
>
> If
>
> SQLite expects the SQL string that you pass in to be unchanged until
> the SQL has finished executing.
OK, here is the problem ... I did not knew that :(
> If you changes the SQL string before
> that, errors can happen, including segfaults. If it worked in 2.8.12,
> it was only because you
Rob Groves wrote:
I have noticed that in 2.8.13 sqlite_compile() can return SQLITE_BUSY. In
2.8.12 I only ever saw SQLITE_BUSY come from sqlite_finalize() after
sqlite_step() had failed. In 2.8.13 it seems it can come from either.
This is not a problem, but what is the intended behaviour?
Rubens Jr. wrote:
>
> I have a global buffer that I use in all querys and to retriev data in my
> callback funcs. Example :
>
> This have worked with version 2.8.12, but when I upgrade to 2.8.13 my
> application sometimes show stranges errors like 'near "x" : syntax error'
> where x is
Hi all,
I'm working on an update to CppSQLite.
I have noticed that in 2.8.13 sqlite_compile() can return SQLITE_BUSY. In
2.8.12 I only ever saw SQLITE_BUSY come from sqlite_finalize() after
sqlite_step() had failed. In 2.8.13 it seems it can come from either.
This is not a problem, but what is
>
> You're asking for trouble using strcpy() with arbitrary data. Your
problem
> may be that you're writing beyond the bounds of my_buffer. Instead of
>
> strcpy (my_buffer, row [0]);
>
> use
>
> strncpy (my_buffer, row [0], sizeof(my_buffer) - 1);
> my_buffer[sizeof(my_buffer) -
"Rubens Jr." <[EMAIL PROTECTED]> writes:
> intmy_callback ()
> {
>
> strcpy (my_buffer, row [0]);
> ...
> }
>
> voidmy_sql (void)
> {
> ...
>strcpy (my_buffer, "SELECT FROM ... WHERE ");
>retcode = sqlite_exec (db, my_buffer,
Hi,
I am currently using sqlite version 2.8.4 on RedHat Linux 7.3 on an IBM
x.220 - x.345.
During a recent testing on the above platforms we discovered a performance
issue when using both the perl sqlite module as well as the standard sqlite
client. When attempting to perform a large number
Hi !
I have a global buffer that I use in all querys and to retriev data
in my callback funcs. Example :
charmy_buffer [2];
intmy_callback ()
{
strcpy (my_buffer, row [0]);
...
}
voidmy_sql (void)
{
...
strcpy (my_buffer, "SELECT
Greg Obleshchuk schreef:
Hi Peter,
There a sample app with the source which shows how to use it, it's
very simple and the app is really all there is to it. One interface
does all. There some tips here http://www.sqlite.org/cvstrac/wiki.
You can't use sqlite in a VB app (VB, VB.net, C#)
> -Original Message-
> From: Banek, MB Matthew (8773) @ IS [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 23, 2004 1:19 PM
>
> The problem I'm having is that the trigger does not use IGNORE for
conflict
> resolution, but uses REPLACE instead, since (as the documentation states)
>
I am adding data to a table with the following statement:
INSERT OR REPLACE INTO MyTable(col1, col2, col3) VALUES(value1, value2,
value3);
and the following trigger has been created:
CREATE TRIGGER AFTER INSERT ON MyTable
BEGIN
INSERT OR IGNORE INTO MyOtherTable(col1, col2)
Hi,
I am using SQLite from within Java. Unfortunately, the Java wrapper
linked from the SQLite website tends to be rather slow when returning
large resultsets from a query. Has anybody a handy solution for /
experiences with that?
Thanks,
Bo
Hello,
I discovered sqlite last week and want to use it in a Visual Basic
program. I also found the SQLite wrapper for Visual Basic from
http://www.ag-software.com/sqlite.aspx. Greg Obleshchuck even, after a
request, updated it's driver to use the latest sqlite version.
Are there any visual
Hello!
I don't understand why do some people have a bad time with conversions, if they want
to store BLOB in SQLite. The official FAQ also recommends that one should use any kind
of conversion to convert binary data to a format that is suitable for SQLite:
http://www.sqlite.org/faq.html#q12
19 matches
Mail list logo
