Very long strings

kszymanski

Hi!

I write a small Report that delivers some
Navision-Tabledata to one of our MySQL-Servers. This is working so far. But...

Now i wan't to export a Table with much fields so that the 'INSERT INTO *'-String gets very long (round about 1000 chars). If
i try to write the string to a file:

FH.WRITE( 'INSERT INTO test (x1,x2,x3...)
VALUES(y1,y2,y3...);');

I get an error:

Not enought memory on C/AL Stack.

Also i try to message the String but then i
get the same error.

How i can handle long string into a file <img border="0" title="" alt="" src="images/smiles/icon_confused.gif" /> ?

Thanks!

Best regards,
Kai.


Thanks

Luc_VanDyck

Maybe you can write 2 SQL-statements. First, use INSERT INTO to create the record into your SQL database, and fill-in some data. Secondly, use UPDATE to add some more data.