Your 3 DREAM FEATURE for Vstudio ?

[Ruslan Zasukhin]

On 6/21/05 1:59 AM, "Heinrich Ruoff" <heinrichruoff at gmail.com> wrote:

>> Is this SQL file was produced by Valentina?
> no, it was created for mySQL
> 
> thanks - this is working:
> 
> CREATE TABLE tb_test (
>   artikel INTEGER NOT NULL,
>   datei varchar(255) NOT NULL
> );
> INSERT INTO "tb_test" ( "artikel" , "datei")  VALUES (1,'file1');
> INSERT INTO "tb_test" ( "artikel" , "datei")  VALUES (2,'file2');
> INSERT INTO "tb_test" ( "artikel" , "datei")  VALUES (3,'file3');
> 
> I'll do further testing tomorrow...

Right, now you have correct by SQL92 standard text.

So it looks that mySQL produce non-SQL92 output...bad.

We can easy add support of bigint for example.
But quotes around numbers ??? Why they do this ...
And single quotes around table names...must be double quotes..

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]