director cannot execute sql query

Babon Support ricky at babonmultimedia.com
Tue Oct 21 23:54:38 CDT 2003


hello i need help, i try to create db and also process query from member
i think there's some error in docreate but i dunno

thanks in a bunch
Ricky

on docreate
    set db = 0
    set dvcursor = 0
    sql = member("sql_query").text
    set db = new( xtra "VDataBase" )
    CreateDatabase( db, member("db_name").text, 1)
    set dbvcursor = new( xtra "Vcursor",GetRef(db),sql,1,3,1)
    alert sql "" && dbvcursor
end

the query is:
CREATE TABLE data
(
fd_Code varchar(20) UNIQUE INDEXED NOT NULL,
fd_Name varchar(50) NULL,
fd_Size varchar(50) NULL,
fd_Colour varchar(50) NULL,
fd_MinOrder varchar(20) NULL)



More information about the Valentina mailing list