Android Question Error: object should first be initialized

MarcioCC · Jul 15, 2017

Good evening, I have the following code that is generating the following error: object should first be initialized.
What am I doing wrong??

B4X:

Sub BtnGeraInv_Click

Qry="Select * from PRODUTOS order by CODBARRAS,QUANTIDADE"
Cursor1=SQL.ExecQuery(Qry)
If Cursor1.RowCount=0 Then
   Cursor1.Close
   Return
End If

TextWriter1.Initialize(File.OpenOutput(File.DirDefaultExternal, "coletor.csv", False))

For i = 0 To Cursor1.RowCount-1
   Cursor1.Position=i
   CODBARRAS= Cursor1.GetString("CODBARRAS") 
   QUANTIDADE = Cursor1.GetString("QUANTIDADE") 
   
   TextWriter1.Write(CODBARRAS & "," & QUANTIDADE & Chr(13) & Chr(10))
   
   'TextWriter1.Write(Datex & "," & CC & "," & PC & "," & Qty & "," & Cost & "," & Sent & Chr(13) & Chr(10))
   
Next
TextWriter1.Flush
TextWriter1.Close
Cursor1.Close

mangojack · Jul 15, 2017

Can you post the full error line .. (right click > copy) . It should hint what object is not initialized.

MarcioCC · Jul 15, 2017

Cursor1=SQL.ExecQuery(Qry)

mangojack · Jul 15, 2017

No .. can you post the full LOG error message ..(right click > copy)

Also , where have you declared / initialised the Cursor1 and SQL object ?

Erel · Jul 16, 2017

You should initialize the SQL object in Service_Create of the starter service.

MarcioCC · Jul 17, 2017

Good evening, I declared SQL and Cursor1 in Process_Globals

MarcioCC · Jul 17, 2017

Follows the image of the error message that is giving

MarcioCC · Jul 17, 2017

What place do I have to initialize the object ??

mangojack · Jul 17, 2017

Can you upload your project .. IDE menu File > Export asZip

MarcioCC · Jul 17, 2017

Good afternoon, zip file has 2 mega I can not send how do I ??

mangojack · Jul 18, 2017

Before doing anything.. Does your project include a Starter service ?
If not , Add new service module . Name it 'Starter'
Declare and initialise your SQL object and cursor to this service. (see post #5) Other modules can reference the objects with Starter.SQL etc.
If this does not solve your problem, maybe upload and supply link to external file transfer option .. Dropbox etc.

MarcioCC · Jul 18, 2017

Follows the attached project

MarcioCC · Jul 18, 2017

I can not declare the SQL object and Cursor in the starter module I declare and still gives the error (java.lang.RuntimeException: Object should first be initialized.)
How do I declare and initialize the object in the starter module ??
My project is attached (see post #12)

mangojack · Jul 18, 2017

I could not run the project. All layouts are missing and the ZXScanner lib did not like my setup .. Missing B4a Core files ??
I have moved SQL object to Starter Service. Add your images and main_coleta layout to the project and see if it errors.

I cannot see anything else in the BtnGeraInv click that could cuase the error.

Computersmith64 · Jul 18, 2017

Unless you need to use the results from a single query across multiple subs (which it seems you don't in your code), you should probably declare Cursor1 locally in each sub where you execute a query. This will ensure that the cursor is only created where it's needed & will then be destroyed when the sub exits, so you don't have the overhead of a globally declared cursor, plus you don't run the risk of the cursor inadvertently having data from the wrong query in it.

Also - mangojack is right. Your issue was that although you were declaring SQL1 in your main activity, you weren't initializing it - ie:

B4X:

SQL1.Initialize(Dir as String, FileName as String, CreateIfNecessary as Boolean)

You don't have to declare it in Starter, however doing so means that you can access the one instance of it from any activity, class or code module in your app.

- Colin.

MarcioCC · Jul 19, 2017

Good night, thank you very much for the help problem friends solved.

MarcioCC · Jul 19, 2017

One more question the view listview has some supported limit for information it can handle more than 15,000 records ??

mangojack · Jul 19, 2017

The Listview can handle very large lists .. but do you really need to display all records at once ? ... will the user really scroll through 15,000 + records ?

Maybe look at loading a minimum amount of records and should the user want more .. load more. There are numerous ways you could do this.

This might be of interest .. Start a new thread for any futher questions you might have.
CustomListView with Pull to Refresh ...

MarcioCC · Jul 21, 2017

Good night friend, the app will work like this, it will read the product barcode and play in the listview only this, it will have 2 fields (BARCODE, QUANTITY) listed in the listview.

DonManfred · Jul 21, 2017

should be no problem. I aggree with @mangojack that there is no reason to display 15k+ records in a listview. It may be not funny for the user to search a item in 15.000 lvitems... Or even to have 15k items displayed at all.
I would definetively limit it and load 100 more if the end is reached or so

Android Question Error: object should first be initialized

Member

Expert

Member

Expert

B4X founder

Member

Member

Attachments

Member

Expert

Member

Expert

Member

Attachments

Member

Expert

Attachments

Well-Known Member

Member

Member

Expert

Member

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency