Clemens Ladisch wrote...
To: <sqlite-users@sqlite.org>
Sent: Friday, January 31, 2014 1:32 PM
Subject: Re: [sqlite] Error: near "SELECT": syntax error
jose isaias cabrera wrote:
INSERT OR REPLACE INTO LSOpenProjects
(
SELECT ...
)
SQL does not allow parentheses here.
all records ... that the localDB UpdateDate is NOT equal to the sharedDB
UpdateDate
This description is meaningless if you do not specify which records are to
be
compared, but it looks as if you need "IN" instead of "=".
thanks, Clemens. I also was missing a semicolon before the END;, so, now
this command is working perfectly:
BEGIN; INSERT OR REPLACE INTO LSOpenProjects
SELECT * FROM client.LSOpenProjects WHERE id IN
(SELECT id from LSOpenProjects WHERE
login != '20513925' AND
id = client.LSOpenProjects.id
AND XtraB != client.LSOpenProjects.XtraB
);
END;
But, it is taking a real long time. This is the EXPLAIN QUERY PLAN for it:
sqlite> EXPLAIN INSERT OR REPLACE INTO LSOpenJobs SELECT * FROM
client.LSOpenJobs WHERE id IN (SELECT id from LSOpenJobs WHERE login !=
'user1' AND id = client.LSOpenJobs.id AND XtraB != client.LSOpenJobs.XtraB);
0|Trace|0|0|0||00|
1|Goto|0|614|0||00|
2|Integer|4|1|0||00|
3|Integer|0|2|0||00|
4|Goto|0|84|0||00|
5|OpenRead|0|7|2|51|00|
6|Rewind|0|80|0||00|
7|Null|0|3|0||00|
8|Null|0|3|0||00|
9|OpenEphemeral|3|1|0|k(1,nil)|00|
10|OpenRead|1|9|0|47|00|
11|Rowid|0|4|0||00|
12|MustBeInt|4|22|0||00|
13|NotExists|1|22|4||00|
14|Column|1|5|5||00|
15|Eq|6|22|5|(BINARY)|6a|
16|Column|1|46|7||00|
17|Column|0|46|8||00|
18|Eq|8|22|7|(BINARY)|6a|
19|Rowid|1|9|0||00|
20|MakeRecord|9|1|8|c|00|
21|IdxInsert|3|8|0||00|
22|Close|1|0|0||00|
23|Rowid|0|8|0||00|
24|IsNull|8|79|0||00|
25|Affinity|8|1|0|c|00|
26|NotFound|3|79|8|1|00|
27|Rowid|0|10|0||00|
28|Column|0|1|11||00|
29|Column|0|2|12||00|
30|Column|0|3|13||00|
31|Column|0|4|14||00|
32|Column|0|5|15||00|
33|Column|0|6|16||00|
34|Column|0|7|17||00|
35|Column|0|8|18||00|
36|Column|0|9|19||00|
37|Column|0|10|20||00|
38|Column|0|11|21||00|
39|Column|0|12|22||00|
40|Column|0|13|23||00|
41|Column|0|14|24||00|
42|Column|0|15|25||00|
43|Column|0|16|26||00|
44|Column|0|17|27||00|
45|Column|0|18|28||00|
46|Column|0|19|29||00|
47|Column|0|20|30||00|
48|Column|0|21|31||00|
49|Column|0|22|32||00|
50|Column|0|23|33||00|
51|Column|0|24|34||00|
52|Column|0|25|35||00|
53|Column|0|26|36||00|
54|Column|0|27|37||00|
55|Column|0|28|38||00|
56|Column|0|29|39||00|
57|Column|0|30|40||00|
58|Column|0|31|41||00|
59|Column|0|32|42||00|
60|Column|0|33|43||00|
61|Column|0|34|44||00|
62|Column|0|35|45||00|
63|Column|0|36|46||00|
64|Column|0|37|47||00|
65|Column|0|38|48||00|
66|Column|0|39|49||00|
67|Column|0|40|50||00|
68|Column|0|41|51||00|
69|Column|0|42|52||00|
70|Column|0|43|53||00|
71|Column|0|44|54||00|
72|Column|0|45|55||00|
73|Column|0|46|56||00|
74|Column|0|47|57||00|
75|Column|0|48|58||00|
76|Column|0|49|59||00|
77|Column|0|50|60||00|
78|Yield|1|0|0||00|
79|Next|0|7|0||01|
80|Close|0|0|0||00|
81|Integer|1|2|0||00|
82|Yield|1|0|0||00|
83|Halt|2|2|0||00|
84|OpenEphemeral|4|51|0||00|
85|Yield|1|0|0||00|
86|If|2|91|0||00|
87|MakeRecord|10|51|8||00|
88|NewRowid|4|7|0||00|
89|Insert|4|8|7||00|
90|Goto|0|85|0||00|
91|OpenWrite|5|9|0|51|00|
92|OpenWrite|6|55895|0|k(2,B,B)|00|
93|OpenWrite|7|53025|0|k(2,B,B)|00|
94|OpenWrite|8|53009|0|k(2,B,B)|00|
95|OpenWrite|9|52987|0|k(2,B,B)|00|
96|OpenWrite|10|52971|0|k(2,B,B)|00|
97|OpenWrite|11|52927|0|k(2,B,B)|00|
98|OpenWrite|12|52910|0|k(2,B,B)|00|
99|OpenWrite|13|52890|0|k(2,B,B)|00|
100|OpenWrite|14|52870|0|k(2,B,B)|00|
101|OpenWrite|15|52851|0|k(2,B,B)|00|
102|OpenWrite|16|52830|0|k(2,B,B)|00|
103|OpenWrite|17|52815|0|k(2,B,B)|00|
104|OpenWrite|18|52800|0|k(2,B,B)|00|
105|OpenWrite|19|28732|0|k(2,B,B)|00|
106|OpenWrite|20|28717|0|k(2,B,B)|00|
107|OpenWrite|21|28697|0|k(2,B,B)|00|
108|OpenWrite|22|28682|0|k(2,B,B)|00|
109|OpenWrite|23|28667|0|k(2,B,B)|00|
110|OpenWrite|24|28624|0|k(2,B,B)|00|
111|OpenWrite|25|28601|0|k(2,B,B)|00|
112|OpenWrite|26|28585|0|k(2,B,B)|00|
113|OpenWrite|27|28568|0|k(2,B,B)|00|
114|OpenWrite|28|28552|0|k(2,B,B)|00|
115|OpenWrite|29|28290|0|k(2,B,B)|00|
116|OpenWrite|30|28273|0|k(2,B,B)|00|
117|OpenWrite|31|28257|0|k(2,B,B)|00|
118|OpenWrite|32|28242|0|k(2,B,B)|00|
119|OpenWrite|33|28166|0|k(2,B,B)|00|
120|OpenWrite|34|28061|0|k(2,B,B)|00|
121|OpenWrite|35|27955|0|k(2,B,B)|00|
122|OpenWrite|36|27928|0|k(2,B,B)|00|
123|OpenWrite|37|27911|0|k(2,B,B)|00|
124|OpenWrite|38|27892|0|k(2,B,B)|00|
125|OpenWrite|39|27873|0|k(2,B,B)|00|
126|OpenWrite|40|27849|0|k(2,B,B)|00|
127|OpenWrite|41|27834|0|k(2,B,B)|00|
128|OpenWrite|42|27806|0|k(2,B,B)|00|
129|OpenWrite|43|27758|0|k(2,B,B)|00|
130|OpenWrite|44|27735|0|k(2,B,B)|00|
131|OpenWrite|45|27705|0|k(2,B,B)|00|
132|OpenWrite|46|27674|0|k(2,B,B)|00|
133|OpenWrite|47|27643|0|k(2,B,B)|00|
134|OpenWrite|48|27617|0|k(2,B,B)|00|
135|OpenWrite|49|27590|0|k(2,B,B)|00|
136|OpenWrite|50|27551|0|k(2,B,B)|00|
137|OpenWrite|51|27525|0|k(2,B,B)|00|
138|OpenWrite|52|27497|0|k(2,B,B)|00|
139|OpenWrite|53|27481|0|k(2,B,B)|00|
140|OpenWrite|54|27424|0|k(2,B,B)|00|
141|OpenWrite|55|27406|0|k(2,B,B)|00|
142|OpenWrite|56|27382|0|k(2,B,B)|00|
143|Rewind|4|560|0||00|
144|Column|4|0|112||00|
145|NotNull|112|147|0||00|
146|NewRowid|5|112|0||00|
147|MustBeInt|112|0|0||00|
148|Null|0|113|0||00|
149|Column|4|1|114||00|
150|Column|4|2|115||00|
151|Column|4|3|116||00|
152|Column|4|4|117||00|
153|Column|4|5|118||00|
154|Column|4|6|119||00|
155|Column|4|7|120||00|
156|Column|4|8|121||00|
157|Column|4|9|122||00|
158|Column|4|10|123||00|
159|Column|4|11|124||00|
160|Column|4|12|125||00|
161|Column|4|13|126||00|
162|Column|4|14|127||00|
163|Column|4|15|128||00|
164|Column|4|16|129||00|
165|Column|4|17|130||00|
166|Column|4|18|131||00|
167|Column|4|19|132||00|
168|Column|4|20|133||00|
169|Column|4|21|134||00|
170|Column|4|22|135||00|
171|Column|4|23|136||00|
172|Column|4|24|137||00|
173|Column|4|25|138||00|
174|Column|4|26|139||00|
175|Column|4|27|140||00|
176|Column|4|28|141||00|
177|Column|4|29|142||00|
178|Column|4|30|143||00|
179|Column|4|31|144||00|
180|Column|4|32|145||00|
181|Column|4|33|146||00|
182|Column|4|34|147||00|
183|Column|4|35|148||00|
184|Column|4|36|149||00|
185|Column|4|37|150||00|
186|Column|4|38|151||00|
187|Column|4|39|152||00|
188|Column|4|40|153||00|
189|Column|4|41|154||00|
190|Column|4|42|155||00|
191|Column|4|43|156||00|
192|Column|4|44|157||00|
193|Column|4|45|158||00|
194|Column|4|46|159||00|
195|Column|4|47|160||00|
196|Column|4|48|161||00|
197|Column|4|49|162||00|
198|Column|4|50|163||00|
199|NotExists|5|353|112||00|
200|Rowid|5|164|0||00|
201|Rowid|5|165|0||00|
202|IdxDelete|6|164|2||00|
203|Column|5|50|164||00|
204|Rowid|5|165|0||00|
205|IdxDelete|7|164|2||00|
206|Column|5|49|164||00|
207|Rowid|5|165|0||00|
208|IdxDelete|8|164|2||00|
209|Column|5|48|164||00|
210|Rowid|5|165|0||00|
211|IdxDelete|9|164|2||00|
212|Column|5|47|164||00|
213|Rowid|5|165|0||00|
214|IdxDelete|10|164|2||00|
215|Column|5|46|164||00|
216|Rowid|5|165|0||00|
217|IdxDelete|11|164|2||00|
218|Column|5|45|164||00|
219|Rowid|5|165|0||00|
220|IdxDelete|12|164|2||00|
221|Column|5|44|164||00|
222|Rowid|5|165|0||00|
223|IdxDelete|13|164|2||00|
224|Column|5|43|164||00|
225|Rowid|5|165|0||00|
226|IdxDelete|14|164|2||00|
227|Column|5|42|164||00|
228|Rowid|5|165|0||00|
229|IdxDelete|15|164|2||00|
230|Column|5|41|164||00|
231|Rowid|5|165|0||00|
232|IdxDelete|16|164|2||00|
233|Column|5|40|164||00|
234|Rowid|5|165|0||00|
235|IdxDelete|17|164|2||00|
236|Column|5|39|164||00|
237|Rowid|5|165|0||00|
238|IdxDelete|18|164|2||00|
239|Column|5|38|164||00|
240|Rowid|5|165|0||00|
241|IdxDelete|19|164|2||00|
242|Column|5|37|164||00|
243|Rowid|5|165|0||00|
244|IdxDelete|20|164|2||00|
245|Column|5|36|164||00|
246|Rowid|5|165|0||00|
247|IdxDelete|21|164|2||00|
248|Column|5|35|164||00|
249|Rowid|5|165|0||00|
250|IdxDelete|22|164|2||00|
251|Column|5|34|164||00|
252|Rowid|5|165|0||00|
253|IdxDelete|23|164|2||00|
254|Column|5|33|164||00|
255|Rowid|5|165|0||00|
256|IdxDelete|24|164|2||00|
257|Column|5|32|164||00|
258|Rowid|5|165|0||00|
259|IdxDelete|25|164|2||00|
260|Column|5|31|164||00|
261|Rowid|5|165|0||00|
262|IdxDelete|26|164|2||00|
263|Column|5|30|164||00|
264|Rowid|5|165|0||00|
265|IdxDelete|27|164|2||00|
266|Column|5|29|164||00|
267|Rowid|5|165|0||00|
268|IdxDelete|28|164|2||00|
269|Column|5|28|164||00|
270|Rowid|5|165|0||00|
271|IdxDelete|29|164|2||00|
272|Column|5|27|164||00|
273|Rowid|5|165|0||00|
274|IdxDelete|30|164|2||00|
275|Column|5|26|164||00|
276|Rowid|5|165|0||00|
277|IdxDelete|31|164|2||00|
278|Column|5|25|164||00|
279|Rowid|5|165|0||00|
280|IdxDelete|32|164|2||00|
281|Column|5|24|164||00|
282|Rowid|5|165|0||00|
283|IdxDelete|33|164|2||00|
284|Column|5|23|164||00|
285|Rowid|5|165|0||00|
286|IdxDelete|34|164|2||00|
287|Column|5|22|164||00|
288|Rowid|5|165|0||00|
289|IdxDelete|35|164|2||00|
290|Column|5|21|164||00|
291|Rowid|5|165|0||00|
292|IdxDelete|36|164|2||00|
293|Column|5|20|164||00|
294|Rowid|5|165|0||00|
295|IdxDelete|37|164|2||00|
296|Column|5|19|164||00|
297|Rowid|5|165|0||00|
298|IdxDelete|38|164|2||00|
299|Column|5|18|164||00|
300|Rowid|5|165|0||00|
301|IdxDelete|39|164|2||00|
302|Column|5|17|164||00|
303|Rowid|5|165|0||00|
304|IdxDelete|40|164|2||00|
305|Column|5|16|164||00|
306|Rowid|5|165|0||00|
307|IdxDelete|41|164|2||00|
308|Column|5|15|164||00|
309|Rowid|5|165|0||00|
310|IdxDelete|42|164|2||00|
311|Column|5|14|164||00|
312|Rowid|5|165|0||00|
313|IdxDelete|43|164|2||00|
314|Column|5|13|164||00|
315|Rowid|5|165|0||00|
316|IdxDelete|44|164|2||00|
317|Column|5|12|164||00|
318|Rowid|5|165|0||00|
319|IdxDelete|45|164|2||00|
320|Column|5|11|164||00|
321|Rowid|5|165|0||00|
322|IdxDelete|46|164|2||00|
323|Column|5|10|164||00|
324|Rowid|5|165|0||00|
325|IdxDelete|47|164|2||00|
326|Column|5|9|164||00|
327|Rowid|5|165|0||00|
328|IdxDelete|48|164|2||00|
329|Column|5|8|164||00|
330|Rowid|5|165|0||00|
331|IdxDelete|49|164|2||00|
332|Column|5|7|164||00|
333|Rowid|5|165|0||00|
334|IdxDelete|50|164|2||00|
335|Column|5|6|164||00|
336|Rowid|5|165|0||00|
337|IdxDelete|51|164|2||00|
338|Column|5|5|164||00|
339|Rowid|5|165|0||00|
340|IdxDelete|52|164|2||00|
341|Column|5|4|164||00|
342|Rowid|5|165|0||00|
343|IdxDelete|53|164|2||00|
344|Column|5|3|164||00|
345|Rowid|5|165|0||00|
346|IdxDelete|54|164|2||00|
347|Column|5|2|164||00|
348|Rowid|5|165|0||00|
349|IdxDelete|55|164|2||00|
350|Column|5|1|164||00|
351|Rowid|5|165|0||00|
352|IdxDelete|56|164|2||00|
353|SCopy|112|164|0||00|
354|SCopy|112|165|0||00|
355|MakeRecord|164|2|61|dd|00|
356|SCopy|163|164|0||00|
357|SCopy|112|165|0||00|
358|MakeRecord|164|2|62|bd|00|
359|SCopy|162|164|0||00|
360|SCopy|112|165|0||00|
361|MakeRecord|164|2|63|bd|00|
362|SCopy|161|164|0||00|
363|SCopy|112|165|0||00|
364|MakeRecord|164|2|64|bd|00|
365|SCopy|160|164|0||00|
366|SCopy|112|165|0||00|
367|MakeRecord|164|2|65|bd|00|
368|SCopy|159|164|0||00|
369|SCopy|112|165|0||00|
370|MakeRecord|164|2|66|bd|00|
371|SCopy|158|164|0||00|
372|SCopy|112|165|0||00|
373|MakeRecord|164|2|67|bd|00|
374|SCopy|157|164|0||00|
375|SCopy|112|165|0||00|
376|MakeRecord|164|2|68|bd|00|
377|SCopy|156|164|0||00|
378|SCopy|112|165|0||00|
379|MakeRecord|164|2|69|bd|00|
380|SCopy|155|164|0||00|
381|SCopy|112|165|0||00|
382|MakeRecord|164|2|70|bd|00|
383|SCopy|154|164|0||00|
384|SCopy|112|165|0||00|
385|MakeRecord|164|2|71|bd|00|
386|SCopy|153|164|0||00|
387|SCopy|112|165|0||00|
388|MakeRecord|164|2|72|bd|00|
389|SCopy|152|164|0||00|
390|SCopy|112|165|0||00|
391|MakeRecord|164|2|73|bd|00|
392|SCopy|151|164|0||00|
393|SCopy|112|165|0||00|
394|MakeRecord|164|2|74|bd|00|
395|SCopy|150|164|0||00|
396|SCopy|112|165|0||00|
397|MakeRecord|164|2|75|bd|00|
398|SCopy|149|164|0||00|
399|SCopy|112|165|0||00|
400|MakeRecord|164|2|76|bd|00|
401|SCopy|148|164|0||00|
402|SCopy|112|165|0||00|
403|MakeRecord|164|2|77|bd|00|
404|SCopy|147|164|0||00|
405|SCopy|112|165|0||00|
406|MakeRecord|164|2|78|bd|00|
407|SCopy|146|164|0||00|
408|SCopy|112|165|0||00|
409|MakeRecord|164|2|79|bd|00|
410|SCopy|145|164|0||00|
411|SCopy|112|165|0||00|
412|MakeRecord|164|2|80|bd|00|
413|SCopy|144|164|0||00|
414|SCopy|112|165|0||00|
415|MakeRecord|164|2|81|bd|00|
416|SCopy|143|164|0||00|
417|SCopy|112|165|0||00|
418|MakeRecord|164|2|82|bd|00|
419|SCopy|142|164|0||00|
420|SCopy|112|165|0||00|
421|MakeRecord|164|2|83|bd|00|
422|SCopy|141|164|0||00|
423|SCopy|112|165|0||00|
424|MakeRecord|164|2|84|bd|00|
425|SCopy|140|164|0||00|
426|SCopy|112|165|0||00|
427|MakeRecord|164|2|85|bd|00|
428|SCopy|139|164|0||00|
429|SCopy|112|165|0||00|
430|MakeRecord|164|2|86|bd|00|
431|SCopy|138|164|0||00|
432|SCopy|112|165|0||00|
433|MakeRecord|164|2|87|bd|00|
434|SCopy|137|164|0||00|
435|SCopy|112|165|0||00|
436|MakeRecord|164|2|88|bd|00|
437|SCopy|136|164|0||00|
438|SCopy|112|165|0||00|
439|MakeRecord|164|2|89|bd|00|
440|SCopy|135|164|0||00|
441|SCopy|112|165|0||00|
442|MakeRecord|164|2|90|bd|00|
443|SCopy|134|164|0||00|
444|SCopy|112|165|0||00|
445|MakeRecord|164|2|91|bd|00|
446|SCopy|133|164|0||00|
447|SCopy|112|165|0||00|
448|MakeRecord|164|2|92|bd|00|
449|SCopy|132|164|0||00|
450|SCopy|112|165|0||00|
451|MakeRecord|164|2|93|bd|00|
452|SCopy|131|164|0||00|
453|SCopy|112|165|0||00|
454|MakeRecord|164|2|94|bd|00|
455|SCopy|130|164|0||00|
456|SCopy|112|165|0||00|
457|MakeRecord|164|2|95|bd|00|
458|SCopy|129|164|0||00|
459|SCopy|112|165|0||00|
460|MakeRecord|164|2|96|bd|00|
461|SCopy|128|164|0||00|
462|SCopy|112|165|0||00|
463|MakeRecord|164|2|97|bd|00|
464|SCopy|127|164|0||00|
465|SCopy|112|165|0||00|
466|MakeRecord|164|2|98|bd|00|
467|SCopy|126|164|0||00|
468|SCopy|112|165|0||00|
469|MakeRecord|164|2|99|bd|00|
470|SCopy|125|164|0||00|
471|SCopy|112|165|0||00|
472|MakeRecord|164|2|100|bd|00|
473|SCopy|124|164|0||00|
474|SCopy|112|165|0||00|
475|MakeRecord|164|2|101|bd|00|
476|SCopy|123|164|0||00|
477|SCopy|112|165|0||00|
478|MakeRecord|164|2|102|bd|00|
479|SCopy|122|164|0||00|
480|SCopy|112|165|0||00|
481|MakeRecord|164|2|103|bd|00|
482|SCopy|121|164|0||00|
483|SCopy|112|165|0||00|
484|MakeRecord|164|2|104|bd|00|
485|SCopy|120|164|0||00|
486|SCopy|112|165|0||00|
487|MakeRecord|164|2|105|bd|00|
488|SCopy|119|164|0||00|
489|SCopy|112|165|0||00|
490|MakeRecord|164|2|106|bd|00|
491|SCopy|118|164|0||00|
492|SCopy|112|165|0||00|
493|MakeRecord|164|2|107|bd|00|
494|SCopy|117|164|0||00|
495|SCopy|112|165|0||00|
496|MakeRecord|164|2|108|bd|00|
497|SCopy|116|164|0||00|
498|SCopy|112|165|0||00|
499|MakeRecord|164|2|109|bd|00|
500|SCopy|115|164|0||00|
501|SCopy|112|165|0||00|
502|MakeRecord|164|2|110|dd|00|
503|SCopy|114|164|0||00|
504|SCopy|112|165|0||00|
505|MakeRecord|164|2|111|dd|00|
506|IdxInsert|6|61|0||00|
507|IdxInsert|7|62|0||00|
508|IdxInsert|8|63|0||00|
509|IdxInsert|9|64|0||00|
510|IdxInsert|10|65|0||00|
511|IdxInsert|11|66|0||00|
512|IdxInsert|12|67|0||00|
513|IdxInsert|13|68|0||00|
514|IdxInsert|14|69|0||00|
515|IdxInsert|15|70|0||00|
516|IdxInsert|16|71|0||00|
517|IdxInsert|17|72|0||00|
518|IdxInsert|18|73|0||00|
519|IdxInsert|19|74|0||00|
520|IdxInsert|20|75|0||00|
521|IdxInsert|21|76|0||00|
522|IdxInsert|22|77|0||00|
523|IdxInsert|23|78|0||00|
524|IdxInsert|24|79|0||00|
525|IdxInsert|25|80|0||00|
526|IdxInsert|26|81|0||00|
527|IdxInsert|27|82|0||00|
528|IdxInsert|28|83|0||00|
529|IdxInsert|29|84|0||00|
530|IdxInsert|30|85|0||00|
531|IdxInsert|31|86|0||00|
532|IdxInsert|32|87|0||00|
533|IdxInsert|33|88|0||00|
534|IdxInsert|34|89|0||00|
535|IdxInsert|35|90|0||00|
536|IdxInsert|36|91|0||00|
537|IdxInsert|37|92|0||00|
538|IdxInsert|38|93|0||00|
539|IdxInsert|39|94|0||00|
540|IdxInsert|40|95|0||00|
541|IdxInsert|41|96|0||00|
542|IdxInsert|42|97|0||00|
543|IdxInsert|43|98|0||00|
544|IdxInsert|44|99|0||00|
545|IdxInsert|45|100|0||00|
546|IdxInsert|46|101|0||00|
547|IdxInsert|47|102|0||00|
548|IdxInsert|48|103|0||00|
549|IdxInsert|49|104|0||00|
550|IdxInsert|50|105|0||00|
551|IdxInsert|51|106|0||00|
552|IdxInsert|52|107|0||00|
553|IdxInsert|53|108|0||00|
554|IdxInsert|54|109|0||00|
555|IdxInsert|55|110|0||00|
556|IdxInsert|56|111|0||00|
557|MakeRecord|113|51|7|dddbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|00|
558|Insert|5|7|112|LSOpenJobs|03|
559|Next|4|144|0||00|
560|Close|4|0|0||00|
561|Close|5|0|0||00|
562|Close|6|0|0||00|
563|Close|7|0|0||00|
564|Close|8|0|0||00|
565|Close|9|0|0||00|
566|Close|10|0|0||00|
567|Close|11|0|0||00|
568|Close|12|0|0||00|
569|Close|13|0|0||00|
570|Close|14|0|0||00|
571|Close|15|0|0||00|
572|Close|16|0|0||00|
573|Close|17|0|0||00|
574|Close|18|0|0||00|
575|Close|19|0|0||00|
576|Close|20|0|0||00|
577|Close|21|0|0||00|
578|Close|22|0|0||00|
579|Close|23|0|0||00|
580|Close|24|0|0||00|
581|Close|25|0|0||00|
582|Close|26|0|0||00|
583|Close|27|0|0||00|
584|Close|28|0|0||00|
585|Close|29|0|0||00|
586|Close|30|0|0||00|
587|Close|31|0|0||00|
588|Close|32|0|0||00|
589|Close|33|0|0||00|
590|Close|34|0|0||00|
591|Close|35|0|0||00|
592|Close|36|0|0||00|
593|Close|37|0|0||00|
594|Close|38|0|0||00|
595|Close|39|0|0||00|
596|Close|40|0|0||00|
597|Close|41|0|0||00|
598|Close|42|0|0||00|
599|Close|43|0|0||00|
600|Close|44|0|0||00|
601|Close|45|0|0||00|
602|Close|46|0|0||00|
603|Close|47|0|0||00|
604|Close|48|0|0||00|
605|Close|49|0|0||00|
606|Close|50|0|0||00|
607|Close|51|0|0||00|
608|Close|52|0|0||00|
609|Close|53|0|0||00|
610|Close|54|0|0||00|
611|Close|55|0|0||00|
612|Close|56|0|0||00|
613|Halt|0|0|0||00|
614|Transaction|0|1|0||00|
615|VerifyCookie|0|246|0||00|
616|Transaction|2|0|0||00|
617|VerifyCookie|2|477|0||00|
618|TableLock|2|7|0|LSOpenJobs|00|
619|TableLock|0|9|1|LSOpenJobs|00|
620|String8|0|6|0|20513925|00|
621|Goto|0|2|0||00|
sqlite>
Thanks for the help.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
