Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?

[David White]

On 09/19/2018 12:18 AM, David White wrote:
>> I am stuck trying to use the precompiled binaries + Android bindings on
>> Android 8. Does anyone know how to reach the maintainers for this stuff?

>Posting here will work.

>> I have posted a ticket on the wiki but no luck.

>This one, correct?

>   https://sqlite.org/android/info/28d442a2c39bd546

>Thanks for reporting the problem. I actually didn't know you could post
>tickets there - hence the lack of response. Sorry about that.
>
>Should now be fixed here:
>
>   https://sqlite.org/android/info/a113b9be83987fb8
>
>Dan.

Hello Dan. I was actually referring to this ticket:

https://sqlite.org/android/tktview?name=931fee2609

Thanks alot.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to contact Android Sqlite Bindings Maintainers?

[Dan Kennedy]

On 09/19/2018 12:18 AM, David White wrote:

I am stuck trying to use the precompiled binaries + Android bindings on
Android 8. Does anyone know how to reach the maintainers for this stuff?


Posting here will work.


I have posted a ticket on the wiki but no luck.


This one, correct?

  https://sqlite.org/android/info/28d442a2c39bd546

Thanks for reporting the problem. I actually didn't know you could post 
tickets there - hence the lack of response. Sorry about that.


Should now be fixed here:

  https://sqlite.org/android/info/a113b9be83987fb8

Dan.


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] docs: application_id is signed, not unsigned

[William Chargin]

Update: drh fixed this in 3580ba4b5bd75ec6. Thanks!


Best,
WC
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to contact Android Sqlite Bindings Maintainers?

[David White]

I am stuck trying to use the precompiled binaries + Android bindings on 
Android 8. Does anyone know how to reach the maintainers for this stuff? 
I have posted a ticket on the wiki but no luck.


Thanks

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] shell csv import

[D Burgess]

Thank you E.Pasma, most elegant. Solves my problem.


Thank you Rowan, I was trying to achieve it with /bin/sh (dash)

On Tue, Sep 18, 2018 at 7:12 PM, E.Pasma  wrote:

>
> > Rowan Worth wrote:
> >
> > You can also filter out specific messages at the shell level:
> >
> > sqlite foo.db 2> >(grep -v 'expected 7 columns but found 6 - filling the
> > rest with NULL' >&2)
> >
> > But note that the >() syntax is not a POSIX sh feature, and will not work
> > in a script using a shebang of #!/bin/sh. You need to change it to
> > #!/bin/bash or whatever shell you have on hand. For more info see the
> > "Process Substition" section of the bash man page.
> >
> > If you have the ability to modify the generated SQL, presumably you could
> > avoid the error by generating a NULL yourself for the missing column?
> > -Rowan
> I replied just before reading this. This solution may be preferred.
>
>
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] shell csv import

[E.Pasma]

> Rowan Worth wrote:
> 
> You can also filter out specific messages at the shell level:
> 
> sqlite foo.db 2> >(grep -v 'expected 7 columns but found 6 - filling the
> rest with NULL' >&2)
> 
> But note that the >() syntax is not a POSIX sh feature, and will not work
> in a script using a shebang of #!/bin/sh. You need to change it to
> #!/bin/bash or whatever shell you have on hand. For more info see the
> "Process Substition" section of the bash man page.
> 
> If you have the ability to modify the generated SQL, presumably you could
> avoid the error by generating a NULL yourself for the missing column?
> -Rowan
I replied just before reading this. This solution may be preferred. 


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] shell csv import

[E.Pasma]

> I have a script that loads csv into an existing table.
> 
> I get this message on stderr for each row imported:
> 
> "... expected 7 columns but found 6 - filling the rest with NULL"
> 
> 
> We have the means to send stdout to /dev/null using the .once or .output
> 
> Is there a way to send suppress stderr messages for a dot command?

The example below works without warnings (though this diverts from exact 
question).

create table t (a,b,c,d,e,f)
;
/* Procedure to insert a line of input */
create view procinput(a,b,c) as values(null,null,null)
;
create trigger ins_procinput instead of insert on procinput
begin 
  insert into t(a,b,c) values(new.a,new.b,new.c); 
end
;

.import input.dat procinput



___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] shell csv import

[Rowan Worth]

You can also filter out specific messages at the shell level:

