Error Exporting query

Problems, tips, hints - all about usage.

Error Exporting query

Postby janscas » Wed May 31, 2017 3:32 pm

I was trying to export the following simple query and the program can't do it. After a few tries the sqlitestudio crashes.

This is the simple sql executed (fine) but not exported.

Code: Select all
WITH meses(mes_id, mes) AS (
    VALUES (1, 'Enero'), (2, 'Febrero'), (3, 'Marzo'), (4, 'Abril'), (5, 'Mayo'), (6, 'Junio'), (7, 'Julio'), (8, 'Agosto'), (9, 'Septiembre'), (10, 'Octubre'), (11, 'Noviembre'), (12, 'Diciembre')
)
SELECT *
FROM Meses m


This is under windows 8 with sqlitestudio 3.1.1

Any idea why?

Thanks
janscas
 
Posts: 10
Joined: Wed Mar 08, 2017 4:19 pm

Re: Error Exporting query

Postby Googie » Tue Jun 06, 2017 1:32 pm

You say it cannot be exported. What exactly happens when you hit "export"?
Googie
Site Admin
 
Posts: 790
Joined: Wed Jul 27, 2011 8:04 pm

Re: Error Exporting query

Postby janscas » Mon Jun 12, 2017 3:25 pm

It does nothing ... and then crashes.

See https://ibb.co/icdVqv

Clicking Finsish does nothing. And after a few clicks the program crashes.

If instead of clipboard I select file is the same.

Is this happening to you?
janscas
 
Posts: 10
Joined: Wed Mar 08, 2017 4:19 pm

Re: Error Exporting query

Postby Googie » Fri Jun 16, 2017 12:09 pm

It may be related to the "WITH" statement. It is correct, but maybe there's a bug in SQLiteStudio that is affected by the "WITH".

Can you try to export some simple SELECT * FROM table ?
Googie
Site Admin
 
Posts: 790
Joined: Wed Jul 27, 2011 8:04 pm

Re: Error Exporting query

Postby janscas » Tue Jun 20, 2017 8:07 am

A simple select works (SELECT * FROM TABLE).
janscas
 
Posts: 10
Joined: Wed Mar 08, 2017 4:19 pm

Re: Error Exporting query

Postby Googie » Tue Jun 27, 2017 8:30 am

Then this is some bug. Reported for tracking and fixing: https://bugs.sqlitestudio.pl/index.rvt?id=3327
Googie
Site Admin
 
Posts: 790
Joined: Wed Jul 27, 2011 8:04 pm

Re: Error Exporting query

Postby janscas » Tue Oct 31, 2017 4:50 pm

Googie wrote:Then this is some bug. Reported for tracking and fixing: https://bugs.sqlitestudio.pl/index.rvt?id=3327



Hello Googie, have you been able to look at this?

SqliteStudio rocks but not being able to use WITH statements is very anoying.

Thanks for all!
janscas
 
Posts: 10
Joined: Wed Mar 08, 2017 4:19 pm

Re: Error Exporting query

Postby Googie » Thu Nov 09, 2017 3:13 pm

No, not yet. I dont' have time to do it anytime soon. Unfortunately. I will get back to working more actively on the project, just not in nearest future.
Googie
Site Admin
 
Posts: 790
Joined: Wed Jul 27, 2011 8:04 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 1 guest

cron