[V4RB] SQL "Create Table"

[Ruslan Zasukhin]

on 3/10/03 9:34 PM, Frank Bitterlich at bitterlich at gsco.de wrote:

> Official SQL syntax:
> 
> create table MYTABLE (NAME varchar(40), ID int, CREATED timestamp);
> 
> But I don't know if that's the way Valentina does it...
> 
> Cheers,
>  Frank+++
> 
> Erik Mueller-Harder wrote:
>> 
>> After *way* too long, I'm rejoining the fray.  Looks like there have been
>> many developments since I left!
>> 
>> I'm developing a new Rb/Valentina application, and for various reasons I'm
>> trying to do *everything* via SQL.  I've scoured the documentation and
>> examples, but I can't find any example of creating a table via SQL (other
>> than the SQL command reference, which tells me only what the SQL command
>> itself should be).
>> 
>> I've tried this from within the db constructor (in an "if" statement which
>> first checks the sysItem table to see whether the table already exists or
>> not):
>> 
>> vc = new VCursor(me, "create table CompositeData ID string(12,'ASCII')")

Yes Erik,

You have miss () around fields

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------