0001042: Incorrect tables order on "Extract database schema and data

(0000272)
sharpplus (administrator)
2010-06-05 13:25

Thank you for your bug report. I will fix it in the next version

(0000273)
sharpplus (administrator)
2010-06-06 10:18

I just fixed the problem. Please try with the latest version
http://www.sqlitedeveloper.com/downloads/SqliteDev372.zip [^]

(0000277)
rsotolongo (reporter)
2010-07-16 04:51
edited on: 2010-07-16 04:53

The order was improved but not solved. The first .sql file ("TableOrder (ok).sql") is written at hand with the correct order of table according to the dependencies of foreign relationships. The second .sql file ("TableOrder (bug).sql") is the file that SQLite Developer generates in the "Export database schema and data" option.

I think that this tool is amazing but I spend a lot of time fixing sql sentences to export and import schema and data. Thank you...

(0000278)
sharpplus (administrator)
2010-07-18 04:24

Thank you for your report, I will check it as soon as possible.

(0000279)
sharpplus (administrator)
2010-07-24 00:20

Dear Sir,

I just fixed the incorrectly extracted sql , please try with
http://www.sqlitedeveloper.com/downloads/SqliteDev377.zip. [^]

Issue History
Date Modified	Username	Field	Change
2010-06-04 11:03	rsotolongo	New Issue
2010-06-05 13:25	sharpplus	Note Added: 0000272
2010-06-05 13:25	sharpplus	Assigned To	=> sharpplus
2010-06-05 13:25	sharpplus	Status	new => acknowledged
2010-06-06 10:18	sharpplus	Note Added: 0000273
2010-06-06 10:18	sharpplus	Status	acknowledged => closed
2010-06-06 10:18	sharpplus	Resolution	open => fixed
2010-06-06 10:18	sharpplus	Fixed in Version	=> 3.7.x
2010-07-16 04:51	rsotolongo	Note Added: 0000277
2010-07-16 04:51	rsotolongo	Status	closed => feedback
2010-07-16 04:51	rsotolongo	Resolution	fixed => reopened
2010-07-16 04:51	rsotolongo	Issue Monitored: rsotolongo
2010-07-16 04:52	rsotolongo	File Added: TableOrder (ok).sql
2010-07-16 04:52	rsotolongo	File Added: TableOrder (bug).sql
2010-07-16 04:53	rsotolongo	Note Edited: 0000277	View Revisions
2010-07-18 04:24	sharpplus	Note Added: 0000278
2010-07-24 00:20	sharpplus	Note Added: 0000279
2010-07-24 00:20	sharpplus	Status	feedback => closed
2010-07-24 00:20	sharpplus	Resolution	reopened => fixed

Notes
(0000272) sharpplus (administrator) 2010-06-05 13:25	Thank you for your bug report. I will fix it in the next version

(0000273) sharpplus (administrator) 2010-06-06 10:18	I just fixed the problem. Please try with the latest version http://www.sqlitedeveloper.com/downloads/SqliteDev372.zip [^]

(0000277) rsotolongo (reporter) 2010-07-16 04:51 edited on: 2010-07-16 04:53	The order was improved but not solved. The first .sql file ("TableOrder (ok).sql") is written at hand with the correct order of table according to the dependencies of foreign relationships. The second .sql file ("TableOrder (bug).sql") is the file that SQLite Developer generates in the "Export database schema and data" option. I think that this tool is amazing but I spend a lot of time fixing sql sentences to export and import schema and data. Thank you...

(0000278) sharpplus (administrator) 2010-07-18 04:24	Thank you for your report, I will check it as soon as possible.

(0000279) sharpplus (administrator) 2010-07-24 00:20	Dear Sir, I just fixed the incorrectly extracted sql , please try with http://www.sqlitedeveloper.com/downloads/SqliteDev377.zip. [^]

Relationships