Hi,
Can someone please verify that this is the case? I have a temporary
workaround which builds the table from an existing row of another table.
However, even this is of no use if the other table is empty.
Are my assumptions correct? Is this intended?
Regards,
Steve
_____
From: Drew, Stephen
Sent: Monday, July 26, 2004 12:39 PM
To: Drew, Stephen; '[EMAIL PROTECTED]'
Subject: [sqlite] RE: Data Types
This seems to be the result of creating a table as:
CREATE TABLE temp AS SELECT * FROM another_table
Surely the datatypes of the original query (SELECT * FROM another_table)
should be used for the new table temp?
Regards,
Steve
_____
From: Drew, Stephen
Sent: Tuesday, July 20, 2004 5:25 PM
To: Drew, Stephen; '[EMAIL PROTECTED]'
Subject: RE: Data Types
Hello again,
Can anyone answer these simple questions for me?
*
Why is the SHOW_DATATYPES pragma not mentioned on the SQL syntax
page under the PRAGMA keyword section?
*
Do I have to execute the pragma per transaction?
*
If not, why I am intermittently not getting the data types?
Thanks,
Steve
_____
From: Drew, Stephen
Sent: Monday, July 19, 2004 7:09 PM
To: '[EMAIL PROTECTED]'
Subject: Data Types
Hi there,
I am using the PRAGMA command "SHOW_DATATYPES=on". However, not all of my
queries return the datatypes. Has anyone else experienced this problem?
Regards,
Steve