sqlite foo.db 2> >(grep -v 'expected 7 columns but found 6 - filling the
rest with NULL' >&2)

But note that the >() syntax is not a POSIX sh feature, and will not work
in a script using a shebang of #!/bin/sh. You need to change it to
#!/bin/bash or whatever shell you have on hand. For more info see the
"Process Substition" section of the bash man page.

If you have the ability to modify the generated SQL, presumably you could
avoid the error by generating a NULL yourself for the missing column?
-Rowan

On 18 September 2018 at 14:28, D Burgess  wrote:

> Thanks hick. But that's not the problem.
> The import will always write to stderr, it's not an error
> Lots of other stuff in the script and I want to be able to catch any errors
> in the other parts of the script.
>
> On Tue, Sep 18, 2018 at 4:20 PM, Hick Gunter  wrote:
>
> > When running a script from the shell, you can redirect stderr tot he null
> > device using 2>/dev/null or to the same destination as stdout using 2>&1.
> > The latter is also very useful in crontab entries, as neglecting to
> handle
> > stderr will result in an email tot he user that contains anything written
> > there
> >
> > -Ursprüngliche Nachricht-
> > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> > Im Auftrag von D Burgess
> > Gesendet: Dienstag, 18. September 2018 08:15
> > An: sqlite-users@mailinglists.sqlite.org
> > Betreff: [EXTERNAL] [sqlite] shell csv import
> >
> > I have a script that loads csv into an existing table.
> >
> > I get this message on stderr for each row imported:
> >
> > "... expected 7 columns but found 6 - filling the rest with NULL"
> >
> >
> > We have the means to send stdout to /dev/null using the .once or .output
> >
> > Is there a way to send suppress stderr messages for a dot command?
> >
> > If not, can we have one?
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
> > ___
> >  Gunter Hick | Software Engineer | Scientific Games International GmbH |
> > Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 |
> (O)
> > +43 1 80100 - 0
> >
> > May be privileged. May be confidential. Please delete if not the
> addressee.
> > ___
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] shell csv import

[D Burgess]

Thanks hick. But that's not the problem.
The import will always write to stderr, it's not an error
Lots of other stuff in the script and I want to be able to catch any errors
in the other parts of the script.

On Tue, Sep 18, 2018 at 4:20 PM, Hick Gunter  wrote:

> When running a script from the shell, you can redirect stderr tot he null
> device using 2>/dev/null or to the same destination as stdout using 2>&1.
> The latter is also very useful in crontab entries, as neglecting to handle
> stderr will result in an email tot he user that contains anything written
> there
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> Im Auftrag von D Burgess
> Gesendet: Dienstag, 18. September 2018 08:15
> An: sqlite-users@mailinglists.sqlite.org
> Betreff: [EXTERNAL] [sqlite] shell csv import
>
> I have a script that loads csv into an existing table.
>
> I get this message on stderr for each row imported:
>
> "... expected 7 columns but found 6 - filling the rest with NULL"
>
>
> We have the means to send stdout to /dev/null using the .once or .output
>
> Is there a way to send suppress stderr messages for a dot command?
>
> If not, can we have one?
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___
>  Gunter Hick | Software Engineer | Scientific Games International GmbH |
> Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O)
> +43 1 80100 - 0
>
> May be privileged. May be confidential. Please delete if not the addressee.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] shell csv import

[Hick Gunter]

When running a script from the shell, you can redirect stderr tot he null 
device using 2>/dev/null or to the same destination as stdout using 2>&1. The 
latter is also very useful in crontab entries, as neglecting to handle stderr 
will result in an email tot he user that contains anything written there

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von D Burgess
Gesendet: Dienstag, 18. September 2018 08:15
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite] shell csv import

I have a script that loads csv into an existing table.

I get this message on stderr for each row imported:

"... expected 7 columns but found 6 - filling the rest with NULL"


We have the means to send stdout to /dev/null using the .once or .output

Is there a way to send suppress stderr messages for a dot command?

If not, can we have one?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] shell csv import

[D Burgess]

I have a script that loads csv into an existing table.

I get this message on stderr for each row imported:

"... expected 7 columns but found 6 - filling the rest with NULL"


We have the means to send stdout to /dev/null using the .once or .output

Is there a way to send suppress stderr messages for a dot command?

If not, can we have one?
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Last_row_id

[Hick Gunter]

Or maybe also a SELECT ... INTO.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von David Raymond
Gesendet: Montag, 17. September 2018 16:07
An: SQLite mailing list 
Betreff: Re: [sqlite] [EXTERNAL] Last_row_id

I can't seem to find where/if it's mentioned, but I believe the only use of a 
select statement in a trigger is to call the raise function and trigger some 
level of error.

https://www.sqlite.org/lang_createtrigger.html


-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Hick Gunter
Sent: Monday, September 17, 2018 8:06 AM
To: 'SQLite mailing list'
Subject: Re: [sqlite] [EXTERNAL] Last_row_id

A trigger program does not return any result rows.

-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im 
Auftrag von Yadwindersingh
Gesendet: Sonntag, 16. September 2018 03:28
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite] Last_row_id

Hi all;
I am using vs15.x

Create trigger return_pono after insert on po Begin Select last_insert_rowid();

End

Trigger works quite fine in sqlite but fails to return any value to vb.net 
statement

Dim lrow as int64

Lrow = some_cmd.executescalar()


Please help
Thank you


___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___
 Gunter Hick | Software Engineer | Scientific Games International GmbH | 
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 
1 80100 - 0

May be privileged. May be confidential. Please delete if not the addressee.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users