System.OutOfMemoryException

skipper

Member
Licensed User
Hello all
I'm trying to load a 21Mb .csv (33 fields) file into a table using the following lines

B4X:
Sub Globals
  'Declare the global variables here.
  xSrcPath = AppPath & "\Source"
End Sub

Sub App_Start
   Form1.Show
End Sub

Sub Button1_Click
   tblTemp.Clear
   tblTemp.LoadCSV(xSrcPath & "\" & "hugefile.csv", ";", True,True)
End Sub

The .csv loading stops with the "System.OutOfMemoryException" error. The strange thing is that sometimes the program loads the full table, other times it stops at different record....
Is there any memory limitation on table component? Any suggestion is welcome.

Many thanks
skipper
 

skipper

Member
Licensed User
Hello Erel
that was exactly what I was trying to do ... the subsequent command should have been con.CreateSQLTable(...)
Anyway, I converted the csv into a sql table with an external program...

Thanks
skipper
 

skipper

Member
Licensed User
I can't remember, but it seems to me that the freeware version does not have the import/export functionalities...

Mimmo
 

mjcoon

Well-Known Member
Licensed User
I can't remember, but it seems to me that the freeware version does not have the import/export functionalities...

Ah, the "Feature comparison" chart supports that recollection, so maybe I will be de-installing pronto...

Mike.
 

skipper

Member
Licensed User
Sorry Mike,
as I said, I can't remember, may be I'm wrong. I used the freeware version more o less one year ago, then I switched to the Pro...

Merry Christmas and Happy New Year to you!

Mimmo
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…