Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql
Search options not deleted
user 75874
Acronym for Structured Query Language. A syntax for retrieving and manipulating data from a relational database.
4
votes
1
answer
298
views
SQLite create view syntax error in ArcPy Python script tool only
Here is the code that executes the sql statement:
import sqlite3
from sqlite3 import Error
import sys
with open(sql_file, 'r') as file:
sql = file.read()
try:
c = conn.cursor() … statements to create the tables referenced in the SQL statement above. …
- 85
2
votes
SQLite create view syntax error in ArcPy Python script tool only
SQLite distributed with ArcDesktop 10.4 (SQLite version 3.6.21) where 'WITH' statements are not implemented (they were implemented in 3.8.3)
If updating SQLite is not an option (as it isn't for me), any SQL … Here is how I re-wrote the SQL to accomplish this:
CREATE VIEW IF NOT EXISTS view_desktop_results AS
SELECT m.map_unit_id,
m.map_unit_name,
m.meadow,
(CASE WHEN m.conifer_phase …
- 85