subhasisbehera

Hi, I am trying to read sqlite files in labview of 350 mb size in a computer having 3 gigs of ram and has windows xp. I could read txt files of that size in this computer, even with a 2 gig ram. but, unable to open files of size larger than even 80 megs. I run into out of memory problem. Is there any way I could read this kind of files.

I am using windows XP. have 3 gigs ram. Yes, I try to dump all the contents of 100 mb into 5 different arrays. Is there a better way of doing this? Well, while I was replying, I tried again to generate the error message. But, It worked alright this time. Thanks, Subhasis

Hi, How to read the files. When I try to read a 100 mb file using SQLite_Select, I get the memory full message. Thanks, Subhasis

Thanks, I was actually adding the same column to both create and insert table vis. So, it was showing an error.

The Implode 1D array separates the field/value pairs. The value would be the datatype, isn t it? For example, integer, real etc. So, how should I input these values. If I want the datatype to be real and field name time, should I say "time/real" or "time real" ? Please advise. Thanks, Subhasis

The insert table writes data only as a string. Please guide me, how can I write the data as real.

Hi ShaunR, Yes that worked fine. Thanks, Subhasis

It is looking for labview.exe which it can not find, and so the SQLiteRread Blob could not load.

Hi, I am trying to use the sqlite functions in an executable. DO I need to add something in the installer for this to work successfully? Please guide me. Thanks, Subhasis

Thanks Shaun and Matt. It is working perfectly now.

I found that the speed example also has the same problem. It does not write PASS to the first column. It writes the value in both columns in the DB. Please correct me if I am wrong. Thanks, Subhasis

I am trying to upload some data using bulk insert. I have attached a screenshot of the section. The text table which goes into the Value Table input of the insert table VI shows the data correctly. But the data in the database gets completely jumbled up for some reason. Can you please tell me, what I am doing wrong here. Thanks, Subhasis I am trying to upload some data using bulk insert. I have attached a screenshot of the section. The text table which goes into the Value Table input of the insert table VI shows the data correctly. But the data in the database gets completely jumbled up for some reason. Can you please tell me, what I am doing wrong here. Thanks, Subhasis

Thanks Shaun...

What is the format of the input for value table in SQLite_insert_Table.vi?

Thanks for answering my question. I am lucky that the new version just got released. . Actually every time I will write data to a new file. Which function can I use to create a new file. Is there any difference between using SQLite as a database and writing to it and using it as a file format and storing data in it? Can the later be done by without using the SQL queries? I am completely new in this area. So please ignore if my questions sound foolish. Thanks, Subhasis

Hi, I have just started to use SQLite. I downloaded this toolkit and inserted data to a database using the insert function. But it seemed to be too slow. Is there any functionality in the toolkit, where i can do bulk insert into the db. I have never used any db before. So, I don t know about how fast it could be. My application requires me to write 500 rows and 5 columns of data into one table and about 5 rows and 2 columns into another table in less than 500 milliseconds. Can I do this using bulk insert. Or is there any other way to do this. Thanks in advance, Subhasis