SQLITE syntax problem

[Berkeley]

I having been digging for hours and staring at the help files but I cannot get this to work for anything. I am pretty sure that the syntax on the _SQLITE_SQLITEEXE line is jacked. I am just trying to import a csv file as quick as possible. I( started reading it in line by line but that is way to slow. Then I thought I had it aced with this but cannot seem to get the sqlite syntax right. I am sorry but although I found the help files for autoit really easy to understand I am having a hard time with the autoit sqlite help files

#include <SQLite.au3>
#include <SQLite.dll.au3>
#include <Array.au3>
#include <String.au3>





local $sOut, $aResult, $iRows, $iColumns, $iRval
$hfile = "C:\Documents and Settings\bjd2483\My Documents\AutoIT\RedlinesQC\begend.txt"

_SQLite_Startup()
_SQLite_Open()

If Not _SQLite_Exec(-1, "CREATE TEMP TABLE begend (BEGDOC STRING, ENDDOC STRING);") = $SQLITE_OK Then _
        MsgBox(16, "SQLite Error", _SQLite_ErrMsg())

_SQLite_SQLiteExe(-1,".mode csv" & @CRLF & ".import '" & ($hFile) & "' begend" & @CRLF,$sOut,-1,true)

; Query
$iRval = _SQLite_GetTable(-1, "SELECT * FROM begend;", $aResult, $iRows, $iColumns)
If $iRval = $SQLITE_OK Then

    _ArrayDisplay($aResult, "Query Result")
Else
    MsgBox(16, "SQLite Error: " & $iRval, _SQLite_ErrMsg())
EndIf


_SQLite_Close()
_SQLite_Shutdown()

Thanks,

Berkeley

Edited December 31, 2010 by Berkeley

[GEOSoft]

This might help you a bit. Use _SQLite_Exec()

http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles

[Berkeley]

Thanks GEO but still not any closer I can get it to import no problem from the cmd prompt but when I try and do it from autoit I get zilch

If Not _SQLite_Exec(-1, "CREATE TEMP TABLE begend (BEGDOC STRING, ENDDOC STRING);") = $SQLITE_OK Then _
        MsgBox(16, "SQLite Error", _SQLite_ErrMsg())

_SQLite_Exec(-1,".mode csv" & @CRLF & ".import " & ($hFile) & " begend" & @CRLF)

[MvGulik]

whatever Edited February 7, 2011 by MvGulik