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