SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.0.199 Pro] - Auto Complete [FIXED]

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.0.199 Pro] - Auto Complete [FIXED]
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [SA 9.0.199 Pro] - Auto Complete [FIXED] Reply with quote
In SQLite, when Auto Complete - Always Fully Qualify Object Names is set to With schema name SA appends the schema name main to temporary tables instead of temp, which in turn leads to no such table errors.


Last edited by gemisigo on Fri Mar 03, 2017 7:55 am; edited 1 time in total
Tue Feb 14, 2017 5:45 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Reply with quote
May I ask for a code snippet that can be used to reproduce this issue?
Tue Feb 14, 2017 11:08 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Sure. It's pretty simple:
Code:

-- PRAGMA temp_store = 2;
DROP TABLE IF EXISTS var_fn;
CREATE TEMP TABLE IF NOT EXISTS var_fn (name text PRIMARY KEY ,value text);


Now type SELECT and select var_fn from the popup. With Auto Complete - Always Fully Qualify Object Names set to With schema name I get the following:
Code:

SELECT
    vf."name",
    vf."value"
FROM
    main.var_fn AS vf

And that fails upon execution with :
Quote:

Execute: ODBC Error (1): SQLExecDirectW Client: 0.9995 Server: 3.15.2 SQL State: HY000 no such table: main.var_fn (1); SELECT vf."name", vf."value" FROM main.var_fn AS vf

Tue Feb 14, 2017 11:21 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
This one is fixed, thank you very much.
Fri Mar 03, 2017 7:56 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.