Re: Changes in 7.4 re. LONG

Michael Slinn wrote:

> Elke,
> 
> could show me exactly what you mean for an INSERT statement that works. 
...
> If so, then the following is the only syntax that will work
> until the bug is fixed:
> 
> INSERT INTO test2 (
>     fragmentApplet,fragmentCreated,fragmentId
>     ) VALUES (
>     'test applet',123456,3
> )

no,
you can simply insert the timestamp string:

INSERT INTO test2 (
     fragmentApplet,fragmentCreated,fragmentId
     ) VALUES (
     'test applet','1999-01-01 14:30:08',3
)

supported data types for inserts are listed in:
http://sapdb.org/7.4/htmhelp/a0/8fa5e82d2e11d3a98100a0c9449261/content.htm


   Henrik